[sqlite] BUG?

SELECT julianday('2016-04-15 12:10:10') ==>2457494.00706 SELECT datetime(2457494.00706) ==>2016-04-15 12:10:09

[sqlite] BUG?

On 4/21/16, jrhgame wrote: > SELECT julianday('2016-04-15 12:10:10') ==>2457494.00706 I get: 2457494.00706019 The extra digits at the end ...019 make the difference. > SELECT datetime(2457494.00706) ==>2016-04-15 12:10:09 SELECT datetime(2457494.00706019) ==> 2016-04-15 12:10:10

[sqlite] JSON vs. WinRT vs. SQLite

Yup, our application heavily depends on the full-text search, so that's another option I enabled. Thank you very much, I will feel much, much safer now when presenting my results to collegues. SVORADA Peter From: sqlite-users-bounces at

[sqlite] JSON vs. WinRT vs. SQLite

Hello, at last I was able to successfully compile the sqlite3.dll with json1 extension included in a way that our WinRT application works with it seemingly without problems. The process how I got it working has however been really..lets say "experimental" and therefore I would love if anyone

[sqlite] Fw: new important message

Hello! New message, please read james.ander at tiscali.co.uk

[sqlite] SELECT 0 gives TEXT instead of INTEGER

2016-04-21 12:39 GMT+02:00 Dave Wellman : > How about something like: > > WITH RECURSIVE > expansion(byte) AS ( > SELECT 0 > UNION ALL > SELECT byte + 1 FROM expansion > LIMIT 10 > ) > SELECT PRINTF('%02d',byte) > FROM expansion > ; > ?Yes, that is exactly what I want.

[sqlite] Is it possible that dropping a big table takes very long

21 apr 2016, Cecil Westerhof: > > ?I think it is an edge case. On my real system I only got this when > there > where 1E8 records. I am now testing on very old (8 year) hardware to > and > from work. Hello, the answer to Cecils question is YES here. I tested on a computer with just 512 Mb

[sqlite] SELECT 0 gives TEXT instead of INTEGER

2016-04-21 12:20 GMT+02:00 Cecil Westerhof : > > I have the following: > WITH RECURSIVE > expansion(byte) AS ( > SELECT 0 > UNION ALL > SELECT byte + 1 FROM expansion > LIMIT 10 > ) > SELECT hex(byte) > FROM expansion > ; > > ?I would expect to get 00-09, but I get 30-39. 30

[sqlite] Is there something like PHPAdmin for SQLite

Hello, > Is there something like PHPAdmin for SQLite? I've put together Awesome SQLite [1] - a collection of (free) SQLite goodies incl. a list of admin tools for SQLite - desktop version (e.g. SQLiteStudio recommended) or web (e.g. sqliteweb). Cheers. [1]

[sqlite] Is there something like PHPAdmin for SQLite

If you work with Linux, you can use sshfs to mount the remote file system on your local file system. Doing so, you can use the Firefox SQLite Manager plugin. I don't know, if you can find similar tools for Windows. __ Carsten Stelling F Hardware / R

[sqlite] Multiple in-memory database table query

On Apr 20, 2016, at 8:10 AM, Dominique Devienne wrote: > Thanks. I mistakenly assumes ":memory:" was a "singleton" memory DB > for that particular connection. Thanks to your example, and a little testing > on my own, I now realize > each one is an independent memory DB, and not just different

[sqlite] minor documentation typo

minor documentation typo here: https://www.sqlite.org/rbu.html >All RBU updates us the "OR ROLLBACK" constraint handling mechanism.< should obviously be >All RBU updates use the "OR ROLLBACK" constraint handling mechanism.< Wolfgang

[sqlite] SELECT 0 gives TEXT instead of INTEGER

I have the following: WITH RECURSIVE expansion(byte) AS ( SELECT 0 UNION ALL SELECT byte + 1 FROM expansion LIMIT 10 ) SELECT hex(byte) FROM expansion ; ?I would expect to get 00-09, but I get 30-39. 30 is the hex-value of the ASCII 0. How would I get what I want. I could

[sqlite] SELECT 0 gives TEXT instead of INTEGER

