[sqlite] how to use sqlite in COCOA

Who can tell me how to use Sqlite in COCOA in my MAC system? ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handling Timezones

On 2014-07-29, 8:23 PM, Will Fong wrote: Hi, On Wed, Jul 30, 2014 at 8:16 AM, Igor Tandetnik wrote: 'localtime' and 'utc' modifiers. Ah! I have not explained my issue properly :) I'm very sorry about that. I'm using SQLite as a backend to a small website and I have

Re: [sqlite] Handling Timezones

You can haz per-connection TZ setting: use a temp table and join with it. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Handling Timezones

Hi, On Wed, Jul 30, 2014 at 10:01 AM, Keith Medcalf wrote: > Store and retrieve everything in the database in Zulu time. Whether this > means using timestrings, UNIX timestamps, JD or MJD floats is up to you. The > application (user interface) is responsible for

Re: [sqlite] Handling Timezones

>> 'localtime' and 'utc' modifiers. > >Ah! I have not explained my issue properly :) I'm very sorry about that. > >I'm using SQLite as a backend to a small website and I have users in >multiple timezones. When users login, their timezone is retrieved from >the user table. > >Really sorry for the

Re: [sqlite] Handling Timezones

Hi, On Wed, Jul 30, 2014 at 9:12 AM, Donald Shepherd wrote: > You can represent time zones as integers by using minutes. Examples: +600 > for AEST, +330 for IST, -480 for PST. No string manipulation is needed, > but depending on what or if you're using libraries, you

Re: [sqlite] Handling Timezones

You can represent time zones as integers by using minutes. Examples: +600 for AEST, +330 for IST, -480 for PST. No string manipulation is needed, but depending on what or if you're using libraries, you may need extra steps in there for convert those values into a representation supported by the

Re: [sqlite] Handling Timezones

On 30 Jul 2014, at 1:47am, Will Fong wrote: > On Wed, Jul 30, 2014 at 8:38 AM, Simon Slavin wrote: >> Store their timezones in the format "[+-]HH:MM" and apply them by appending >> that text to any dates they provide. See the "Time Strings" section

Re: [sqlite] Handling Timezones

Hi, On Wed, Jul 30, 2014 at 8:38 AM, Simon Slavin wrote: > Store their timezones in the format "[+-]HH:MM" and apply them by appending > that text to any dates they provide. See the "Time Strings" section of I can store each user's timezone setting as "[+-]HH:MM". But I

Re: [sqlite] Handling Timezones

On 30 Jul 2014, at 1:23am, Will Fong wrote: > On Wed, Jul 30, 2014 at 8:16 AM, Igor Tandetnik wrote: >> 'localtime' and 'utc' modifiers. > > Ah! I have not explained my issue properly :) I'm very sorry about that. > > I'm using SQLite as a backend to

Re: [sqlite] Handling Timezones

On 7/29/2014 8:23 PM, Will Fong wrote: I'm using SQLite as a backend to a small website and I have users in multiple timezones. When users login, their timezone is retrieved from the user table. Well, SQLite delegates to the C runtime for timezone handling. I suspect tzset() et al could be

Re: [sqlite] Handling Timezones

Hi, On Wed, Jul 30, 2014 at 8:16 AM, Igor Tandetnik wrote: > 'localtime' and 'utc' modifiers. Ah! I have not explained my issue properly :) I'm very sorry about that. I'm using SQLite as a backend to a small website and I have users in multiple timezones. When users login,

Re: [sqlite] Handling Timezones

On 7/29/2014 8:10 PM, Will Fong wrote: On Tue, Jul 29, 2014 at 9:56 PM, Gerry Snyder wrote: Have you read http://sqlite.org/lang_datefunc.html ? Is there something there that I missed? I didn't see anything there that relates on how to handle timezone operations.

Re: [sqlite] Handling Timezones

Hi, On Tue, Jul 29, 2014 at 9:56 PM, Gerry Snyder wrote: > Have you read http://sqlite.org/lang_datefunc.html ? Yes. Is there something there that I missed? I didn't see anything there that relates on how to handle timezone operations. Thanks, -will

Re: [sqlite] Counting changes in a INSERT/REPLACE

"Richard Hipp" wrote... On Tue, Jul 29, 2014 at 4:49 PM, jose isaias cabrera wrote: Is there a way to keep a count of the INSERTS/REPLACES that took place between the BEGIN and END? I was looking into the SQL changes() function,

Re: [sqlite] Counting changes in a INSERT/REPLACE

On Tue, Jul 29, 2014 at 4:49 PM, jose isaias cabrera wrote: > > Is there a way to keep a count of the INSERTS/REPLACES that took place > between the BEGIN and END? I was looking into the SQL changes() function, > > http://www.sqlite.org/lang_corefunc.html#changes > > but

Re: [sqlite] ISO time leap second.

On Tue, Jul 29, 2014 at 10:02 AM, Simon Slavin wrote: > You're never going to get non-scientific programmers to do this properly > anyway. Every financial programmer knows that there are exactly 60*60*24 = > 86,400 seconds in a day. You've never going to get them to use

[sqlite] Counting changes in a INSERT/REPLACE

Greetings! I have this update: BEGIN; INSERT OR REPLACE INTO A SELECT * FROM client.A WHERE id = 1 AND Date != '2014-06-22'; INSERT OR REPLACE INTO A SELECT * FROM client.A WHERE id = 2 AND Date != '2014-06-22'; ... ... INSERT OR REPLACE INTO A SELECT * FROM

Re: [sqlite] ISO time leap second.

