[Gambas-user] Embedded Database

[Philip A. Chapman]

Everyone,

As promised when I first brought up SQLite, I have been working on the
ability to use the SQLite library through Gambas' db library.  However,
going has been slow for two reasons.  One, my C skills are not as
advanced as my VB and Java :-)  Two, I've got some paying work which is
taking up a lot of my time.

The typelessness of SQLite is an interesting item.  The exception to
typlessness is when there is a primary key of type integer.  The SQLite
library reports the type as whatever the user specified in the CREATE
TABLE statement; which can be anything.  Therefore, I think that the
driver should only report two data types: varchar and integer (for
primary keys which are integer).  How to determine when it should report
the data type as integer is a problem I have not yet solved.  The driver
may have to report everything as a varchar.

I will continue as I can.  However, if anyone with more skill in the C
language and/or more time wants to take the lead on this, I certainly
would not be offended!


On Tue, 2003-07-08 at 19:05, Nelson Ferraz wrote:
> > So there's definitely a lot more merit to SQLite than I gave it credit for, 
> > though again I suspect it may be faster/easier to just jam embedded MySQL 
> > support in there since there's already normal MySQL support.  I'd be happy 
> > working with either one, I think.
> 
> Another cool feature is that SQLite is typeless:
> 
> http://www.hwaci.com/sw/sqlite/datatypes.html
> 
> Here's a simple C program that demonstrates how to use the C/C++
> interface to SQLite:
> 
> http://www.hwaci.com/sw/sqlite/quickstart.html
> 
> []s
> 
> Nelson
> 
> 
> 
> -------------------------------------------------------
> This SF.Net email sponsored by: Parasoft
> Error proof Web apps, automate testing & more.
> Download & eval WebKing and get a free book.
> www.parasoft.com/bulletproofapps
> _______________________________________________
> Gambas-user mailing list
> Gambas-user at lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/gambas-user
-- 
Philip A. Chapman

Application Development:
Java, Visual Basic, PostgreSQL, MySQL, MSSQL
Linux, Windows 9x, Windows NT, Windows 2000, Windows XP
-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 189 bytes
Desc: This is a digitally signed message part
URL: <http://lists.gambas-basic.org/pipermail/user/attachments/20030708/14bfad7a/attachment.sig>