How about something like: WITH RECURSIVE expansion(byte) AS ( SELECT 0 UNION ALL SELECT byte + 1 FROM expansion LIMIT 10 ) SELECT PRINTF('%02d',byte) FROM expansion ; Cheers, Dave Ward Analytics Ltd - information in motion Tel: +44 (0) 118 9740191 Fax: +44 (0) 118 9740192

[sqlite] SELECT 0 gives TEXT instead of INTEGER

On 21 Apr 2016, at 11:20am, Cecil Westerhof wrote: > ?I would expect to get 00-09, but I get 30-39. 30 is the hex-value of the > ASCII 0.

[sqlite] SELECT 0 gives TEXT instead of INTEGER

Try "limit 20". The hex function interprets the argument as a blob. This causes your integer value to be converted to text, and the hex representation of that text is your result. -Urspr?ngliche Nachricht- Von: sqlite-users-bounces at mailinglists.sqlite.org

[sqlite] Is there something like PHPAdmin for SQLite

2016-04-21 10:07 GMT+02:00 Philip Newton : > That won't work if the Firefox is on his local machine and the sqlite > database is on the server > ?That is the case. -- Cecil Westerhof

[sqlite] JSON vs. WinRT vs. SQLite

On 4/21/16, Peter Svorada wrote: > > The working solution seems to be the one where I don't call "fossil checkout > winrt" Correct. The "winrt" branch has long since been merged into trunk. See https://www.sqlite.org/src/timeline?n=100=winrt for details. > All I did was > include following

[sqlite] Is there something like PHPAdmin for SQLite

On 20 April 2016 at 22:46, Eduardo Morras wrote: > On Wed, 20 Apr 2016 22:21:04 +0200 > Cecil Westerhof wrote: > >> ?He told me he liked the idea of SQLite, but had to use MySQL, >> because he needed to give his client a web interface. So if there is >> a web interface (and there is), then he is

[sqlite] Field FOREIGN KEY when it is a pointer

On Wed, Apr 20, 2016 at 8:09 PM, Dan Kennedy wrote: > ?If I read that correctly then a field has to be NULL or point to a record >> in the other table. I want it to point to a record if it is an INT and >> whem >> it is TEXT it is just the text. (And it should only be allowed to be an >> INT >>

[sqlite] Is it possible that dropping a big table takes very long

2016-04-21 7:50 GMT+02:00 Cecil Westerhof : > ?I think it is an edge case. On my real system I only got this when there > where 1E8 records. I am now testing on very old (8 year) hardware to and > from work. > The processor is: > Intel(R) Atom(TM) CPU N270 @ 1.60GHz > with 1 GB of RAM. I am

[sqlite] Is it possible that dropping a big table takes very long

2016-04-21 1:37 GMT+02:00 J Decker : > If you upload a file to google drive and later try to replace it with > a different version google drive often corrupts it. Always delete and > upload a new version. > ?That was not the problem. When I unzipped the file I uploaded, it was different as the

[sqlite] Is it possible that dropping a big table takes very long

2016-04-21 1:04 GMT+02:00 jungle Boogie : > On 20 April 2016 at 14:55, Cecil Westerhof wrote: > > This one I download, unpacked and tried. It worked. So it should be > > correct now: > > https://drive.google.com/file/d/0BzW5q7uL-6z0UjFhRWZWSENnZW8/ > > > Windows 8.1 4 gigs of RAM, dell

[sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin

Hi Dr. Hipp: Any plans to visit San Francisco? -Original Message- From: Richard Hipp To: General Discussion of SQLite Database Sent: Wed, Apr 20, 2016 10:21 am Subject: [sqlite] SQLite training/meet-up opportunities in Eindhoven and Berlin There will be an

[sqlite] Field FOREIGN KEY when it is a pointer

On 04/20/2016 11:21 PM, Cecil Westerhof wrote: > 2016-04-20 18:07 GMT+02:00 R Smith : > >> >> On 2016/04/20 6:04 PM, Cecil Westerhof wrote: >> >>> I am thinking about creating a table where a certain field will be a >>> description, or a key to the description. Would it be possible to have a >>>