On 29 Jul 2014, at 5:36am, Nico Williams wrote: > Note that SQLite3 apparently does no > corrections for leap seconds anyways in date arithmetic (which it > can't do if you're using numeric arithmetic on Julian days anyways!), > which it would have to do (since UTC is

Re: [sqlite] Handling Timezones

Have you read http://sqlite.org/lang_datefunc.html ? On 7/29/2014 6:41 AM, Will Fong wrote: Hi, How are timezones best handled? Since dates are stored in GMT, when I go to display them, I need to add/subtract the timezone. That's not too hard when I can just store the timezone as "-5" for

[sqlite] Handling Timezones

Hi, How are timezones best handled? Since dates are stored in GMT, when I go to display them, I need to add/subtract the timezone. That's not too hard when I can just store the timezone as "-5" for EST. When I'm providing a date to query on, I would have to apply the reverse of the timezone,

Re: [sqlite] Long execution time since sqlite 3.8

CREATE TABLE android_metadata (locale TEXT); CREATE TABLE tbl_lib_filters(UUID TEXT NOT NULL PRIMARY KEY, template TEXT NOT NULL, library TEXT NOT NULL, rules TEXT); CREATE TABLE tbl_library(UUID TEXT NOT NULL PRIMARY KEY, TITLE TEXT, ICON_URI TEXT, DESCCRIPTION TEXT, REMOVED INTEGER NOT NULL,

Re: [sqlite] Long execution time since sqlite 3.8

Ok that's the output of sqlite_stat1: tbl|idx|stat android_metadata||1 tbl_flex_template|idx_flex_template_lib|10 10 tbl_flex_template|sqlite_autoindex_tbl_flex_template_1|10 1 zones|sqlite_autoindex_zones_1|84 6 1 history||5870 tbl_flex_content2|idx_flex_content_temp|20010 2001

[sqlite] ADO Support for SQLite using Windows 8.1 and Windows Phone 8.1?

Is there ADO Support for SQLite using Windows 8.1 and Windows Phone 8.1? I am looking for a Cross-Platform ADO wrapper for iOS, Android and Win 8.1 WP 8.1? ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] System.Data.Sqlite

On Tue, Jul 29, 2014 at 4:48 AM, Clemens Ladisch wrote: > > Simplified for plain ol' SQLite as follows: > Thank you. That is exactly what we needed. The bug has now been characterized, studied, and fixed. See [ http://www.sqlite.org/src/info/d2889096e7bdeac6] for the

Re: [sqlite] parser stack overflow in view

On Tue, Jul 29, 2014 at 8:13 AM, Michael wrote: > I coudn't imagine that nobody else had such problems. > > The fallowing select statement was existing without problems in older > sqlite database. > It's created with another application of me and so it's hard to

Re: [sqlite] parser stack overflow in view

I coudn't imagine that nobody else had such problems. The fallowing select statement was existing without problems in older sqlite database. It's created with another application of me and so it's hard to replace the subselects. which other infos would help you to find the problem? CREATE VIEW

Re: [sqlite] parser stack overflow in view

On Tue, Jul 29, 2014 at 5:00 AM, Michael wrote: > I have a view with about 6 Unions and a depth of about 6 subselects in > each select. > Shouldn't be a big thing and it was no problem with sqlite 3.7.17. > Since 3.8 (3.8.4.3) I get "parser stack overflow". I have many

Re: [sqlite] Long execution time since sqlite 3.8

On Tue, Jul 29, 2014 at 4:55 AM, Michael wrote: > > Should I post the EXPLAIN? > No. You should post the database schema and the content of the sqlite_stat1, sqlite_stat3, and/or sqlite_stat4 tables if such tables exist. -- D. Richard Hipp d...@sqlite.org

Re: [sqlite] System.Data.Sqlite

Yes, this is exactly the same issue I encounter. There are 2 rows in the result with Spatialite GUI, but only one with System.Data.Sqlite. -Message d'origine- De : sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org] De la part de Clemens Ladisch Envoyé : mardi 29

[sqlite] parser stack overflow in view

I have a view with about 6 Unions and a depth of about 6 subselects in each select. Shouldn't be a big thing and it was no problem with sqlite 3.7.17. Since 3.8 (3.8.4.3) I get "parser stack overflow". I have many queries with this problem now... Can anyone help me please Any Ideas?

[sqlite] Long execution time since sqlite 3.8

Hello, The following query needs about 8 seconds since 3.8. In sqlite-3.7.17 it was less than a second. select infos.name, infos.id, infos.rating, DateTime(infos.date), DateTime(infos.expiration) from infos where infos.id not in ( select distinct infos.id from infos, category,

Re: [sqlite] System.Data.Sqlite

Eric DAVID wrote: > Well, It seems to be impossible to join files to mails. So, here are the > statements : > > CREATE TABLE Lignes (lig_id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL, > lig_nom TEXT NOT NULL); > SELECT AddGeometryColumn('Lignes', 'lig_geom', 2154, 'LINESTRING', 'XY'); > ...

Re: [sqlite] Where exactly are parameters accepted in an expression?

Zsbán Ambrus wrote: > CREATE VIEW vp AS SELECT ? AS x; > > Error: parameters are not allowed in views > > This error seems reasonable, but I can't find anything about it in > documentation. Could you tell me where the documentation explains > where exactly I can use parameters (bound

[sqlite] Where exactly are parameters accepted in an expression?

Hello sqlite list! The following statement gives an error in sqlite 3.8.4.3. CREATE VIEW vp AS SELECT ? AS x; The error message is: Error: parameters are not allowed in views The parameter (placeholder) is definitely be the problem here, because this similar statement executes without