Re: [sqlite] Documentation Error

https://www.sqlite.org/c3ref/open.html On Wed, Aug 23, 2017 at 10:29 PM, J Decker <d3c...@gmail.com> wrote: > > > If URI filename <https://www.sqlite.org/uri.html> interpretation is > enabled, and the filename argument begins with "file:", then the filen

Re: [sqlite] Fwd: How can I make this faster?

On Mon, Aug 14, 2017 at 2:34 AM, Rowan Worth <row...@dug.com> wrote: > On 14 August 2017 at 17:11, J Decker <d3c...@gmail.com> wrote: > > > I monitored the process with ProcMon (I'm on windows 7 BTW) > > > > 12:55:34.7416316 AM node.exe 9012 WriteFile >

Re: [sqlite] Yes, NULL is zero, is it?

That and MinGW defines NULL as 0 if C++ and not void(*) #ifndef NULL #ifdef __cplusplus #ifndef _WIN64 #define NULL 0 #else #define NULL 0LL #endif /* W64 */ #else #define NULL ((void *)0) #endif #endif On Thu, Aug 31, 2017 at 7:34 PM, Keith Medcalf wrote: > > Ah. Ok.

Re: [sqlite] Please remove multiple warnings from compiler about optimisation, variable conversion, signed overflow and many more potential errors.

most cases... it would show under pragma comiple_options no options, and yet end up using a whole bunch of options in the code. > > On 10/6/17 12:17 AM, J Decker wrote: > >> Fixing the #if is only like 1-5% of the warnings he's complaining >> about... >> >> A lar

Re: [sqlite] Best way to develop a GUI front-end

I'll throw my 2 cents in... A Node.js server, and use a web frontend, or electron/nwjs which are browsers that include node, and can be standalone apps. On Tue, Nov 14, 2017 at 1:33 PM, Balaji Ramanathan < balaji.ramanat...@gmail.com> wrote: > Thank you everyone for your suggestions. > > Looked

Re: [sqlite] Best way to develop a GUI front-end

On Tue, Nov 14, 2017 at 8:14 PM, jungle boogie <jungleboog...@gmail.com> wrote: > Thus said J Decker on Tue, 14 Nov 2017 13:35:55 -0800 > >> I'll throw my 2 cents in... >> >> A Node.js server, and use a web frontend, or electron/nwjs which are >> browsers that

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

On Fri, Nov 24, 2017 at 11:25 AM, Keith Medcalf wrote: > > Actually a UUID or a GUID has a 100% certainty of a collision, not just a > possibility of a collision. Just as all hash algorithms which take > something and generate a shorter "hash" or "checksum" will always

Re: [sqlite] "BIGINT" doesn't act like INTEGER on table creation [Bug]

On Fri, Nov 24, 2017 at 3:13 PM, Peter Halasz wrote: > Sorry to steer the conversation back to the topic. > > Looks like I do need to use AUTOINCREMENT after all, otherwise the > framework I'm using doesn't appear to recognize that INTEGER PRIMARY KEY > columns are

Re: [sqlite] Many ML emails going to GMail's SPAM

Amongs all of these, I'd like to throw in that I'd like to see a gitter.im channel for sqlite (as opposed to discord or slack). gitter is much easier to share code snippets on and is much faster. It's also got nice integration with github... although that's less important since sqlite isn't

Re: [sqlite] Article on AUTOINC vs. UUIDs

On Thu, Nov 30, 2017 at 7:14 AM, Wout Mertens wrote: > The article is a bit muddled, the only real argument I could find is that > auto-inc makes next keys easy to guess, which is information leakage, which > means that is a potential security problem if that information

Re: [sqlite] Article on AUTOINC vs. UUIDs

On Thu, Nov 30, 2017 at 11:52 AM, Keith Medcalf <kmedc...@dessus.com> wrote: > > On Thursday, 30 November, 2017 09:27, J Decker <d3c...@gmail.com> wrote: > > >> UUIDs are nice though if you don't have a natural key available and > >> you are gen

Re: [sqlite] Does sqlite have official development testing tool?

On Thu, Dec 14, 2017 at 4:19 AM, advancenOO wrote: > Hello Richard, > > I hope to run some tests by myself and I think TCL tests in your link are > what I want. > There are so many .tcl and .test in Sqlite source tree. > Could someone share what commands I need to

Re: [sqlite] Does sqlite have official development testing tool?

On Fri, Dec 15, 2017 at 7:05 AM, John G wrote: > If you don't have Tcl/Tk ... if you are using MacOS or Linux you already > have it. > On Windows you can download it from https://www.activestate.com/activetcl > > I have a religious prohibition against activestate

Re: [sqlite] API, sqlite3_value_bytes and sqlite3_value_blob...

On Wed, Dec 13, 2017 at 1:25 PM, petern wrote: > Dave. The documentation contains many such catch-all statements which do > not reflect a full decision tree. The usual cover story will either be (I > paraphrase) : 1. "that's an implementation detail" or 2. "it might

Re: [sqlite] Enabling MMAP in Android

On Tue, Dec 12, 2017 at 4:35 PM, Howard Chu wrote: > Martin Raiber wrote: > >> On 12.12.2017 19:47 Simon Slavin wrote: >> >>> On 12 Dec 2017, at 6:27pm, Jens Alfke wrote: >>> >>> On Dec 12, 2017, at 5:46 AM, Simon Slavin wrote:

Re: [sqlite] Most efficient way to detect on-disk change

in linux inotify - http://man7.org/linux/man-pages/man7/inotify.7.html in windows FindFirstChangeNotification/FindNextChangeNotification https://msdn.microsoft.com/en-us/library/windows/desktop/aa365261(v=vs.85).aspx if you wait for an actual change before checking to see if there really was a

Re: [sqlite] Good resources for TCL/TK

On Sat, Nov 18, 2017 at 6:35 AM, Cecil Westerhof wrote: > 2017-11-18 15:14 GMT+01:00 Eric : > > > On Sat, 18 Nov 2017 14:43:23 +0100, Cecil Westerhof < > > cldwester...@gmail.com> wrote: > > > I found the benefits for TCL/TK. But this is a SQLite mailing

[sqlite] VFS FCNTL question

https://sqlite.org/c3ref/c_fcntl_busyhandler.html #define SQLITE_FCNTL_PDB 30 SQLITE_FCNTL_PDB has no documentation as to what it's for. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] How to create primary key from two another PK's?

Or you could do something really fancy https://en.wikipedia.org/wiki/Z-order_curve http://www.forceflow.be/2013/10/07/morton-encodingdecoding-through-bit-interleaving-implementations/ - (x,y,z) = *(5,9,1)* = (0101,1001,0001) - Interleaving the bits results in: 010001000111 = *1095* th

Re: [sqlite] Map a field type to a best suited sqlite3_result_* call

On Sat, May 5, 2018 at 4:08 AM, Max Vlasov <max.vla...@gmail.com> wrote: > On Sat, May 5, 2018 at 1:19 PM, J Decker <d3c...@gmail.com> wrote: > > > https://www.sqlite.org/c3ref/column_blob.html > > > > The sqlite3_column_type() routine returns th

Re: [sqlite] Map a field type to a best suited sqlite3_result_* call

https://www.sqlite.org/c3ref/column_blob.html The sqlite3_column_type() routine returns the datatype code for the initial data type of the result column. The returned value is one of SQLITE_INTEGER, SQLITE_FLOAT, SQLITE_TEXT, SQLITE_BLOB, or SQLITE_NULL. The return value of sqlite3_column_type()

Re: [sqlite] SQLite3 Error: Unable to open database file when file path has accents (e.g. é or è)

On Tue, May 8, 2018 at 2:11 PM, Richard Hipp wrote: > On 5/8/18, Francis Kus wrote: > > I am able to open my database file if the path contains no accents. > However, > > if I change even one letter to an accented letter (e.g. replace 'e' with > > 'é'),

Re: [sqlite] Stored Procedures

maybe Virtual tables? can register functions of various types... mostly since the typical usage of sqlite is as a tightly coupled library, a function in your application is a 'stored procedure'. http://www.sqlite.org/c3ref/update_hook.html There are hooks which would trigger callbacks like

Re: [sqlite] Getting statement column data types on Android

https://www.sqlite.org/c3ref/column_blob.html int sqlite3_column_type(sqlite3_stmt*, int iCol); ? On Mon, May 7, 2018 at 4:28 PM, Bart Smissaert wrote: > Yes, thanks, that might be the best way, but it can get a bit complicated > with complex SQL. > > RBS > > > > On

Re: [sqlite] Yes - Getting SPAM from Using Mailing List

On Sat, Apr 28, 2018 at 2:08 AM, Luuk wrote: > On 28-4-2018 07:36, Luuk wrote: > > On 27-4-2018 20:57, Denis Burke wrote: > >> I know steps were taken to reduce it, but just confirming it is still > going > >> on today. > >> ___ > >>

Re: [sqlite] Yes - Getting SPAM from Using Mailing List

https://productforums.google.com/forum/?utm_medium=email_source=footer#!msg/gmail/vaG8BpMPov0/JqRR4wk2CQAJ On Sat, Apr 28, 2018 at 3:05 AM, J Decker <d3c...@gmail.com> wrote: > > > On Sat, Apr 28, 2018 at 3:01 AM, Luuk <luu...@gmail.com> wrote: > >> >>

Re: [sqlite] Yes - Getting SPAM from Using Mailing List

On Sat, Apr 28, 2018 at 3:01 AM, Luuk <luu...@gmail.com> wrote: > > On 28-4-2018 11:26, J Decker wrote: > > On Sat, Apr 28, 2018 at 2:08 AM, Luuk <luu...@gmail.com> wrote: > > > >> On 28-4-2018 07:36, Luuk wrote: > >>> On 27-4-2018 20:57

Re: [sqlite] Usage of temporary files of SQLite3 on Android / SQLite commands fail

On Sat, Jun 9, 2018 at 10:00 AM skywind mailing lists < mailingli...@skywind.eu> wrote: > Hi, > > what is your experience with temporary files requested by SQLite3 on > Android? I am using SQLite3 natively on Android - I compiled SQLite3 by > myself - and get an error when SQLite3 tries to create

Re: [sqlite] Idea: defining table-valued functions directly in SQL

On Sat, Jun 9, 2018 at 7:37 PM Andy Goth wrote: > > This is probably not going to be added > until SQLite's primary developers themselves decide they need it, or > until someone else decides it's important enough to them to contribute > code and/or funding. > forget contributing code ... but

Re: [sqlite] Idea: defining table-valued functions directly in SQL

On Sun, Jun 10, 2018 at 7:48 AM Simon Slavin wrote: > On 10 Jun 2018, at 2:40pm, J Decker wrote: > > > forget contributing code ... but funding? how much can I pay to get > better > > NUL support? > > Can you tell us what's wrong with NUL support ? > I have, re

Re: [sqlite] [fossil-users] Mailing list shutting down...

could use Gitter ( https://gitter.in ) is nice; emails on directed messges; retains discussion histories; integrates with various other platforms... git in particular such a referecning issues and pull requests with just # supports markdown formatting; which makes talking about `code fragments`

Re: [sqlite] Mailing list shutting down...

On Wed, Jun 13, 2018 at 5:17 PM Simon Slavin wrote: > 13 Jun 2018, at 11:52pm, Bob Friesenhahn > wrote: > > > The problem is knowing what "one" means. The subscription request is > likely submitted via http/https into the web form and using a bogus email > subscription address (of the

Re: [sqlite] Window functions

What are 'window functions'? If you mean GUI; that's really outside the scope of Sqlite; and whatever environment you're in can provide your GUI; https://www.npmjs.com/package/sack-gui for instance for Javascript(Node.js). On Wed, Apr 25, 2018 at 12:04 PM, Charles Leifer

Re: [sqlite] Move to Github!!?

While this is really entirely derailed I'll add... If monotone wasn't dead 6 years now I'd be using that...but it doesn't support unicode filenames very well; and they haven't wanted to do updates. I was really resistant to migrating to Git; actually almost any other alternaitve of them.

Re: [sqlite] PRAGMA help

On Sat, Dec 30, 2017 at 1:04 AM, Tony Papadimitriou wrote: > Is there some way to get a list of all available pragma options from the > SQLite3 shell? > https://sqlite.org/pragma.html If it was built with SQLITE_INTROSPECTION_PRAGMAS, which by default it is not. and

Re: [sqlite] How to prevent the insertion of cycles into a hierarchical table?

make child a unique key. so each node can only have 1 parent. On Sun, Dec 24, 2017 at 6:44 AM, Lifepillar wrote: > On 24/12/2017 11:56, Shane Dev wrote: > >> Related to my previous question >> https://www.mail-archive.com/sqlite-users@mailinglists.sqlit >>

Re: [sqlite] SQLite 3.22.0 coming soon

swarmvtab3 test is still failing... (windows 10, msvc 2017) 10.0.16299.0 swarmvtab3-1.2.3... Error: inconsistent ::dbcache and disk swarmvtab3-1.3.3... Error: inconsistent ::dbcache and disk On Tue, Jan 9, 2018 at 11:46 AM, Simon Slavin wrote: > On 9 Jan 2018, at

Re: [sqlite] SQLite 3.22.0 coming soon

On Tue, Jan 9, 2018 at 1:19 PM, Gwendal Roué wrote: > > > Le 9 janv. 2018 à 21:47, Richard Hipp a écrit : > > > > On 1/9/18, Gwendal Roué wrote: > >> 1. For statements made of parameters, such as `SELECT ?, ?` or `SELECT > :a, >

Re: [sqlite] sqlite_column_table_name() and table alias name

On Mon, Jan 15, 2018 at 5:14 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > J Decker wrote: > > What is the expected output? > > And just out of curiosity: what should the table name be for these columns? > > SELECT articles.gmt_deleted+tags.type, 42, id FROM art

Re: [sqlite] Can an SQL script be built from within sqlite?

But; dropbear ssh sometimes works? Some have issues making it work so a shell is possible; they just don't have a termianl in the store? Would be a pretty limited userbase On Mon, Jan 15, 2018 at 7:00 AM, Richard Hipp wrote: > On 1/15/18, Shane Dev

Re: [sqlite] sqlite_column_table_name() and table alias name

On Mon, Jan 15, 2018 at 7:05 AM, J Decker <d3c...@gmail.com> wrote: > > > On Mon, Jan 15, 2018 at 5:14 AM, Clemens Ladisch <clem...@ladisch.de> > wrote: > >> J Decker wrote: >> > What is the expected output? >> >> And just out of curiosi

Re: [sqlite] sqlite_column_table_name() and table alias name

from fruit join fruit_color USING(fruit_id) join color as c USING(color_id)` ). wouldn't make that the production version of data to rely on... and wouldn't want to query 1M records with triplicated values :) On Mon, Jan 15, 2018 at 7:07 AM, J Decker <d3c...@gmail.com> wrote: > > > On M

Re: [sqlite] sqlite_column_table_name() and table alias name

be the same value sorted by sqlite nicely) > That is what I've implemented in the PR I sent to node-sqlite3. > > > On 16 Jan 2018, at 3:59 AM, J Decker <d3c...@gmail.com> wrote: > > > > One more example for the road... > > > > create table fruit ( fr

