[sqlite] VFS xFullPathname cannot access URI parameters

In 3.31.1, attempting to access URI Parameters via the sqlite3_uri_* functions inside a VFS xFullPathname function returns junk.  This was not an issue in 3.30.1 or 3.31.0. The internals of those functions use the new databaseName() function, which attempts to find the database name from the

Re: [sqlite] log() in sqlite3

The log function does seem to be supported by extension-functions.c which is available from here: https://www.sqlite.org/contrib On Fri, Jan 31, 2020 at 1:30 PM David Raymond wrote: > The core functions of the library are fairly unlikely to get expanded upon > at this point, so it's up to the

Re: [sqlite] "Standard SQL" ?

A few resources I found from https://www.google.com/search?q=sql+standard : - https://en.wikipedia.org/wiki/SQL - https://blog.ansi.org/2018/10/sql-standard-iso-iec-9075-2016-ansi-x3-135/#gref - https://dev.to/0xcrypto/who-owns-the-sql-standard-76m -

Re: [sqlite] A crash bug in sqlite

> Yes. I discovered the same thing independently. The previous fix was > subtly wrong. Please try the latest trunk version. Will there be a patch release, or should we just wait for the next minor? ___ sqlite-users mailing list

Re: [sqlite] Deterministic random sampling via SELECT

in a separate table which could be used in the query of the main data. Since it is a pseudo-random number series, you can repeat it as often as needed using the same seed value. Chris On Thu, 7 Nov 2019, at 15:15, Merijn Verstraaten wrote: > > > On 7 Nov 2019, at 19:16, David Raymo

Re: [sqlite] Last record

rd in advance from sqlite3_step. > What do you mean by "last record"? -- Chris Green · ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] DBMS Normalization Query

Short answer. Duplicate data in a database is bad. Take school departments. For each teacher, do you put "History", "Chemistry", "Biology" for their department? What happens if someone enters "Bioolgy" instead? So for your point #1, "as soon as duplicate data is possible". Maybe not for

Re: [sqlite] 3.29.0 .recover command

> I got foreign key constraint failures I don't know why one would work and one would fail, but usually, this occurs when you insert a record which has foreign keys to another table, but that table hasn't been imported yet. The workaround is usually to ensure all the 'lookup' tables are done

Re: [sqlite] Proposal: SQLite on DNA

> > May I humbly suggest that the development team look into porting to a new > > platform: > > > +1 (+100) > As in Viral File System? Yes (haha) ___

Re: [sqlite] Quirks of SQLite. Was: Version 3.29.0

e, "SQLite *has* no DATETIME datatype" Section 4 "there where already countless millions of databases" should be, "there *were* already countless millions of databases" Thanks, Chris On Thu, Jul 11, 2019 at 3:22 PM Richard Hipp wrote: > On 7/11/19, David

Re: [sqlite] round function inconsistent

> Yours is clearly incorrect lol. "Your software gives a different result to the one I expect, therefore its wrong." You are aware that your first example (3.255) probably isn't being stored internally as a single. Just because computers work outside your understanding doesn't make them

Re: [sqlite] Series of statements results in a malformed database disk image

Edit: HOWEVER, just ran an integrity check, and that did fail. "wrong # of entries in index sqlite_autoindex_t1_1" On Thu, May 9, 2019 at 3:52 PM Chris Locke wrote: > Are you using a new database when you create your table, or using an > existing database? > Are you wr

Re: [sqlite] Series of statements results in a malformed database disk image

Are you using a new database when you create your table, or using an existing database? Are you writing your database locally? What operating system / sqlite version are you using? The above test works for me... > Execution finished without errors. > Result: 1 rows returned in 62ms > At line

Re: [sqlite] Unexpected or wrong result and no warning/error, bug?

> create table t(s varchar(5)); Also note that SQLite doesn't 'understand' varchar (it uses text) and it doesn't limit the entry to 5 characters. This doesn't help your issue directly, but does highlight that you've not read the SQLite documentation, and aren't creating tables properly. On Fri,

Re: [sqlite] Remove row to insert new one on a full database

