flat assembler
Message board for the users of flat assembler.

Index > Windows > SQLite - interesting for ASM applications...

Author
Thread Post new topic Reply to topic
JohnFound



Joined: 16 Jun 2003
Posts: 3500
Location: Bulgaria
JohnFound
I found very interesting SQL database: SQLite - http://www.sqlite.org/

It is very small (well, relatively Very Happy) -approx. 250kbytes.
IMHO, until we make native FASM SQL database, SQLite is good alternative... if someone needs database engine for assembly programs. Wink

Regards.
Post 04 Jun 2004, 07:48
View user's profile Send private message Visit poster's website ICQ Number Reply with quote
pelaillo
Missing in inaction


Joined: 19 Jun 2003
Posts: 878
Location: Colombia
pelaillo
Hi JohnFound,
I am some starting work to free SQLite from its slight (unnecessary) dependence on MSVCRT.DLL writting equivalent functions in fasm. Once liberated from that, it becomes a very good solution. I like it very much. Very Happy
Post 04 Jun 2004, 13:34
View user's profile Send private message Yahoo Messenger Reply with quote
f0dder



Joined: 19 Feb 2004
Posts: 3170
Location: Denmark
f0dder
Just compile SQLite to a DLL, linked statically against the MSVC runtimes - tada, no dependency on msvcrt.dll Smile
Post 04 Jun 2004, 15:07
View user's profile Send private message Visit poster's website Reply with quote
JohnFound



Joined: 16 Jun 2003
Posts: 3500
Location: Bulgaria
JohnFound
f0dder wrote:
Just compile SQLite to a DLL, linked statically against the MSVC runtimes - tada, no dependency on msvcrt.dll Smile


...and have another extra 300k Wink

But the best is:
SQLite site wrote:
Sources are in the public domain. Use for any purpose.


Regards
Post 04 Jun 2004, 15:44
View user's profile Send private message Visit poster's website ICQ Number Reply with quote
ronware



Joined: 08 Jan 2004
Posts: 179
Location: Israel
ronware
FWIW, I use SQLite for a project for a non-profit I am a member of; it works great, is fast and the developer fixes problems very quickly. I use the DLL version of it, MSVCRT dependent... and my prog is in C++.
Post 04 Jun 2004, 16:31
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger Reply with quote
f0dder



Joined: 19 Feb 2004
Posts: 3170
Location: Denmark
f0dder
Quote:

...and have another extra 300k

Not really... the base overhead of ms libc is around 28kb or so, and then of course the various library routines needed. Statically linked sqlite.dll is ~264kb, and only imports from kernel32.dll. The footprint of including sqlite statically should be almost the same as the dll footprint.
Post 04 Jun 2004, 23:01
View user's profile Send private message Visit poster's website Reply with quote
pelaillo
Missing in inaction


Joined: 19 Jun 2003
Posts: 878
Location: Colombia
pelaillo
But what about the legal aspects concerning a reverse of the MS portion of the code?
I came into the task because my final idea is to have a fasm written standalone sql library to be used in MenuetOS and SolOS.

And I have a fasm equivalent (and improved) for near all of the functions imported by SQLite from MSVCRT. The dependency is too marginal to be considered critical.

And the second reason is that I want to do it Smile.
Post 05 Jun 2004, 15:03
View user's profile Send private message Yahoo Messenger Reply with quote
f0dder



Joined: 19 Feb 2004
Posts: 3170
Location: Denmark
f0dder
Quote:

But what about the legal aspects concerning a reverse of the MS portion of the code?

The only "legal aspects" would be if you used a pirate copy of VC++ to build the DLL... and since vc2003 is now free, well...

So, did you improve on the MS libc code, or did you just write assembly equivalents - there's quite a difference Wink
Post 05 Jun 2004, 22:34
View user's profile Send private message Visit poster's website Reply with quote
pelaillo
Missing in inaction


Joined: 19 Jun 2003
Posts: 878
Location: Colombia
pelaillo
f0dder wrote:
The only "legal aspects" would be if you used a pirate copy of VC++ to build the DLL... and since vc2003 is now free, well...

Free, but not open source. You cannot disassemble it even if you are a proud owner. (Sorry, there is no such a possibility, you cannot own MS software)
Quote:
So, did you improve on the MS libc code, or did you just write assembly equivalents - there's quite a difference Wink

You will be able to judge by yourself. I do like really the open source so if it is not the case, you could contribute to improve it.
Post 06 Jun 2004, 04:20
View user's profile Send private message Yahoo Messenger Reply with quote
f0dder



Joined: 19 Feb 2004
Posts: 3170
Location: Denmark
f0dder
Quote:

Free, but not open source. You cannot disassemble it even if you are a proud owner. (Sorry, there is no such a possibility, you cannot own MS software)

And does that really matter? If you legally own [a license for] VC, you have the runtime library source. Besides, for something like sqlite.dll, the runtime library source wouldn't be very interesting, if you're going to change anything it would be the sqlite source... not that many people around here would have any interest in modifying those sources.

So I still don't really see the issue Smile
Post 06 Jun 2004, 14:25
View user's profile Send private message Visit poster's website Reply with quote
JohnFound



Joined: 16 Jun 2003
Posts: 3500
Location: Bulgaria
JohnFound
f0dder wrote:
So I still don't really see the issue Smile


Well, IMHO, using SQLite for assembly programming can be only temporary solution. The final goal is to have portable SQL database written fully in FASM, with idea to port it to MenuetOS and to ensure that the SQL part of application will be consistent with the remaining assembler part.

Well, I don't like some issues in SQLite - mainly the approach to convert everything to strings back and forth...

Regards.
Post 06 Jun 2004, 15:09
View user's profile Send private message Visit poster's website ICQ Number Reply with quote
f0dder



Joined: 19 Feb 2004
Posts: 3170
Location: Denmark
f0dder
Well, there's a whole bunch of issues with SQLite... it isn't typed, uses strings, is _certainly_ not safe with multiple accesses to the database (well, at least not over a network), etc. But it's easy to use and relatively fast Smile
Post 06 Jun 2004, 23:04
View user's profile Send private message Visit poster's website Reply with quote
Display posts from previous:
Post new topic Reply to topic

Jump to:  


< Last Thread | Next Thread >
Forum Rules:
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You can download files in this forum


Copyright © 1999-2020, Tomasz Grysztar.

Powered by rwasa.