Re: [sqlite] Feature request for the Shell Tool: .mode json

On Sat, Jan 20, 2018 at 9:54 PM, Simon Slavin wrote: > Feature request for the Shell Tool: ".mode json". > > Output should be as a JSON array of objects, with one object for each row > of the table. Output should start with the "[" character and end with > "]". Rows

[sqlite] sqlite command line tool fails to dump data

sqlite test.db create table test (a,b) insert into test (a,b) values ( ?,? ) bind 'hello\0world.' 'te\0st' .dump table -- output CREATE TABLE test (a,b); INSERT INTO test VALUES('hello','te'); ___ sqlite-users mailing list

Re: [sqlite] sqlite command line tool fails to dump data

On Sun, Jan 21, 2018 at 7:42 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > J Decker wrote: > > insert into test (a,b) values ( ?,? ) > > bind 'hello\0world.' 'te\0st' > > <http://www.sqlite.org/c3ref/bind_blob.html> says: > | If a non-n

Re: [sqlite] Feature request for the Shell Tool: .mode json

On Sun, Jan 21, 2018 at 3:50 PM, Stadin, Benjamin < benjamin.sta...@heidelberg-mobil.com> wrote: > Hi Simon, > > I recently wrote a tool to convert an arbitrary SQLite result set to > properly typed json key/value pairs, using the SQLite type affinity of the > objects. Though the code is in C++.