of disk space, it could be you need to vacuum your database file. How large is the database? How much disk space do you have left? Thanks, Chris On Fri, Apr 5, 2019 at 1:46 PM Arthur Blondel wrote: > OK, I wasn't clear. > I'm limited in space so when the DB is full (when sqlite

Re: [sqlite] Remove row to insert new one on a full database

der the problem, rather than asking for help on a solution which may not be required. Thanks, Chris On Thu, Apr 4, 2019 at 11:53 AM Arthur Blondel wrote: > Hello > > When I try to insert new data to a full SQLite database, I need to remove > much more than really needed. I'm doing the follo

[sqlite] Typo - https://www.sqlite.org/see/doc/trunk/www/index.wiki

On the page https://www.sqlite.org/see/doc/trunk/www/index.wiki in the 'key links' section, there is a link to 'Files in the lastest release of SEE'. This should be 'latest' and not 'lastest'. Thanks, Chris ___ sqlite-users mailing list sqlite-users

Re: [sqlite] Apparent power fail data loss in embedded use - SQLite newbie

> SQLite is built from (the combined) source as part of the project build. > [...] If you want extra safety, I would recommend you consider using SQLITE_DEFAULT_SYNCHRONOUS=3 which is the equivalent to using PRAGMA synchronous=EXTRA. Quick references: *

[sqlite] Number of open connections

returned the number of open database connections. Thanks, Chris ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Number of open connections

Thanks Richard for the reply. Appreciated. On Tue, Mar 12, 2019 at 2:49 AM Richard Hipp wrote: > On 3/11/19, Chris Locke wrote: > > Does SQLite keep a count of the number of current open connections to the > > database? > > No. > > SQLite can find out if some other

[sqlite] Number of open connections

returned the number of open database connections. Thanks, Chris ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [EXTERNAL] Integration with las version of SQLite

I fear the OP is referring to DB Browser for SQLite. This recently released v3.11.1. @desarrollo - I would suggest contacting the DB Browser for SQLite developers at this address: https://github.com/sqlitebrowser/sqlitebrowser/issues Thanks, Chris On Wed, Mar 6, 2019 at 3:47 PM Hick Gunter

Re: [sqlite] Safe (atomic) db file snapshot and update

close the connection? (ie, is the connection open all the time) Thanks, Chris On Wed, Mar 6, 2019 at 11:33 AM Anton Polonskiy wrote: > Scenario 1: > Multiple processes write to foo.db. > I want to do some periodic snapshots. > What is the best way to do this without interruptin

Re: [sqlite] Handling ROLLBACK

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

Re: [sqlite] Site search bug - https://sqlite.org/

The link you quote mentions SQLite 3.24 though... ? Thanks, Chris On Wed, Feb 27, 2019 at 12:44 PM niki wrote: > This link demonstrates the problem: > > https://sqlite.org/search?s=c=3.24 > > Best regards, > > Niki > > ___

[sqlite] Cannot Modify Table if Part of a View

Again, it sounds exactly like the issue we are having here. The second ticket is still open, so no fix there yet. Last modification was 2018-10-03. Is there any confirmation or further details on this issue at all? Thanks, Chris ___ sqlite-u

Re: [sqlite] Vacuum into

Chris On Fri, Feb 8, 2019 at 4:22 PM David Raymond wrote: > So to make sure I'm understanding it ok, with the new vacuum into command, > if I'm the only user of a file, then the sequence... > > open file1 > vacuum into file2 > close file1 > delete file1 &g

Re: [sqlite] SQLITE_DBCONFIG_DEFENSIVE documentation looks confusing

this right, really wish it were better documented. On Tue, Jan 29, 2019 at 10:17 AM Chris Brody wrote: > > I am very sorry to say that I have found the usage of the > SQLITE_DBCONFIG_DEFENSIVE option to be somewhat confusing. > > From my first reading of https://www.sqlite.org/r

[sqlite] SQLITE_DBCONFIG_DEFENSIVE documentation looks confusing

I am very sorry to say that I have found the usage of the SQLITE_DBCONFIG_DEFENSIVE option to be somewhat confusing. From my first reading of https://www.sqlite.org/releaselog/3_26_0.html I thought SQLITE_DBCONFIG_DEFENSIVE was a compile-time option. (I was proven wrong pretty quickly.) Then I

Re: [sqlite] SQLite slow when lots of tables

Ryan Smith has already covered this scenario. "And to add to the slew of "Few-tables-many-rows rather than Many-tables-few-rows" solutions offered, one thing to note: After a single table contains a few million rows, INSERTing will become slightly slower, but the difference will still be

Re: [sqlite] SQLite slow when lots of tables

I don't know - that's why I asked. Thanks for the clarification. On Mon, Jan 28, 2019 at 10:10 PM Warren Young wrote: > On Jan 28, 2019, at 2:44 PM, Chris Locke wrote: > > > >> The table name should not be meaningful to your application; nothing in > >> your ap

Re: [sqlite] SQLite slow when lots of tables

> The table name should not be meaningful to your application; nothing in > your application should conjure up a table name. I can't get my head around this advice. Is this just for this occasion, or for every application? What if I'm writing a customer address book? Am I allowed a table

Re: [sqlite] SQLite slow when lots of tables

Why do you need to create a new table each time? Its easier to create a relational database. This means create one main table that might (for example) have a 'tableID' field, which points to just one other table. This means you only need two tables. Not 20,000+ Just an idea. Depends on what

Re: [sqlite] Building SQLite DLL with Visual Studio 2015

Just curious as to why you wouldn't choose option #2 - as that's what I use with my VB .NET applications, which work quite well. Just distribute the .exe, then the two SQLite DLLs (well, three technically, as there are two versions of the interop.dll) Thanks, Chris On Mon, Jan 21, 2019 at 4:19

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

> Just because something doesn't have to be calculated, means that it has to be stored as text. Sorry - forgot a 'doesn't'. Just because something doesn't have to be calculated, doesn't mean that it has to be stored as text. On Thu, Dec 20, 2018 at 3:42 PM Chris Locke wrote: > Just b

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

19 Dec 2018 10:55:11 + > Chris Locke wrote: > > > Fields with '_no' are read as 'number' and so should be a number. > > OK, that doesn't always work for 'telephone_no' (they usually start > > with a 0 > > Lots of numbers are labels that aren't meant to be calculate

Re: [sqlite] SQLite Application Question

uery takes milliseconds and a database can hold a whole manner of settings, configurations, etc. File size is small and efficient too. Thanks, Chris On Thu, Dec 20, 2018 at 9:05 AM Roger Schlueter wrote: > On 12/19/2018 23:01, Chris Locke wrote: > > What application are you using to build you

Re: [sqlite] SQLite Application Question

' column. The 'setting' column holds the full setting you want to store, eg, 'main form height', or 'main form windowstate'. I can have user settings in this via 'chris/main form height'. I can then store that setting name as a constant in my application, so its accessible via Intellisense. Doing

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

.. But otherwise, an interesting concept. "The data was generated, and as such there are inconsistencies and subtle problems. Rather than removing them, we decided to leave the contents untouched, and use these issues as data cleaning exercises." Chris On Wed, Dec 19, 2018 at 12:16 PM Shawn W

Re: [sqlite] Sample Employee database ported to SQLite from MySQL

...) But I digress.. Chris On Wed, Dec 19, 2018 at 9:05 AM Arun - Siara Logics (cc) wrote: > This project (https://github.com/siara-cc/employee_db) hosts the Sqlite3 > db file ported from mysql test_db found at > https://github.com/datacharmer/test_db. It can be used to

Re: [sqlite] HELP!

> it is almost guaranteed to corrupt the database file if more than one connection tries to access it at the same time. I understand the risks and reasons, but have had numerous databases on our Windows network accessed by 20+ users throughout the day without issue. Thanks, Chris On Sun,

Re: [sqlite] about upsert feature.

I wonder if this should be considered a bug, or if should be better documented? On Thu, Nov 8, 2018 at 9:57 AM 畑宏和 wrote: > Thanks for your reply! > My script's select-stmt do not include where. > When I add 'where true', syntax error does not occur. > > Thanks! > > 2018年11月7日(水) 19:44、Richard

Re: [sqlite] Displaying row count

> that will display a row number when outputting results? Is this for your schema, or a 'general-could-be-anything' schema? If your own, any reason why you don't use the rowid or _rowid_ columns? They provide a unique reference for each row in a table. Thanks, Chris On Wed, Oct 31, 2

Re: [sqlite] Regarding CoC

10/22/18, Chris Brody wrote: > >> Looks like that happened this morning. > >> https://news.ycombinator.com/item?id=18273530 > > > > I saw it coming, tried to warn you guys in private. > > There is indeed a reactionary hate mob forming on twitter. But most > of

Re: [sqlite] Regarding CoC

I would vote for a major simplification, down to something like "love thy neighbor", "do unto others as ...", or "don't do unto others as ..." For reference: * https://www.simpletoremember.com/jewish/blog/loving-thy-neighbor-judaism/ *

Re: [sqlite] Regarding CoC

> Looks like that happened this morning. > https://news.ycombinator.com/item?id=18273530 I saw it coming, tried to warn you guys in private. ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

It was purely a 'gotcha' that has caught me out before - a journal file lingers and locks the system. On Mon, Oct 15, 2018 at 4:03 AM Rowan Worth wrote: > On Sat, 13 Oct 2018 at 00:21, Chris Locke > wrote: > > > > Database is locked > > > > Close your applicatio

Re: [sqlite] error message: [FireDAC][Phys][SQLite] Database is locked

> Database is locked Close your application. Is there a xxx-journal file in the same directory as the database? (where xxx is the name of the database) Try deleting this file. Thanks, Chris On Fri, Oct 12, 2018 at 4:54 PM Thomas Kurz wrote: > >> Could the problem arise due t

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

Darren Duncan wrote: > On 2018-10-10 10:51 AM, Chris Green wrote: > > Warren Young wrote: > >> Fossil forum email alerts include the full content of the message. > > That's great! Especially if the alert email subject includes the forum > thread > subje

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

o go and get them > >> > >> So do Fossil email alerts. > > > > So there's an unecessary email I've just received telling me to go to the > > forum. > > Fossil forum email alerts include the full content of the message. And can you then si

Re: [sqlite] SQLite mailing list [was: SQLite Windows GUI alternative to Excel?]

Gary R. Schmidt wrote: > On 10/10/2018 22:20, Petite Abeille wrote: > > > [SNIP] > > ( Also, fwiw: please keep the mailing list, it's perfectly functional as > > is. ) > > > Seconded. > > It isn't broken, so please don't try and fi

Re: [sqlite] Persistent snapshots and rollbacks

> Yes, but there are some things I don't like about it -- see my earlier > reply in this thread (to Simon's first message). Gotta say I could not follow what you said in the earlier reply. It would be nice if you could explain in some finer detail. That said, I would personally favor using

Re: [sqlite] Persistent snapshots and rollbacks

> I did now a quick experiment with the sqlite3 command-line, and it seems > that savepoints indeed work exactly what I need *except* for being > non-persistent. Is there some way or trick I could use to make them (or > the "current session") persist? Couldn't

Re: [sqlite] Persistent snapshots and rollbacks

Savepoints ()? On Fri, Oct 5, 2018 at 11:40 AM Daniel Kraft wrote: > > Hi! > > I need the ability to make multiple changes / commits to my SQLite > database but keep snapshots of previous states and potentially roll back > to those states later on. All

Re: [sqlite] A SQL statement reformatter

I found https://github.com/mjibson/sqlfmt through their about page. No license though, just raised https://github.com/mjibson/sqlfmt/issues/33. GitHub fork-me ribbon would also be nice I think. Someone should have make this tool 20-30 years ago! On Fri, Sep 28, 2018 at 10:44 AM Peter da Silva

Re: [sqlite] downloading older versions

From https://www.sqlite.org/chronology.html you should be able to click on the date, then click on the check-in hash number, then click the link after "Downloads:" to download a ZIP, TAR, or SQLAR of the older version. Keep in mind that this gives you a snapshot of the source tree, you would have

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

. On Wed, Sep 5, 2018 at 12:25 PM Chris Locke wrote: > When SQLite creates an empty .db file, which directory is it in? With all > your tweaking, etc, is the new database always in the same directory? > > Thanks, > Chris > > On Wed, Sep 5, 2018 at 3:23 PM Robert Helmick

Re: [sqlite] Error when reading from pre-populated SQLite database in Ionic project

When SQLite creates an empty .db file, which directory is it in? With all your tweaking, etc, is the new database always in the same directory? Thanks, Chris On Wed, Sep 5, 2018 at 3:23 PM Robert Helmick wrote: > I'm receiving an error when I try to read from a pre-populated SQLite > da

Re: [sqlite] sqlite on IBM z/OS Unix

work between stdlib and C programs, also to how sqlite3 database pointers work between sqlite3 library and application code in C.. I hope this is helpful to you and other readers on the list. Please do not hesitate to ask if anything does not sound right or is not clear. Chris https://www.linked

Re: [sqlite] PRAGMA case_sensitive_like

Thanks J - not entirely sure how that's helpful - I know how to call the pragma, but I was enquiring as to whether there was a way of reading a write-only pragma (which sounds nonsense now that I've written that down!!) Thanks, Chris On Thu, Aug 16, 2018 at 3:16 PM J Decker wrote: > ht

