Re: [sqlite] Unsubscribe

Gianni asked how to unsubscribe: Send a mail with Subject: Help to following address sqlite-users-requ...@mailinglists.sqlite.org: Follow instructions you get and soon you'll be out of here. Kind regards | Vriendelijke groeten | Cordiali saluti, Klaas `Z4us` van Buiten V for Art & ICT

[sqlite] FOREIGN KEY constraint failed

On Mon, 04 Apr 2016 17:51:30 +0200 Domingo Alvarez Duarte wrote: >FOREIGN KEY constraint failed >I have some databases with lots of foreign keys and I sometimes I need to >change the structure of some tables and I get this message Before restructuring a database schema always use: PRAGMA

[sqlite] No datasize field - why?

Scott wrote: >It depends on what you call a character. If you consider a "character" the >same way most people do (one typographical unit), then you have to deal >with varying numbers of code points per character, even in a "fixed width" >encoding like UTF-32. There is no hard limit on how many

[sqlite] Why SQLite does not use a web-based forum?

N.N. wrote Mon, 15 Feb 2016 09:19:11 +0800: >Why SQLite does not utilize a web-based forum for all users discuss >problems? I think that will be more convenient and can help more people. LinkedIn (https://www.linkedin.com) has two: "SQLite" and "SQLite Professional" and I'm pretty sure that on

[sqlite] Article about pointer abuse in SQLite

>> On 3/19/16, James K. Lowden wrote: >> ... If the correctness of the code is >> subject to change by the compiler's interpretation of the language, how >> is the programmer to prevent it? > On Sat, 19 Mar 2016 15:50:43 -0400 Richard Hipp wrote: > ... But subsequent revisions of the >

[sqlite] using cerod/sqlite with JDBC

Did you read, understood and used all instructions you can find here? http://www.tutorialspoint.com/sqlite/sqlite_java.htm Tal Tabakman wrote Sun, 15 May 2016 09:41:39 -0700: > ... open an sqlite DB , compressed with CEROD, using java?s sqlite JDBC > connection ? Kind regards | Vriendelijke

Re: [sqlite] Version issues on Mac after updating

Simon wrote on Tue, 31 May 2016 16:28:55 +0100 >You can find the version Unix chooses to run using the "which" command: >simon$ which sqlite3 >/usr/bin/sqlite3 Right, that's the way it works on practically all *n?x based systems. What I do is changing the $PATH so Darwin's bash looks first in

Re: [sqlite] transaction during reading on read-only database

Ciao Andri, To keep the results of a query consistent one better starts a transaction. A database can be updated by one thread at a time, but read by many. Suppose you need a list of all employees of a department. If you start to search one at a time a lot of changes can happen. An employee can

Re: [sqlite] Report misprint in Documentation

Indeed, in the page you refer to is missing the operator "<>" documented here: http://sqlite.org/rowvalue.html#syntax Juan Francisco Benítez López wrote on Tue, 9 May 2017 12:35:38 +0200: >... >"SQLite version 3 has the usual set of SQL comparison operators including >"=", "==", "<", "<=", ">",

Re: [sqlite] How to search for fields with accents in UTF-8 data?

iendelijke groeten | Cordiali saluti, Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy https://www.linkedin.com/in/klaas-van-buiten-0325b2102 On Mon, 19/6/17, Klaas Van B. <klaasva...@yahoo.com> wrote: Subject: Re: How to search for fie

Re: [sqlite] How to search for fields with accents in UTF-8 data?

You can even make UTF-8 the default encoding in Windows as it is in SQLite https://superuser.com/questions/239810/setting-utf8-as-default-character-encoding-in-windows-7 CC wrote on Sun, 18 Jun 2017 12:52:33 +0200: >As an alternative, I tried SQLite Studio, but it fails:

Re: [sqlite] Valid characters for indentifiers

Bart Smissaert wrote on Sat, 11 Nov 2017 11:04:37>What are the exact rules for valid identifier names (tables, columns and indexes)? Enclosed in double quotes practically anything, but using special characters like /,@,;,#,+,*,% are not really recommended, just as using key-words ("TABLE",

[sqlite] CLI: .dbinfo does not work in version 3.21

In 3.20.1 the dot-command dbinfo still worked, but since 3.21.0 not anymore sqlite32001 e0.sqb SQLite version 3.20.1 2017-08-24 16:21:36 Enter ".help" for usage hints. sqlite> .dbinfo database page size:  512 write format:    1 read format: 1 reserved bytes:  0 file change counter:

[sqlite] Missing keywords

Since 3.23 the words FALSE and TRUE should be added to SQLite Query Language: SQLite Keywords. Perhaps more? | | | | SQLite Query Language: SQLite Keywords | | | Kind regards | Vriendelijke groeten | Cordiali saluti, Klaas `Z4us` van B. V, EFIG