Re: [sqlite] sqlite command line tool NUL support

This is a picture. This is a tortoise git log view of merges. https://drive.google.com/open?id=1RosGlprJRoutFsou2XDRlflxc8xWoHks On Wed, Jan 24, 2018 at 8:59 AM, J Decker <d3c...@gmail.com> wrote: > > So for output of a select in the shell ( unlike .dump ) is this. > >

Re: [sqlite] SQLite DELUXE Re: sqlite command line tool NUL support

adopted despite having zero impact by > conditional compilation switch: http://sqlite.chncc.eu/ > > The argument against improving generality of the official release because > it slows down some phones will never go away. Your changes may have to > shadow the official release for

Re: [sqlite] UTF8 and NUL

On Thu, Jan 25, 2018 at 7:57 PM, J Decker <d3c...@gmail.com> wrote: > NUL is a valid utf8 character > but FF is never valid. (would be like a 36 bit length specification) > and practically anthing more than F8 is invalid utf8 character. > Other than BOM > https://

[sqlite] UTF8 and NUL

NUL is a valid utf8 character but FF is never valid. (would be like a 36 bit length specification) and practically anthing more than F8 is invalid utf8 character. Other than BOM https://en.wikipedia.org/wiki/Byte_order_mark#UTF-8 EF BB BF 239 187 191 // EF - 80 | 3b - 80 | 3f ( 0xfeff ) Many