[sqlite] PRAGMA case_sensitive_like

While the pragma *case_sensitive_like *can be set, there doesn't seem to be a way to read it. Is there a reason for it being write only? A hacky workaround is to use the SQL, "select 'x' like 'X' ", but is there a better way? ___ sqlite-users mailing

Re: [sqlite] BUG REPORT

> I am using a query to check a date field between a range of dates Can you provide example values of the date in your database? Are you storing the EXACT date (eg, '2018-02-01 12:21'), or just the date? > When running this with the ODBC driver it fails to return all the appropriate record in

Re: [sqlite] Using Chinook

ing to install. Thanks, Chris On Mon, Aug 13, 2018 at 1:15 PM Roger Schlueter wrote: > I am just starting to learn SQLite so I am afraid my questions here will > be quite simple for a (very long?) while compared to those I have been > reading. I'm starting by trying to follow the tut

Re: [sqlite] Using Chinook

When using directories with spaces, its better (or necessary) to include the whole directory in double quotes. Therefore, try entering this: sqlite3 "e:\VB Resources\SQLite\chinook.db" No problems with being a novice - everyone was a novice once. Thanks, Chris On Mon, Aug 13, 2018

Re: [sqlite] Using Chinook

> to include the whole directory Sorry, I meant the whole filename. On Mon, Aug 13, 2018 at 1:28 PM Chris Locke wrote: > When using directories with spaces, its better (or necessary) to include > the whole directory in double quotes. Therefore, try entering this: > sqlite3 &quo

