SQLite Wrapper Code

VA Smalltalk is a "100% VisualAge compatible" IDE that includes the original VisualAge technology and the popular VA Assist and WidgetKit add-ons.

Moderators: Eric Clayberg, wembley, tc, Diane Engles, solveig

SQLite Wrapper Code

Postby marten » Sun Dec 10, 2006 12:43 pm

If someone is considering a single user application and looks for a storage database, SQLite (http://www.sqlite.org) may be a good choice for that.

I've written (under Windows) some code to have direct access to that database and this is an early preview of that actual code:

http://www.schrievkrom.de/uk/tips/small ... /index.htm
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Wed Jan 03, 2007 9:50 pm

marten wrote:If someone is considering a single user application and looks for a storage database, SQLite (http://www.sqlite.org) may be a good choice for that.

I've written (under Windows) some code to have direct access to that database and this is an early preview of that actual code:

http://www.schrievkrom.de/uk/tips/small ... /index.htm


I noticed, that several persons tried to download the library and the library was corrupted by my upload. Therefore I've corrected the errors and you all may try it again.

Marten
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Tue Jan 23, 2007 4:32 am

The library 0.90 is published and it runs now under Windows and Linux (after solving the synchronous callouts I mentioned in another thread) and its tested for version 3.3.11 under Windows, which was published today.

The download link has changed. Please enter site via main page "www.schrievkrom.de".

Marten
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Tue Jan 30, 2007 1:19 pm

The library 0.90-2 is published and its tested for version SQLite3 3.3.12.

Download from "www.schrievkrom.de".

Marten
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Tue Jun 12, 2007 9:50 am

The library 0.104 is published and its tested for version SQLite3 3.3.17 under Windows. Lots of code had been rewritten, because I tried to create also the code which is needed to support the official DB API (whatever this is) of VASmalltalk. This Abt-support does not work in this version, but it shows the way ... its a time consuming way to find out, what is needed to fullfill the specification of VASmalltalk. The base wrapper code works.

Download from http://www.schrievkrom.de in the Goodies section.
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Sat Oct 27, 2007 2:17 am

The library 0.105 is published and its tested for version SQLite3 3.5.1 under Windows. Just a maintainance version to include tests for sqlite 3.5.1 - no support for additional API calls introduced with sqlite3 3.4.x and 3.5.x

Download from http://www.schrievkrom.de in the Goodies section.
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Tue Nov 27, 2007 1:05 pm

In the meantime there are wrappers for SQLite 3.5.2 and (today) 3.5.3 - the development has slightly changed. All the code is now in ONE dll under Windows - the wrapper code and the SQLite code. A whole project for Watcom C++ 1.7 is included to rebuild the library on the fly.
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Sat Feb 02, 2008 5:41 am

Now there are wrappers for SQLite 3.5.4 and 3.5.5 ....
Marten Feldtmann, Principal Smalltalk User, Private
SkypeMe callto://marten.feldtmann
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Wed Feb 06, 2008 1:03 pm

.. and now 3.5.6 ...
Marten Feldtmann, Principal Smalltalk User, Private
SkypeMe callto://marten.feldtmann
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Sun May 18, 2008 2:12 pm

.. and now 3.5.9 ... for both Linux (with open points) and Windows

http://www.schrievkrom.de/extfiles/MSKSQLite-359-3.zip
Marten Feldtmann, Principal Smalltalk User, Private
SkypeMe callto://marten.feldtmann
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Fri Sep 05, 2008 12:25 pm

Version 3.6.2 is now supported and out ...
Marten Feldtmann, Principal Smalltalk User, Private
SkypeMe callto://marten.feldtmann
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany

Re: SQLite Wrapper Code

Postby marten » Tue Jan 20, 2009 11:43 am

After some months a new version. This time for SQLite 3.6.10. I stopped development for 7.5.2 - this code has been configured against 8.0 Beta 1. Nothing really new - only new version specific test methods. The dynamic link library has been compiled with Watcom 1.8 RC2 and is also included in that library. You may download it from http://www.schrievkrom.de/blog/?cat=4
Marten Feldtmann, Principal Smalltalk User, Private
SkypeMe callto://marten.feldtmann
marten
[|]
 
Posts: 641
Joined: Sat Oct 14, 2006 7:10 am
Location: Hamburg - Germany


Return to VA Smalltalk 7.0, 7.5 & 8.0

Who is online

Users browsing this forum: No registered users and 1 guest