Re: [sqlite] UTF8 and NUL

On Fri, Jan 26, 2018 at 5:55 AM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > What is the goal of this discussion? Changing the string terminator SQLite > uses? I think it's almost 50 years too late for that, but I'm sure that if > Unicode and UTF8 had been a thing in 1970 then C

Re: [sqlite] UTF8 and NUL

On Fri, Jan 26, 2018 at 10:35 AM, Tim Streater wrote: > On 26 Jan 2018, at 18:12, Keith Medcalf wrote: > > > Actually, EOF (0xFF) *is* part of a text file, and is the byte in an > ASCII > > byte-stream that indicates end-of-file. > > First I've heard

Re: [sqlite] UTF8 and NUL

On Fri, Jan 26, 2018 at 10:22 AM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 1/26/18, 12:12 PM, "sqlite-users on behalf of Keith Medcalf" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf of > kmedc...@dessus.com> wrote: > > Actually, EOF (0xFF) *is* part of a text file,

Re: [sqlite] UTF8 and NUL

On Fri, Jan 26, 2018 at 10:44 AM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 1/26/18, 12:40 PM, "sqlite-users on behalf of J Decker" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf of d3c...@gmail.com> > wrote: > > reads the byte

Re: [sqlite] sqlite_column_table_name() and table alias name

