Welcome to Moshine Sign in | Join | Help
Blackfish SQL

Blackfish SQL is a new database from CodeGear, written totally in managed code. It comes in 2 flavors, local and remote. The local version runs in process, so it makes for really easy deployment. For ASP.Net applications you just deploy the Blackfish assemblies and stick your database file in the App_Data directory.

For a dotnet developer writing stored procedures can be a bit of a problem, this is not the case with Blackfish since you can develop them in your dotnet language of choice, In my case thats Delphi. In the screen shot below I am in the debugger stepping through a stored procedure. I think this is extremely cool...

 
 

Published Monday, August 27, 2007 10:36 PM by JohnMoshakis

Comment Notification

If you would like to receive an email when updates are made to this post, please register here

Subscribe to this post's comments using RSS

Comments

# re: Blackfish SQL @ Wednesday, August 29, 2007 8:54 AM

Compared to any DB native language, writing stored procedures this way looks a very tedious task - you have to declare and code everything.

In PL/SQL you would just write

PROCEDURE INSERT_BOOKMARK(ATITLE IN VARCHAR..., ABOOKMARK_ID OUT NUMBER)

IS

BEGIN

 INSERT INTO BOOKMARKS(BOOKMARK_ID, TITLE...

 VALUES(SEQ_BOOKMARKS.NEXTVAL, ATITLE...)

 RETURNING BOOKMAR_ID INTO ABOOKMARK_ID;

END;

and the PL/SQL compiler/engine will take care of parameters, types, assignments... one line of code against how many??? That's probably why almost noone writes Java stored procedures - I'll stay away from .NET ones and BlackFishes too - better to use an Oracle Express instance.

Tired user

# re: Blackfish SQL @ Tuesday, September 04, 2007 12:12 PM

There probably is a method overload that lets you construct and assign a parameter in one line. Also, I think it is not so much about simple SP. It is the compfort of having .NET lib support creating queries and having logic all in the same place.

What would be even more interesting is if it is possible to construct a query in an Objectoriented  style.

Something like

Query q = new Query(DbSchema).Where(...).In(...)

El

El

Leave a Comment

(required) 
required 
(required)