Re: [sqlite] Thinking about a way to extend the number of writers in WAL mode

le or MSSQL you have to use special locking modes and transaction options with significant performance penalties. Eric On Fri, Aug 4, 2017 at 8:50 AM, Luc DAVID wrote: Hello, I was thinking about a possible solution for sqlite "only single writer is allowed at the same time" and datab

[sqlite] Thinking about a way to extend the number of writers in WAL mode

Hello, I was thinking about a possible solution for sqlite "only single writer is allowed at the same time" and database lock. sqlite has WAL mode for better concurrency and this could maybe be used to extend the number of writters: Do you think it would be possible to create a MyDb.WAL001

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

What's the programming language used in the application? I use Freepascal / Lazarus as a programming language and my own sqlite wrapper written in Freepascal as well. I will add the sqlite3_extended_errcode + sqlite3_errstr to the wrapper lib in order to get extended error infos and will have

Re: [sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

Thanks Ryan and Oliver for your answers You are too fast for me, I didn't have the time to answer the first posts... @Ryan > There is no safe way to do what you need. Networked file systems do not > play nice with file-locking. SQLite is suitable for localized storage, > not Networked-multi-us

[sqlite] Is it safe to use sqlite WAL mode on windows server 2003+ with TSE access ?

Hello, I'm planning to install an application using sqlite on a windows 2003 server. The application exe + sqlite dll + database will be installed in the same server directory. The application will be used by ± 10 users via RDP TSE clients. I need to take care of possible database locks during

[sqlite] How to compile SQLite with SQLITE_ENABLE_COLUMN_METADATA option under Ubuntu Linux

Thank you Jay for your answers. I will try the 'lib' program. Luc - To unsubscribe, send email to [EMAIL PROTECTED] -

Re: [sqlite] How to compile SQLite with SQLITE_ENABLE_COLUMN_METADATA option under Ubuntu Linux

I found some answer to my previous questions and wrote a short tutorial at http://source.online.free.fr/Linux_HowToCompileSQLite.html I still have two points to solve How can I check the functions available in the sqlite3 shared library ? Are there some tools available to list the functions ex

Re: [sqlite] How to compile SQLite with SQLITE_ENABLE_COLUMN_METADATA option under Ubuntu Linux

Thanks for your answer, I don't have time to test it now but I will let you know. I 'm not on my linux machine but I believe gcc -c sqlite3.c generates a sqlite3.o file. Is this file already usable as a shared library or do I have to call the linker to generate a sqlite3.so ? How can I check t

[sqlite] How to compile SQLite with SQLITE_ENABLE_COLUMN_METADATA option under Ubuntu Linux

Hi, I'm writting a component set to wrap sqlite database with FPC (Free Pascal Compiler) / Lazarus and Delphi available at http://source.online.free.fr To enable Queries data editing, I need to use the library compiled with SQLITE_ENABLE_COLUMN_METADATA option. After many tries, I succeed c