Maybe this patch (the same, but against original source instead of amalgamation) against current fossil head https://drive.google.com/open?id=1c24qvtvS57ASJF5RfZxLJSsgI2FhOVk1 On Sun, Jan 14, 2018 at 11:17 PM, Jake Chen wrote: > Hi Peter, > > Currently the query result

Re: [sqlite] SQLite 3.22.0 coming soon

On Tue, Jan 9, 2018 at 12:30 PM, J Decker <d3c...@gmail.com> wrote: > swarmvtab3 test is still failing... (windows 10, msvc 2017) 10.0.16299.0 > > swarmvtab3-1.2.3... > Error: inconsistent ::dbcache and disk > swarmvtab3-1.3.3... > Error: inconsistent ::dbcache

Re: [sqlite] sqlite_column_table_name() and table alias name

} } ? On Mon, Jan 15, 2018 at 1:59 AM, J Decker <d3c...@gmail.com> wrote: > Maybe this patch (the same, but against original source instead of > amalgamation) against current fossil head > > Hmm updated tests too; but bork capi3.test; I don't know how to sperate .22 and .32 to differen

[sqlite] sqlite command line tool NUL support

So for output of a select in the shell ( unlike .dump ) is this. for(i=1; iout, ",%s", sqlite3_column_text(pSelect, i)); } option 1) add text conversion in the column_text to escape NUL characters. in TEXT... then everyone everywhere would inherit the

Re: [sqlite] UTF8 and NUL

On Fri, Jan 26, 2018 at 1:21 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > Sqlite uses NUL as the string terminator internally, the published API > specifies has stuff like this all over the place: > > > In those routines that have a fourth argument, its value is the number > of

Re: [sqlite] UTF8 and NUL