Re: [sqlite] Very, very slow commits - Possibly solved

ht you were simply adding records into the database - I'm failing to grasp how this is slowing down in the new database. Thanks, Chris On Tue, Jul 31, 2018 at 3:30 PM Rob Willett wrote: > Dear all, > > We think we have now found the issue with the slow commits. > > W

Re: [sqlite] Full text serch - Matching all except chosen

apple', 'banana', and 'cabbage', but not 'dog' or 'elephant' - they are greater (alphabetically). Hope this helps. Chris On Tue, Jul 31, 2018 at 9:58 AM Luuk wrote: > On 31-7-2018 10:52, Luuk wrote: > > On 31-7-2018 07:25, paul tracy wrote: > >> Forgive me if this is the wrong

Re: [sqlite] Use with Visual Studio

I use system.data.sqlite.dll (taken from here: https://system.data.sqlite.org/index.html/doc/trunk/www/downloads.wiki) with no problems in both VS 2017 Professional and VS 2017 Community. Thanks, Chris On Mon, Jul 9, 2018 at 2:47 AM Roger Schlueter wrote: > I am considering using the .

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

On Wed, Jun 13, 2018 at 3:00 PM Richard Hipp wrote: > > Cross-posted to the fossil-users mailing list since www.fossil-scm.org +1 > Even so, Discourse does seem like considering. Does anybody else have > any experience with Discourse, good or bad? SQLCipher switched over to Discourse for the

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

On Wed, Jun 13, 2018 at 10:44 AM jungle Boogie wrote: > [...] > http://spamassassin.apache.org/ Maybe just add SpamAssassin to the existing GNU MailMan setup? http://www.jamesh.id.au/articles/mailman-spamassassin/ ___ sqlite-users mailing list

Re: [sqlite] Possible Input Parser Issue Inf How to convert SQL file into database when a column value is Inf?

output of .dump with Inf or -Inf values would be valid input. Chris ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Database is malformed but no further information

-is-malformed-solved/ Chris https://www.linkedin.com/in/chrisbrody/ On Tue, Jun 12, 2018 at 6:21 PM skywind mailing lists wrote: > > Hi, > > when I load my database into sqlite3 and run an integrity check I only get > the error message: Error: database disk image is malformed &

Re: [sqlite] sqlite.org website is now HTTPS-only

http://sqlite.org and https://sqlite.org seem to redirect OK to https://sqlite.org/index.html http://www.sqlite.org and https://www.sqlite.org seem to redirect OK to https://www.sqlite.org/index.html fossil clone https://www.sqlite.org/src sqlite.fossil works for me on my mac (recent version

Re: [sqlite] Filename encoding on Unix platforms

On Tue, Jun 5, 2018 at 2:27 PM, Warren Young wrote: > > On Jun 5, 2018, at 11:39 AM, R Smith wrote: > > > > Any idea what might be the sudden spam activator? I'm using Thunderbird > > client and gmail service. Weird. > > Gmail seems to now consider an origin of mailinglists.sqlite.org to be a

Re: [sqlite] Size of the SQLite library

s place. > > > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Cheers, Chris ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Size of the SQLite library

On Thu, May 31, 2018 at 11:38 AM, Richard Hipp wrote: > [...] > By using multiple SQLITE_OMIT compile-time options to leave out > features, I can get the size down to 308,189 bytes using gcc-7 -Os > -m32. @Richard can you elaborate some more on how you make this kind of a build? I wouldn't mind

Re: [sqlite] Resources for learning SQLite

on. The wrappers are quite basic (no pun intended) so depends on your requirements and development needs.. Thanks, Chris On Thu, Mar 29, 2018 at 6:20 PM, Jay Kreibich <j...@kreibi.ch> wrote: > > > On Mar 29, 2018, at 12:06 PM, Mike Clark <cyberherbal...@gmail.com> >

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

I see - thanks Paul. I misunderstood. Thanks for your detailed explanation. Chris On Wed, Mar 21, 2018 at 9:13 AM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > Actually it is totally different Chris > > > I read that - but my point was more that some pe

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

may not cause issues. Thanks, Chris On Tue, Mar 20, 2018 at 9:45 AM, Paul Sanderson < sandersonforens...@gmail.com> wrote: > I read that - but my point was more that some people seem to think that an > int primary key can be auto incrementing, it can't. > > > SQLite version

Re: [sqlite] How many AUTOINCREMENT tables are in your schema?

0, across approx 20 databases, ranging from small 3 table schemas, to a couple of ERP systems using 120+ tables. Thanks, Chris On Fri, Mar 16, 2018 at 4:09 PM, R Smith <ryansmit...@gmail.com> wrote: > Across 8 production systems and about 120 SQLite DBs for us - Not a single > A

Re: [sqlite] BF Interpreter

"Thats the beauty of it. It doesn't *do* anything." ;) On Thu, Mar 1, 2018 at 6:55 AM, Gary Briggs wrote: > Thanks to the help the other day with the strange concatentation result. > > I was referring to a BF interpreter I was working on, in pure SQLite SQL. > Well,

