Re: [sqlite] SQLite - how to get number of active connection?

This isn't exactly the same, but you can find out what other applications have a file open (SQLite database file in this case) using the following Windows APIs: RmRegisterResources RmGetList That's what I use to help diagnose locking issues. Doug -Original Message- From: sqlite-users

Re: [sqlite] Clarification on "No Isolation On Same Db Connection"

Igor wrote: " On 9/8/2016 1:15 PM, Stephan Mueller wrote: " > " > I'd prefer to commit after each update " > " You can't commit on a single connection either, while there's an " > " unfinalized SELECT statement traversal going on. So you aren't gaining " > " anything by trying to interleave SELECT

[sqlite] Frequent database corruptions on Windows 10

Hi, since upgrading to Windows 10 I have trouble with several different C# programs I wrote, that uses System.Data.SQLite to access sqlite database files stored on a SSD drive. Most of the programs are long running programs (running between one day to a week) performing background download tasks

Re: [sqlite] sqlite - Delete large table in sqlite

On Fri, 9 Sep 2016 14:51:51 +0100 Simon Slavin wrote: > Set a timeout of five minutes when you open your SQLite connections > using one of the following: > > Is it enough to set this once

Re: [sqlite] sqlite - Delete large table in sqlite

On 10 Sep 2016, at 11:57am, Lev wrote: >> > > Is it enough to set this once as the connection created? Or shall I set this > every time a do sqlite3_step()? You do it after opening a connection to the database.

Re: [sqlite] Frequent database corruptions on Windows 10

> Le 10 sept. 2016 à 11:21, Alexander Täschner > a écrit : > > since upgrading to Windows 10 I have trouble with several different C# > programs I wrote, that uses System.Data.SQLite to access sqlite > database files ... > The programs are using multiple

Re: [sqlite] Problem with rename table

On 08/09/2016 10:09, Bob McFarlane wrote: Please reply if you sent this. Thanks. Hmm, looks like a fishing exercise to me. Same message in several threads. This reply only to mailing list. John -Original Message- From: sqlite-users

Re: [sqlite] Frequent database corruptions on Windows 10

> I think that the System.Data.SQLite is compiled in the multi-thread > mode and I did not find a function or option to switch it to > serialized mode, but on the other hand all the different programs > showed no problems in the last years and only started to make trouble > after my upgrade from

Re: [sqlite] Convert mysql to sqlite

On 10 Sep 2016, at 10:24pm, Scott Doctor wrote: > Anyone know of a utility to directly convert from MySQL to sqlite? What syntax does the SQL dump use that the SQLite command-line shell doesn't like ? I generally do this stuff using find/replace in a text processor

Re: [sqlite] Convert mysql to sqlite

The database evolved over the past ten years with many modifications over time. I decided to just do it the hard way. Created the schema from scratch in sqlite, exported each table as csv from mysql (22 of them). Mysql workbench only exports to csv at the table level, not at the database

[sqlite] Convert mysql to sqlite

I have a database with a few tables and about 140MB of data in it that exists as a MySQL database. Using MySQL workbench I can export the data, but it dumps as a SQL dump with its flavor of sql. I want to convert this database into a sqlite database. Nothing fancy in it. No triggers,

Re: [sqlite] Convert mysql to sqlite

On Sat, 10 Sep 2016 14:24:48 -0700 Scott Doctor wrote: > I have a database with a few tables and about 140MB of data in > it that exists as a MySQL database. Using MySQL workbench I can > export the data, but it dumps as a SQL dump with its flavor of > sql. I want to

Re: [sqlite] Frequent database corruptions on Windows 10

2016-09-10 19:16 GMT+02:00 Olivier Mascia : > > One connection per process, shared between threads is calling for needless > complications (your efforts to prevent different threads from using this > connection object simultaneously, for instance). > > I would first refactor

Re: [sqlite] Problem with rename table

On Sep 10, 2016 2:54 AM, "John McMahon" wrote: > > On 08/09/2016 10:09, Bob McFarlane wrote: >> >> Please reply if you sent this. Thanks. >> > > Hmm, looks like a fishing exercise to me. Same message in several threads. > > This reply only to mailing list. It's an