[sqlite] Missing keywords

[Klaas Van B.]

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

___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Valid characters for indentifiers

[Klaas Van B.]

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", "COLUMN" etc see SQLite Query Language: SQLite Keywords )


| 
| 
|  | 
SQLite Query Language: SQLite Keywords


 |

 |

 |


More to it you may find on Stack Overflow


| 
| 
| 
|  |  |

 |

 |
| 
|  | 
What SQLite column name can be/cannot be?

Is there any rule for the SQLite's column name? Can it have characters like 
'/'? Can it be UTF-8?
 |

 |

 |




Kind regards | Vriendelijke groeten | Cordiali saluti,
Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy
https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Klaas Van B.]

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: 15
database page count: 6
freelist page count: 0
schema cookie:   4
schema format:   4
default cache size:  0
autovacuum top root: 0
incremental vacuum:  0
text encoding:   1 (utf8)
user version:    1106
application id:  0
software version:    3009002
number of tables:    4
number of indexes:   0
number of triggers:  0
number of views: 0
schema size: 359

I did not make any changes to the file and now I get:
sqlite3 e0.sqb
SQLite version 3.21.0 2017-10-24 18:55:49
Enter ".help" for usage hints.
sqlite> .dbinfo
unable to read database header

ll e0.sqb
-rw-rw-r--  1 staff  3072 Nov  6 18:03:30 2015 e0.sqb



Kind regards | Vriendelijke groeten | Cordiali saluti,
Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy
https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Klaas Van B.]

For some applications it is, for others not in all cases. For "just" accented 
characters it should be no problem following these instructions.
General advice: download OpenOffice or similar OpenSource packages. They are 
completely free and support almost all OS's.

Kind regards | Vriendelijke 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 fields with accents in UTF-8 data?
 To: "SQLite Maillist" <sqlite-users@mailinglists.sqlite.org>
 Cc: "CC" <codecompl...@free.fr>
 Date: Monday, 19 June, 2017, 8:41
 
 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 <codecompl...@free.fr>
 wrote on Sun, 18 Jun 2017 12:52:33 +0200:
 
 >As an alternative, I tried SQLite
 Studio, but it fails:
 
 ;>Returns no record
 >SELECT COUNT(*) FROM MyTable WHERE
 REGION="Île-de-France";
 
 ;>Returns the expected records
 >SELECT COUNT(*) FROM MyTable WHERE
 "LIBREG" LIKE "%le-de-France";
 
 >I found nothing in SQLite Studio's
 menus that could be related to
 >encoding so that I could tell it
 the DB contains UTF-8 instead of ANSI.
 
 >Is there another Windows
 application I could try that is more likely to
 >work with UTF-8 data?
 
 Kind regards | Vriendelijke groeten |
 Cordiali saluti,
 Klaas `Z4us` van Buiten V, Experienced
 Freelance ICT-Guy
 https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Klaas Van B.]

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:

;>Returns no record
>SELECT COUNT(*) FROM MyTable WHERE REGION="Île-de-France";

;>Returns the expected records
>SELECT COUNT(*) FROM MyTable WHERE "LIBREG" LIKE "%le-de-France";

>I found nothing in SQLite Studio's menus that could be related to
>encoding so that I could tell it the DB contains UTF-8 instead of ANSI.

>Is there another Windows application I could try that is more likely to
>work with UTF-8 data?

Kind regards | Vriendelijke groeten | Cordiali saluti,
Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy
https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Report misprint in Documentation

[Klaas Van B.]

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
>"=", "==", "<", "<=", ">", ">=", "!=", "", "IN", "NOT IN", "BETWEEN", "IS",
>and "IS NOT", ."
>After the operator '!=' doesn't appear any operator. I suppose that the
>empty one is the operator '<>'. 
>...

Kind regards | Vriendelijke groeten | Cordiali saluti,
Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy
https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

[Klaas Van B.]

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 be moved to 
another department, fired or a new one entered. Another reason is speed. All 
(or most if it is a huge department and/or a tiny cache) employees are in cache 
so you're sure you have the requested list showing the situation on the moment 
of creation.

Andrii Motsok wrote Thu, 6 Oct 2016 11:43:10:

>My understanding is that any reading from database automatically starts read 
>transaction.
>The question: why does sqlite need to do it on read-only database?


Kind regards | Vriendelijke groeten | Cordiali saluti,
Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy
https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Unsubscribe

[Klaas Van B.]

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
https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Version issues on Mac after updating

[Klaas Van B.]

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 the current 
directory (.), then in the dir where I usually unzip the newest version of my 
favorite applications one of them being {no surprise ;-)} SQLite

Sometimes to test the downwards compatibilty I don't

Last login: Mon May 30 18:11:42 on console
surfer-172-29-7-221-hotspot:~ klaasv$ which sqlite3
/usr/bin/sqlite3
surfer-172-29-7-221-hotspot:~ klaasv$ sqlite3
SQLite version 3.6.12 (I'm still working with an "ancient" version of OS X 
"Snow Leopard")
--
. prompt (the name I gave to my shellScript)

cd ~/binz

--[[z4us|binz--]]
sqlite3
SQLite version 3.13.0 2016-05-18 10:57:30
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.
sqlite> .version
SQLite 3.13.0 2016-05-18 10:57:30 fc49f556e48970561d7ab6a2f24fdd7d9eb81ff2
sqlite> select sqlite_version();
3.13.0

Kind regards | Vriendelijke groeten | Cordiali saluti,
Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy
https://www.linkedin.com/in/klaas-van-buiten-0325b2102
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] using cerod/sqlite with JDBC

[Klaas Van B.]

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 groeten | Cordiali saluti,
Klaas `Z4us` van Buiten V, Experienced Freelance ICT-Guy
https://www.linkedin.com/in/klaas-van-buiten-0325b2102

[sqlite] No datasize field - why?

[Klaas Van B.]

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 combining marks
>can be appended to a base code point.

>See
>http://stackoverflow.com/questions/10414864/whats-up-with-these-unicode-combining-characters-and-how-can-we-filter-them
>for a stupid / extreme example.

-- 

UTF-* using sometimes a multiple 8 bits for a character. In the past as few as 
five ( e.g. https://en.wikipedia.org/wiki/Baudot_code ).
Around the seventies six old Bull (e,g, GE 400-series' GBCD) resp. eight IBM 
(EBCDIC). ASCII started with seven plus a bit for parity checking. As always: 
YMMV.

One may use this knowledge for encrypting I guess.

Kind regards/Vriendelijke groeten.
Klaas `Z4us` Van B., CEO/CIO LI#437429414

[sqlite] FOREIGN KEY constraint failed

[Klaas Van B.]

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 foreign_keys = OFF;

After restructuring is executed successfully you can test the result by 
querying with this pragma ON.
http://sqlite.org/pragma.html#pragma_foreign_keys

Kind regards/Vriendelijke groeten.
Klaas `Z4us` Van B., CEO/CIO LI#437429414

[sqlite] Article about pointer abuse in SQLite

[Klaas Van B.]

>> 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
> C-language standards changed that.  How does one write code that will
> comply with language standards that keep changing out from under you?

It's like trying to live according to the law while they're changing the 
constitution.


Kind regards/Vriendelijke groeten.
Klaas `Z4us` Van B., CEO/CIO LI#437429414

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

[Klaas Van B.]

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 sites like StackOverflow, gitHub etc. there are 
lots of colleagues willing to discuss SQLite issues.

Kind regards/Vriendelijke groeten.
Klaas `Z4us` Van B., CEO/CIO LI#437429414