Re: [sqlite] More sqlite header questions

On Tue, Feb 13, 2018 at 2:03 PM, Simon Slavin wrote: > [...] > There are two possibilities: > > A) The SQLite API was used correctly, including being allowed to close all > files it opened. > B) Any other situation. > > If (A) happened, you can predict things about the

[sqlite] More sqlite header questions

)? On Tue, Feb 13, 2018 at 9:10 AM, Richard Hipp <d...@sqlite.org> wrote: > > On 2/13/18, Chris Brody <chris.br...@gmail.com> wrote: > > I was wondering what would happen if there would be an application crash, > > system crash, or power failure while SQLite is upda

[sqlite] Crash when writing header

I was wondering what would happen if there would be an application crash, system crash, or power failure while SQLite is updating the file header? Did I miss an explanation somewhere? -- From: David Raymond Date: Tue, Feb 6, 2018 at 12:04 PM Subject: Re:

Re: [sqlite] Easiest way to get day of week as a string (not a number)?

presumably that works with the locale setting to give them to you in your own language. -- Chris Green · ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Easiest way to get day of week as a string (not a number)?

x <tam118...@hotmail.com> wrote: > Don’t think you’ll get it any less ugly than > > substr('SunMonTueWedThuFriSat',strftime('%w',Date)*3+1,3); > Yes, thanks, that's where I had got to! :-) -- Chris Green · ___ sqlite-users mailing