On Fri, Jan 26, 2018 at 11:41 AM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 1/26/18, 1:37 PM, "sqlite-users on behalf of J Decker" < > sqlite-users-boun...@mailinglists.sqlite.org on behalf of d3c...@gmail.com> > wrote: > >doesn't get 2

Re: [sqlite] UTF8 and NUL

On Fri, Jan 26, 2018 at 3:56 PM, Peter Da Silva < peter.dasi...@flightaware.com> wrote: > On 2018-01-26, at 17:05, J Decker <d3c...@gmail.com> wrote: > > On Fri, Jan 26, 2018 at 1:21 PM, Peter Da Silva < > > peter.dasi...@flightaware.com> wrote: > >>

Re: [sqlite] UTF8 and NUL

> --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of J Decker &

Re: [sqlite] UTF8 and NUL

agical C-Style-String that is not > > actually a C-Style-String, without explicitly stating this. > > > > SQLite3 does handle non-C-Ctyle-Strings. They are called "blobs". > > > > --- > > The fact that there's a Highway to Hell but only a Stairway to Hea

Re: [sqlite] UTF8 and NUL

; isn't an API export, and calling exec() on the same DB handle will > only reenter the user defined like(). > If calling the default implementation from the overloaded one is > impossible, I'd say the LIKE overload system has a bug. > > > Peter > > > > > > > > &

Re: [sqlite] sqlite3_set_last_insert_rowid

Probably best reserved for initialization of a shard of a database where you can set next to last of a prior .db. On Tue, Jan 30, 2018 at 9:14 AM, petern wrote: > For one, within a function that does an INSERT, set_last_insert_rowid makes > it possible to "pop"

[sqlite] @sqlite-tool-maintainers Table Name Information?

I would think as output for a GUI for browsing sqlite databases, knowing table name is useful. But what if the SQL command given contains an alias of the table name as in a table that is self-joined? Wouldn't it also be useful to be able to get that alias? And in face default to Alias and show

Re: [sqlite] Vetting SQLite

On Mon, Feb 5, 2018 at 5:04 PM, Richard Hipp wrote: > On 2/5/18, Stephen Chrzanowski wrote: > > I was surprised to see that statement, so, checking my system, this isn't > > true. Win7Pro-x64. > > It's on Windows10. > M:\>dir c:\windows\SysWOW64\*sqlite*

Re: [sqlite] Auto Index Warnings; key on deterministic functions

--- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic volume. > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of J Decker > >Sent: Monday,

[sqlite] Auto Index Warnings; key on deterministic functions

I have a couple tables like... create table tableA ( pk PRIMARY KEY, dataA ) create table tableB ( fk, dataB, FOREIGN KEY (fk) REFERENCES tableA(pk) ON DELETE CASCADE ) if the table was also ON UPDATE CASCADE could it slave to the same index as primary key? doing a LEFT JOIN on the tables I

Re: [sqlite] sqlite3_expanded_sql is reading freed heap memory

can you use sqlite3_sql instead; it won't be complete information... but ya, the time that expanded_sql is valid is really only while the bound parameters are still valid. (could re-bind parameters when done I guess) On Tue, Feb 6, 2018 at 1:07 PM, Jens Alfke wrote: >

Re: [sqlite] Different kind of constraint

Just a thought; a thumbnail/cover image seems like somehting that is often gotten before lots of other data, and maybe storing that alone in a table of covers would keep that index shorter for the entry pages... And then you could enforce unique parent id on the cover and not on the content. On

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

