Re: [sqlite] Multiple network connections
Çağlar Orhan wrote: While i was reading "*Using SQLite*" from *Jay A. Kreibich*, i saw that sqlite doesn't designd for over network multiple client connections. I have a project that built on Microsoft .hta and vbscript. And I am using sqlite on the IIS for local storage but, 5 to 10 client applications connecting as a network database to that sqlite. SQLite file is in a shared folder. I made some test that 2 or few more clients inserting, updating and query same tables. I couldn't catch any inconsistency about table integrity. But on the book, because of there is no native support for providing access to multiple computers over a network, cause problems. Like database file corrupt etc. Is there a solution for network shared sqlite problematic? If your SQLite DB is being accessed locally by the webserver, then there is no reason to worry about consistency issues due to the webserver's network activity, provided that your application can handle the access delay issues that arise when multiple threads may attempt overlapping DB operations. If you are happy with the performance and the number of clients is not likely to grow much, SQLite could be a good solution. What Jay and others warn about is that SQLite is not designed for concurrent DB operations. Also, have its file store be accessed over a network from SQLite code running remotely is a formula for database corruption. But it looks like you are not doing that. Thank you You're welcome. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] Multiple network connections
While i was reading "*Using SQLite*" from *Jay A. Kreibich*, i saw that sqlite doesn't designd for over network multiple client connections. I have a project that built on Microsoft .hta and vbscript. And I am using sqlite on the IIS for local storage but, 5 to 10 client applications connecting as a network database to that sqlite. SQLite file is in a shared folder. I made some test that 2 or few more clients inserting, updating and query same tables. I couldn't catch any inconsistency about table integrity. But on the book, because of there is no native support for providing access to multiple computers over a network, cause problems. Like database file corrupt etc. Is there a solution for network shared sqlite problematic? Thank you Caglar ORHAN ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] insert return -1
Live Happy wrote: i tried to insert this text : BEGIN:VCARD\nVERSION:2.1\nN:;okpl;;;\nFN:okpl\nTEL;CELL:034567895566\nTEL;HOME:885666\ nEMAIL;WORK:shsjhs at ghshhs.com\nEND:VCARD\n to my sqlite database in android but it return me -1 is there any special characters should change or replace wish some help and thanks on advance There is no reason such text cannot be inserted, provided that is what finally reaches the SQLite prepare and/or parameter binding API. Your difficulty most likely arises from how your call into those APIs is done, which you have not shown. To get help, you will need to show more. Cheers, -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] sqlite3.c:134542: warning: assignment from incompatible pointer type
Hello. And, excuse my. 1. It is 3.7.15.1 (fossil tag: release) 2. It is trivial and self-documented. --- ext/rtree/sqlite3rtree.h.orig 2012-12-23 10:02:43.0 +0400 +++ ext/rtree/sqlite3rtree.h2012-12-23 10:03:43.0 +0400 @@ -47,7 +47,11 @@ struct sqlite3_rtree_geometry { void *pContext; /* Copy of pContext passed to s_r_g_c() */ int nParam; /* Size of array aParam[] */ +#ifdef SQLITE_RTREE_INT_ONLY + sqlite3_int64 *aParam; /* Parameters passed to SQL geom function */ +#else double *aParam; /* Parameters passed to SQL geom function */ +#endif void *pUser;/* Callback implementation user data */ void (*xDelUser)(void *); /* Called by SQLite to clean up pUser */ }; 3. Does not apply to him. My system is: FreeBSD test 9.1-PRERELEASE FreeBSD 9.1-PRERELEASE #2: Sat Oct 13 11:23:27 MSK 2012 root@test:/usr/obj/usr/src/sys/GENERIC i386 On Sun, Dec 23, 2012 at 11:49 PM, Larry Brasfield wrote: > Pavel Volkov wrote: >> >> Please consider the following error: >> >> sqlite3.c: In function 'deserializeGeometry': >> sqlite3.c:134542: warning: assignment from incompatible pointer type >> >> And the patch for it. > > > Three questions arise from your message: > 1. Which version of sqlite3.c ? (It's not the latest, apparently.) > 2. What patch? (Attachments are lost when posting here.) > 3. What has this got to do with the referenced post "Sqllite3 dll crash on > ..."? > > -- > Larry Brasfield > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] insert return -1
i tried to insert this text : BEGIN:VCARD\nVERSION:2.1\nN:;okpl;;;\nFN:okpl\nTEL;CELL:034567895566\nTEL;HOME:885666\ nEMAIL;WORK:shs...@ghshhs.com\nEND:VCARD\n to my sqlite database in android but it return me -1 is there any special characters should change or replace wish some help and thanks on advance ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] System.Data.SQLite ".CHM" [was: PRAGMA foreign_keys ...]
Larry Brasfield wrote: > > Wow, a .CHM file! I did not even dream that it existed. Perhaps, > instead of worrying about web-help, the top page at > http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki could > just have a link, labelled "Documentation", leading to a page that says > something like: > I just added a link on the index page. Thanks for the suggestion. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] System.Data.SQLite ".CHM" [was: PRAGMA foreign_keys ...]
Joe Mistachkin wrote: [regarding connection string options and a new open event in 1.0.83] These features are both documented in the System.Data.SQLite "CHM" help file (i.e. based on the embedded doc comments in the code). However, I can see how it might be difficult to find that information via the web. Perhaps I should work on generating HTML documentation to place on the web site? Wow, a .CHM file! I did not even dream that it existed. Perhaps, instead of worrying about web-help, the top page at http://system.data.sqlite.org/index.html/doc/trunk/www/index.wiki could just have a link, labelled "Documentation", leading to a page that says something like: Online help is a work-in-progress, but the distribution has a comprehensive Windows help file that is placed in the installation directory. -- Larry Brasfield ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] PRAGMA foreign_keys = ?, feature request
Larry Brasfield wrote: > > Please do not take this as a gripe, but earlier, when I suspected that > there might be a connection string solution, I did a search to see what > the option name might be. I saw nothing at www.connectionstrings.com, > http://system.data.sqlite.org in the doc, FAQ or feature sections, and > nothing at http://www.sqlite.org/c3ref/open.html (where I had hoped that > 'URI Filenames' might permit such an option). If not for your providing > it, I would be at a loss even if I knew there was such an option. > These features are both documented in the System.Data.SQLite "CHM" help file (i.e. based on the embedded doc comments in the code). However, I can see how it might be difficult to find that information via the web. Perhaps I should work on generating HTML documentation to place on the web site? > > That event is a nice feature, and I look forward to seeing 1.0.83.0 . I > really appreciate the fine work that has been done on System.Data.SQLite. > Thanks. -- Joe Mistachkin ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users