[sqlite] Easiest way to get day of week as a string (not a number)?

I want to get Sun, Mon, Tue, Wed etc. from a date, what's the easiest way of doing this in a sqlite select? I guess I can do something (horrible?) with the numeric day of week and substr() but is there not an easier way? -- Chris Green · ___ sqlite

Re: [sqlite] Possible bug when adding "on delete cascade" via DB Browser for SQLite

' the issue using the SQLite command line tool. If that too fails, then the issue should be confirmed here where it will get properly investigated. I know DB Browser for SQLite is still in heavy development, and it does have a number of little quirks like this. ;) Thanks, Chris <https://www.avast.

Re: [sqlite] Is WAL mode more robust against corruption?

On Thu, Dec 28, 2017 at 3:59 PM, Simon Slavin <slav...@bigfraud.org> wrote: > On 28 Dec 2017, at 8:10pm, Chris Brody <chris.br...@gmail.com> wrote: > >> [...] >> But I wondered if WAL may be more robust against possible sqlite >> corruption, in theory or

[sqlite] Is WAL mode more robust against corruption?

corruption, in theory or in practice. Any comments? Thanks and happy 2018! Chris https://www.linkedin.com/in/chrisbrody/ ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Modify the sqlite database with DB Browser to update a new field

but it has a very active support group. Thanks, Chris On 24 Dec 2017 7:17 am, "Keith Medcalf" <kmedc...@dessus.com> wrote: > > This sounds like a "DB Browser" issue, whatever a "DB Browser" is. You > should direct questions about how to enter SQL c

