The function sqlite3_busy_timeout is missing in SQLite3.pas

WladiD · 2010-10-27 06:57:43

Hello Arnaud Bouchez,

I use your excellent SQLite-Framework in Lauge. Thank you for this work!

But I missing the sqlite3_busy_timeout function in SQLite3.pas. I have added it manually, as follows:

...
function sqlite3_busy_timeout(V:TSQLHandle; Milliseconds:Integer):Integer; {$IFDEF USEC}cdecl;{$ENDIF} external;
...

and it was a fine solution for me. But with every new release it getting lost.

Please, include it in one of the next release.

Sorry, my English skills are not the best.

With best regards,

Waldemar Derr

ab · 2010-10-27 07:07:14

Good point.

If you need other API, don't hesitate to ask, we'll had it to the main source code trunk.

WladiD · 2010-10-27 07:10:02

Thank you very much!

ab · 2010-10-27 08:06:39

The declarations have been added to the source code repository:
- new sqlite3_busy_timeout and sqlite3_busy_handler low-level functions
- new TSQLDataBase.BusyTimeout property, to set the database timeout value in milliseconds

See http://synopse.info/fossil/info/5084f58b9c

I just checked out Lauge, which sounds great!
Nice having feedback about users!

You could now write the following line in TSQLAccess.InitializeDatabase:

  DB.BusyTimeout := 1000;

ab · 2010-10-27 14:51:54

Perhaps you should have taken a look at our BigTable class - see http://synopse.info/forum/viewforum.php?id=3

You could easily use this to store your thumbnails, instead of a SQLite3 database.
Just use e.g. filename/WidthxHeight as key (like 'mypic.jpg/1024x768'), then store the picture as value.
It will be very fast, and will need less code size than our ORM framework.

WladiD · 2010-10-28 06:12:44

Very nice, that you react so fast and have integrated sqlite3_busy_timeout and sqlite3_busy_handler functions. I have integrated the changed SQLite3.pas from fossil and use now "DB.BusyTimeout := 1000;".

BigTable is not suitable for me, because the Lauge-DB must take much more things, not only images/thumbs, in further versions. Currently I implement a solution for items, with tags and cusomizeable properties for each tag and item.

ab wrote:

I just checked out Lauge, which sounds great!

I'm really pleased. Perhaps you can translate the relative tiny lang file, anytime when Lauge is ready, to french?

ab wrote:

Nice having feedback about users!

I know, how nice that is. Feedback is like a secondary currency for developers

ab · 2010-10-28 08:15:21

No problem for the french translation.

Ask for it, when it'll be ready.

And thanks for your feedback, I hope I'll be rich some day with such immaterial currency!

I'm sure we'll bring all this open source sharing into Even, whereas no money will be needed in there!

mORMot Open Source

#1 2010-10-27 06:57:43

The function sqlite3_busy_timeout is missing in SQLite3.pas

#2 2010-10-27 07:07:14

Re: The function sqlite3_busy_timeout is missing in SQLite3.pas

#3 2010-10-27 07:10:02

Re: The function sqlite3_busy_timeout is missing in SQLite3.pas

#4 2010-10-27 08:06:39

Re: The function sqlite3_busy_timeout is missing in SQLite3.pas

#5 2010-10-27 14:51:54

Re: The function sqlite3_busy_timeout is missing in SQLite3.pas

#6 2010-10-28 06:12:44

Re: The function sqlite3_busy_timeout is missing in SQLite3.pas

#7 2010-10-28 08:15:21

Re: The function sqlite3_busy_timeout is missing in SQLite3.pas

Board footer