On Sat, Feb 17, 2018 at 3:36 PM, Richard Hipp wrote: > On 2/17/18, Ralf Junker wrote: > > Example SQL: > > > > select > >length(printf ('%4s', 'abc')), > >length(printf ('%4s', 'äöü')), > >length(printf ('%-4s', 'abc')), > >length(printf

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

On Mon, Feb 19, 2018 at 5:38 PM, petern wrote: > FYI. See http://www.sqlite.org/src/timeline for the equivalent DRH > checkins: http://www.sqlite.org/src/info/c883c4d33f4cd722 > Hopefully that branch will make a forthcoming trunk merge. [Printing > explicit nul

Re: [sqlite] invalid date time

On Sun, Feb 18, 2018 at 10:02 PM, Olivier Leprêtre wrote: > Hi, > > > > I have an sqlite database with wrong information in a timestamp field. > Using > System.Data.Sqlite, I want to get this information as a string inside a > very > simple loop. > > > > while (i <

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

On Mon, Feb 19, 2018 at 7:49 PM, petern wrote: > There are other uses for padding strings besides user reports. Consider > scalar representations of computations for example. Also: > > 1.There was no mention of user display formatting in Ralf's original > report.

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

On Mon, Feb 19, 2018 at 2:54 AM, Ralf Junker wrote: > On 19.02.2018 09:50, Rowan Worth wrote: > > What is your expected answer for: >> >> select length(printf ('%4s', 'です')) >> > > 'です' are 2 codepoints according to > >

Re: [sqlite] printf() problem padding multi-byte UTF-8 code points

On Mon, Feb 19, 2018 at 3:21 AM, Cezary H. Noweta wrote: > Hello, > > On 2018-02-18 00:36, Richard Hipp wrote: > >> The current behavior of the printf() function in SQLite, goofy though >> it may be, exactly mirrors the behavior of the printf() C function in >> the standard

Re: [sqlite] sqlite problem - field names missing in select

https://sqlite.org/c3ref/column_name.html You can get the column names. On Fri, Feb 23, 2018 at 4:46 AM, M wrote: > sqlite has an integral problem, field names cannot be selected each one > inside a program, there is way to do it, but it is not straight and >

Re: [sqlite] Move to Github!!?

On Mon, Dec 25, 2017 at 8:24 PM, Jay Kreibich wrote: > > > On Dec 25, 2017, at 12:24 PM, J. King wrote: > > > > SQLite source is managed in a Fossil (not Git) repository, which is > software itself designed by Dr. Hipp and based on SQLite. GitHub would be >

Re: [sqlite] pragma table_info return column delimiters?

delimiters delimit, so they are not part of the context.. such information aobut delimiters is never saved... since they havce done their job delimiiting already. Why do you want this? On Wed, Jan 3, 2018 at 2:50 AM, Bart Smissaert wrote: > > What are column

Re: [sqlite] Move to Github!!?

On Tue, Dec 26, 2017 at 5:10 AM, Richard Hipp wrote: > On 12/25/17, Shekhar Reddy wrote: > > > > Is there any particular reason that the source is not moved to GitHub? I > > think that would reach more number of people there. > > > > There is a

Re: [sqlite] Move to Github!!?

On Tue, Dec 26, 2017 at 5:10 AM, Richard Hipp wrote: > > Finally, the use of GitHub would create a reliance on an outside > company over which we have no influence. The people who run GitHub > today seem like great folks. But the company might be sold or fall > under new

Re: [sqlite] Move to Github!!?

me. > > >-Original Message- > >From: sqlite-users [mailto:sqlite-users- > >boun...@mailinglists.sqlite.org] On Behalf Of Bob Friesenhahn > >Sent: Tuesday, 26 December, 2017 12:08 > >To: SQLite mailing list > >Subject: Re: [sqlite] Move to Github!!? &g

[sqlite] (no subject)

I have these options ... version 3.23.0. "SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0","SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", "SQLITE_DEFAULT_FOREIGN_KEYS=1" This is the end of operations... It's starting to get an option...

Re: [sqlite] (no subject)

On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > > >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", > >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", > >"SQLITE_DEFAULT_FOREIGN_KEYS=1" > > >Is there something about the combination of options I've used? > > Do you get

Re: [sqlite] (no subject)

On Mon, Jul 30, 2018 at 7:09 PM J Decker wrote: > > > On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > >> >> >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", >> >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_MET

Re: [sqlite] Foreign Key error

1f|System Settings I have kinda an old command line tool - but it does the same thing. On Mon, Jul 30, 2018 at 8:11 PM J Decker wrote: > > > On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > >> >> >"SQLITE_ENABLE_LOCKING_STYLE=0",&qu

Re: [sqlite] Foreign Key error

. On Mon, Jul 30, 2018 at 11:13 PM Clemens Ladisch wrote: > J Decker wrote: > > CREATE TABLE `option4_name` (`name_id` char(36) NOT NULL,`name` > > varchar(255) NOT NULL default '' CONSTRAINT `name` UNIQUE) > > > FOREIGN KEY (`name_id`) REFERENCES `option4_name`(`nam

Re: [sqlite] "Cheating" at making common tables

I did this sort of thing in Xperdex ( https://sourceforge.net/projects/xperdex/ ) which is a C# thing, and enabled easy creation of DataTables similarly auto creating ID and Name by stripping pluralization from the name. Was working on a similar thing for JS; but keep getting distracted making it

Re: [sqlite] Foreign Key error

On Mon, Jul 30, 2018 at 2:11 PM Keith Medcalf wrote: > > >"SQLITE_ENABLE_LOCKING_STYLE=0","SQLITE_THREADSAFE=0", > >"SQLITE_OMIT_UTF16","SQLITE_ENABLE_COLUMN_METADATA=1", > >"SQLITE_DEFAULT_FOREIGN_KEYS=1" > > >Is there something about the combination of options I've used? > > Do you get

Re: [sqlite] PRAGMA case_sensitive_like

https://www.sqlite.org/pragma.html#pragma_pragma_list A pragma can take either zero or one argument. The argument is may be either in parentheses or it may be separated from the pragma name by an equal sign. The two syntaxes yield identical results. In many pragmas, the argument is a boolean. The

Re: [sqlite] Invalid Blob Length Error Message

On Fri, Aug 17, 2018 at 5:14 AM Tim Streater wrote: > On 17 Aug 2018, at 01:24, Casey Rodarmor wrote: > > > I wrote an erroneous update statement: > > > > ``` > > UPDATE foo SET bar = x'01234'; > > ``` > > > > The error message was: > > > > ``` > > unrecognized token: "x'01234' > > ``` > > > >

Re: [sqlite] keys

On Fri, Aug 24, 2018 at 4:31 PM wrote: > "The parent key of a foreign key constraint is not allowed to use the > rowid. The parent key must used named columns only." > > Why is this? > Which would be more efficient? > 1) WITHOUT ROWID and column of INTEGER PRIMARY KEY > or > 2) an aliased rowid.

Re: [sqlite] Issue using SEE

On Fri, Jul 20, 2018 at 11:05 AM Keith Medcalf wrote: > > Firstly, the SQLITE_DLL define does not exist (is this a bug in the docs>? > Secondly you did not define SQLITE_HAS_CODEC as required to integrate the > SEE codec/ > Thirdly a .dll file cannot be created with ar. ar is for creating >

[sqlite] how to know which database is corrupted

I have a database that got corrupted; was working on implementing automatic recovery I have a callback configured on SQLITE_CONFIG_LOG sqlite3_config( SQLITE_CONFIG_LOG, errorLogCallback, 0); Which is global, and does not identify the instance. I figured, I could just easily register the

Re: [sqlite] how to know which database is corrupted

On Tue, Jul 24, 2018 at 1:47 PM Simon Slavin wrote: > On 24 Jul 2018, at 8:43pm, J Decker wrote: > > > I have a database that got corrupted; was working on implementing > automatic > > recovery > > It would be a million times better to figure out how the corr

Re: [sqlite] how to know which database is corrupted

On Tue, Jul 24, 2018 at 5:11 PM Simon Slavin wrote: > On 24 Jul 2018, at 11:34pm, J Decker wrote: > > > If the system rebooted; did a screen size change, and terminated the > > program, it's possible it coild cause corruption. > > Step 1: use the command-line t

Re: [sqlite] Strategies to reduce page-loads?

On Thu, Aug 30, 2018 at 4:48 AM Richard Hipp wrote: > On 8/30/18, t...@qvgps.com wrote: > > > > Structure is simple: > > CREATE TABLE Lines(Id LONG PRIMARY KEY, Label VARCHAR(50), Coordinates > > BLOB, Flags INT, StyleId INT); > > And an rtree-index: > > CREATE VIRTUAL TABLE Lines_bb USING

Re: [sqlite] sqlite3_column_* with error handling

On Tue, Sep 4, 2018 at 2:11 PM Keith Medcalf wrote: > > On Tuesday, 4 September, 2018 14:00, Clemens Ladisch > wrote: > > >Keith Medcalf wrote: > >> 6) If the column type is SQLITE_BLOB > >> a) Retrieve the column value pointer using column_blob > >> b) If the returned pointer is

<    1   2   3   4   >