[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

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

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

[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

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

[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

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

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

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

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.

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] 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

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

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

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

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

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] 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

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

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