Re: [sqlite] SELECT ... FOR UPDATE

SQLite does not use row level locking, only file level locking. You can use BEGIN IMMEDIATE to exclude writers or BEGIN EXCLUSIVE to exclude readers and writers. If you do not explicitly start a transaction, each statement constitutes it's own transaction. -Ursprüngliche Nachricht- Von:

[sqlite] Searching this mailing lsit

On 24 May 2016 at 19:46, Kenneth Kasajian wrote: > It's funny how many messages there are here about the signature of my e-mail > (which I cannot control) You could set up a gmail address for these messages, f'rinstance. [snip two copies of your unnecessarily extended sig] -- Cheers -- Tim

Re: [sqlite] Use journal after program crashed

On 5/24/16, Cecil Westerhof wrote: > 2016-05-25 3:49 GMT+02:00 Richard Hipp : > >> On 5/24/16, Cecil Westerhof wrote: >> > Until now I did not need it, but better inform before I do. ;-) >> > >> > When a program crashes it is possible that you have a journal file with >> > things that are not com

Re: [sqlite] Use journal after program crashed

2016-05-25 3:49 GMT+02:00 Richard Hipp : > On 5/24/16, Cecil Westerhof wrote: > > Until now I did not need it, but better inform before I do. ;-) > > > > When a program crashes it is possible that you have a journal file with > > things that are not committed. Is there a way to find out what thos

Re: [sqlite] Use journal after program crashed

On 5/24/16, Cecil Westerhof wrote: > Until now I did not need it, but better inform before I do. ;-) > > When a program crashes it is possible that you have a journal file with > things that are not committed. Is there a way to find out what those are? > (And selectively commit?) Are you talking

[sqlite] Use journal after program crashed

Until now I did not need it, but better inform before I do. ;-) When a program crashes it is possible that you have a journal file with things that are not committed. Is there a way to find out what those are? (And selectively commit?) -- Cecil Westerhof _

Re: [sqlite] What could be the cause of a zero length database file?

At present I can't answer that. I can't reliably reproduce the problem (and never in the debugger) so I don't yet really know what the critical factor is. What I'm trying to understand is what guarantees Sqlite makes. If we assume a perfectly valid sequence of SQL and API calls ending with COMMIT,

Re: [sqlite] What could be the cause of a zero length database file?

Do you close the database connection properly when you're done with it ? Simon. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] What could be the cause of a zero length database file?

The sequence is: * open a new database file * issue a sequence of several SQL commands in a single transaction (one BEGIN, one COMMIT at the end). The database ends up as a zero length file. Is this a) a normal consequence of the above if the single transaction is aborted (say due to an SQL err

[sqlite] What could be the cause of a zero length database file?

The sequence is: * open a new database file * issue a sequence of several SQL commands in a single transaction (one BEGIN, one COMMIT at the end). The database ends up as a zero length file. Is this a) a normal consequence of the above if the single transaction is aborted (say due to an SQL error)

Re: [sqlite] Searching this mailing lsit

On 2016-05-24 12:23 PM, Simon Slavin wrote: On 24 May 2016, at 7:46pm, Kasajian, Kenneth wrote: It's funny how many messages there are here about the signature of my e-mail (which I cannot control) Then please stop posting to public fora from that account. Yes, exactly. Unless they're c

Re: [sqlite] Searching this mailing lsit

On 24 May 2016 at 19:46, Kenneth Kasajian wrote: > It's funny how many messages there are here about the signature of my e-mail > (which I cannot control) You could set up a gmail address for these messages, f'rinstance. [snip two copies of your unnecessarily extended sig] -- Cheers -- Tim

Re: [sqlite] SELECT ... FOR UPDATE

On 24 May 2016, at 8:04pm, Igor Tandetnik wrote: > SQLite will report a syntax error. That's pretty easy to confirm > experimentally. Download the command line shell tool as a "precompiled binary" for your platform: and test commands to your heart's co

Re: [sqlite] Searching this mailing lsit

On 24 May 2016, at 7:46pm, Kasajian, Kenneth wrote: > It's funny how many messages there are here about the signature of my e-mail > (which I cannot control) Then please stop posting to public fora from that account. Simon. ___ sqlite-users mailing

