Andru's WebLog

//Comments about technology and software architecture
> MySelf.Persist();

Published SharpHsql 1.0.3.0

I have just published the new version of SharpHsql on GotDotNet.

This is a minor release, and the changes are:

*- Correct reading of binary (byte[]) columns.
*- Added support for OBJECT data types. All stored objects this way MUST be serializable. The database engine does all the dirty work for you (see ProviderTest for sample code). Please note that this is not supported by the PocketPC version.
*- Implemented more SHOW commands:
     - SHOW ALIAS: list all functions defined in the database.
     - SHOW PARAMETERS xxx: shows the parameters received and returned by the "xxx" alias function.
*- Removed the log4net dependency from the PocketPC version of SharpHsql.
*- Some other minor issues.

Enjoy!

Andrés G Vettori
MCSE/MCSD/MCT
Leader of the C# Community of the Microsoft Users Group Argentina

Posted: May 19 2005, 04:10 PM by andresv | with 5 comment(s)
Filed under:

Comments

Jon Galloway said:

How would you compare this to SQLite (other than the fact that SharpHsql is managed code)?

Also, do you know of any Query Analyzer type programs for SharpHsql?
# May 20, 2005 4:01 AM

Andres G Vettori said:

Well, SharpHsql compares to SQLite almost the same HSQLDB (v1.4.x) compares to SQLite. Personally I haven't any real experience with SQLite, so I will not emit any opinion about that product.

In response to your question about a Query Analyzer for SharpHsql, you are lucky. You can download the hEdit free SQL editor at http://www.devjunkies.com/feed/hedit.htm, made by Martin Carolan (one of the members of the SharpHsql GotDotNet Workspace).

Best regards,

Andres.
# May 20, 2005 12:25 PM

Javier Luna said:

I believe that any DataLayer must be a simple code block, that they allow operations against DB.

That code block would not have to know on the Business Entities. Single to specialize it is to execute the operations (Store Procedures and SQL Sentences) against the engine DB (SQL, Oracle, DB2, etc.), with which this setting.

Finally, I invite to you to download the DataLayer.Primitives Public Version.

This is very cool Data Layer :)

DataLayer.Primitives - Readme!
http://forums.microsoft.com/msdn/ShowPost.aspx?PostID=1389

Cheers,

Javier Luna
http://guydotnetxmlwebservices.blogspot.com/
# May 26, 2005 10:35 PM

Matt said:

I'm getting an error page when I follow the link to GotDotNet. Is there something wrong with your download page, or just a temporary problem with their servers? I'm looking forward to trying this out, as I was very impressed with the java version and was worried I wouldn't find something as good for .net. Thanks!
# May 30, 2005 11:38 AM

Andres G Vettori said:

Seems that the GotDotNet servers are down again, I haven't been able to enter any workspace all day long. Please try later again, I don't know when the site will be online again.

Thanks for your interest.

Andrés.
# May 30, 2005 12:51 PM
Leave a Comment

(required) 

(required) 

(optional)

(required)