flat assembler
Message board for the users of flat assembler.

Index > Main > Simple example with SQLite.

Author
Thread Post new topic Reply to topic
JohnFound



Joined: 16 Jun 2003
Posts: 3502
Location: Bulgaria
JohnFound
Playing with SQLite, I decided to write a simple example, that to help people willing to use excelent (only not so small) database engine SQLite.
In order to keep it as simple as possible, there is no any error check in the example.

[EDIT]This example is included in the latest Fresh release (1.1.D), in the directory "examples".[/EDIT]

Regards.


Last edited by JohnFound on 08 Mar 2005, 12:45; edited 2 times in total
Post 04 Feb 2005, 12:15
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
JohnFound wrote:
Playing with SQLite, I decided to write a simple example, that to help people willing to use excelent (only not so small) database engine SQLite.
Regards.


I actually use SQLite for all my SQL needs -- it is very fast, and works on Linux and Win32 equally well. An excellent library, and actively developed (and completely free, like FASM).

Only shame is it's not written in FASM Smile
Post 04 Feb 2005, 16:11
View user's profile Send private message Visit poster's website AIM Address Yahoo Messenger Reply with quote
JohnFound



Joined: 16 Jun 2003
Posts: 3502
Location: Bulgaria
JohnFound
ronware wrote:
Only shame is it's not written in FASM Smile


Well, it is still not too late... Wink

But actually SQL is not very compatible with assembler way of thinking... I suppose, if someone want to create RDBMS, suitable for assembly language programming, he/she would be better to choose some different approach - flexible as SQL, but more assembly-like...who knows, maybe something like Forth or at least - SQL, but not string based...

Regards.
Post 09 Feb 2005, 20:25
View user's profile Send private message Visit poster's website ICQ Number Reply with quote
coconut



Joined: 02 Apr 2004
Posts: 326
Location: usa
coconut
john, is the file still available the link leads to an error page
Post 08 Mar 2005, 11:05
View user's profile Send private message Reply with quote
JohnFound



Joined: 16 Jun 2003
Posts: 3502
Location: Bulgaria
JohnFound
Sorry, guys. I simply forgot to remove this link. It is obsolete, because I included this example in the latest Fresh release, "examples" directory.

Regards
Post 08 Mar 2005, 12:40
View user's profile Send private message Visit poster's website ICQ Number Reply with quote
vbVeryBeginner



Joined: 15 Aug 2004
Posts: 884
Location: \\world\asia\malaysia
vbVeryBeginner
hi john,
they released some new version of sqlite3.dll Razz

maybe you could update the examples zip Smile

http://www.sqlite.org/download.html

your is 236 KB (241,664 bytes) and the current released on their site is 241 KB (246,784 bytes).

sincerely,
sulaiman chang.

* i gonna take a look on ur sqlite example,coz the VB torture me very much already!
Post 04 Apr 2005, 05:27
View user's profile Send private message Visit poster's website Reply with quote
JohnFound



Joined: 16 Jun 2003
Posts: 3502
Location: Bulgaria
JohnFound
Hi, vbVeryBeginner.

I know there is new version(s). In the next release of Fresh it will be updated, of course. But actually as far as the API is the same, you simply can replace old .dll with new one and the example will work the same way.

Regards.
Post 04 Apr 2005, 12:57
View user's profile Send private message Visit poster's website ICQ Number Reply with quote
vbVeryBeginner



Joined: 15 Aug 2004
Posts: 884
Location: \\world\asia\malaysia
vbVeryBeginner
yup, replace them already Smile
btw, could you make the example (all the proc calls) in one file instead of having procs in several files?, coz it might be easier for non-fresh user to enjoy that great example ?

btw, how bout the cdecl and stdcall problem?
i replace the sqlite3.dll and found that they got no problem? but u said they r using cdecl calling in one thread? and need to do something with the stack?? care to explain to me (i am quite beginner on this)


at first i thought the size difference is because u recompile the sqlite source again to stdcall convention.. ??
Post 04 Apr 2005, 16:53
View user's profile Send private message Visit poster's website Reply with quote
JohnFound



Joined: 16 Jun 2003
Posts: 3502
Location: Bulgaria
JohnFound
vbVeryBeginner wrote:
btw, how bout the cdecl and stdcall problem?


I wouldn't call it a "problem". There are working macroses "ccall" and "cinvoke" in "StrCallEx.inc", so you can call any cdecl function without any problem.
I simply don't like this convention, because it is not too reasonable, except for several particular cases - for example if you want to pass different number of arguments to one procedure.

Regards
Post 05 Apr 2005, 05:38
View user's profile Send private message Visit poster's website ICQ Number 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. Also on GitHub, YouTube, Twitter.

Website powered by rwasa.