Re: [sqlite] SELECT ... FOR UPDATE

On 5/24/2016 1:34 PM, Scott Doctor wrote: SELECT field FROM table FOR UPDATE; My question is, looking through the sqlite documentation, it is not clear how sqlite will handle that statement. SQLite will report a syntax error. That's pretty easy to confirm experimentally. -- Igor Tandetnik _

Re: [sqlite] Searching this mailing lsit

It's funny how many messages there are here about the signature of my e-mail (which I cannot control) I find the discussion about the law interesting.If anyone else wants to chime in, please do so. The more the merrier. Thanks in advance. -Original Message- From: sqlite-users-bou

[sqlite] SELECT ... FOR UPDATE

My current project has me bouncing between sqlite and mysql. In mysql, to lock a row of data at the start of a process to hold off concurrent operations, the recommended technique with the innodb engine is to issue SELECT field FROM table FOR UPDATE; This holds off any other process from acce

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

On 24 May 2016, at 6:04pm, Michael Hari wrote: > I’ve come to the conclusion that I would need to “split the file into two > databases” as well. The challenge here is that the larger db will have to > have a limit of 2 GB and will need to make a new db when it hits that limit. > It would have

Re: [sqlite] Binary Difference in Sqlite database files instead of SQLdiff and patch ?

Hi Simon, We don’t want to zip up the entire db unfortunately. It would be around 250 MB zipped versus having Sparkle update with a 38 MB patch. (Bandwidth costs are important for us) I’ve come to the conclusion that I would need to “split the file into two databases” as well. The challenge he

Re: [sqlite] Get Longitude and Latitude using PHP

This is a SQLite forum. Not Android. But yes, you can get a latlng from Google Earth, but I would query the device. On May 24, 2016 12:00 PM, "Gary Ehrenfeld" wrote: I want to use PHP to get the Longitude and Latitude from a Address then use google maps to display it. I have it working, but the

Re: [sqlite] Get Longitude and Latitude using PHP

Your right. Wrong list. Gary Ehrenfeld > On May 24, 2016, at 09:18, Simon Slavin wrote: > > >> On 24 May 2016, at 4:59pm, Gary Ehrenfeld wrote: >> >> I want to use PHP to get the Longitude and Latitude from a Address then use >> google maps to display it. > > I think you posted that to th

Re: [sqlite] Get Longitude and Latitude using PHP

On 24 May 2016, at 4:59pm, Gary Ehrenfeld wrote: > I want to use PHP to get the Longitude and Latitude from a Address then use > google maps to display it. I think you posted that to the wrong mailing list. Simon. ___ sqlite-users mailing list sqlit

[sqlite] Get Longitude and Latitude using PHP

I want to use PHP to get the Longitude and Latitude from a Address then use google maps to display it. I have it working, but the user has to know what their Lat and Long are. What I want is I can get the Lat and Long from their address and display the map form then. __

[sqlite] Searching this mailing lsit

RMtrix writes: > > Mail-Archive.com returns no hits for 2013 and 2014 even when the search term is "SQLite". None until > sometime in 2015. So the archive is incomplete or its index is corrupted. > > On the other site, your search has results only in 2013 and 2016. With Mail-Archive.com havi

Re: [sqlite] SQL logic error or missing database no such table

We only use .commit when we are using transactions: If any type of "BEGIN TRANSACTION;" is underway, a failure to "COMMIT;" data will guarantee that data will not be in a database. Interestingly however, even when not committed our queries will still work - our data will simply not be available in

[sqlite] System.Data.SQLite fails on rtree index creation (NuGet install)

On 05/24/2016 01:16 AM, Joe Mistachkin wrote: > Jason Doherty wrote: >> CREATE VIRTUAL TABLE IF NOT EXISTS TASK_SPX USING rtree(id, minx, maxx, >> miny, maxy); >> >> fails with >> >> SQLite error (1); no such table: main.sqlite_stat1 >> > Could you run the SQL query "ANALYZE;" on the databa

Re: [sqlite] SQL logic error or missing database no such table

Hi Randall, I was googling around and it seems like some people had the same issue where the data was lost after the connection was closed. In my case, the connection is a singleton which is used by multiple threads. I do not close the connection explicitly, let it close automatically when the serv