Re: [sqlite] Importing Text to Create a Table

What operating system are you using, and what software are you using to do the import? What specificially are you trying to import? If you perform a sequence of 'insert' statements, then that can be time consuming - its better to incorporate them into one 'transaction' - sqlite bundles the

[sqlite] Missing data table

backed up the database, but I'd like to prevent this from happening in the first place, or at least be able to undo it and get the table back. If there's anything I've left out please ask, and many thanks for any help with this. Chris ___ sqlite-use

Re: [sqlite] Error code 14 for the Journal file

The 'scary bit' here is the device not functioning. > A device attached to the system is not functioning. Is the database/journal on the same/local PC or on a network? Chris On Mon, Dec 4, 2017 at 4:27 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 4 Dec 2017

Re: [sqlite] Article on AUTOINC vs. UUIDs

> if your systems are set up in a sane way, the MAC address alone would prevent collisions, no? > And on the same system, are collisions even possible? Google says "In the case of standard version 1 and 2 UUIDsusing unique MAC addresses from network cards, collisions can occur only when an

Re: [sqlite] how into insert row into middle of table with integer primary key

column to link to another table. Create the database properly and use the columns properly. Thanks, Chris On 22 Nov 2017 6:40 am, "Shane Dev" <devshan...@gmail.com> wrote: Hi Igor, Homework exercise? No, this is purely a hobby project in my free time. My goal is see how muc

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

ourney. As previously 'warned', it is a Windows only environment, so if you have Linux friends, they won't be able to view your creations. However, building applications is quick and easy but immensely rewarding. I love my job. Thanks, Chris On Wed, Nov 15, 2017 at 8:16 PM, Balaji Rama

Re: [sqlite] BedrockDB interview on Floss Weekly

Thanks Ryan - a handy summary. Food for thought. Thanks, Chris On Fri, Oct 27, 2017 at 11:57 AM, R Smith <rsm...@rsweb.co.za> wrote: > > On 2017/10/27 11:52 AM, Bart Smissaert wrote: > >> Is this BedrockDB something that could be used to connect to a server and

Re: [sqlite] BedrockDB interview on Floss Weekly

it could be set up, it also looks like there aren't .Net drivers or 'wrappers' for it? Thanks, Chris On Thu, Oct 26, 2017 at 7:15 AM, David Barrett <dbarr...@expensify.com> wrote: > I'm glad you liked it! I'd be happy to answer any questions you have about > http://BedrockDB.com, our u

Re: [sqlite] Fwd: Problem on Windows 10 machines

ausing a blue-screen, but is just failing. > Could the problem be that SQLite is installed by MS already on those machines? SQLite is a third party product, and would not be pre-installed by Microsoft. Thanks, Chris On Thu, Sep 7, 2017 at 8:45 AM, Bart Smissaert <bart.smissa...@gmail

  1   2   3   4   5   >