Re: [sqlite] Unexplained table bloat

Hi, I checked the download mentioned in the original email. Not sure if the table changed since the previous posts. It seems LUTFullString has 3 BLOB rows, but LENGTH treats them as strings. I'm in Melbourne, Oz, so I added the UTC datetime. regs, Kev kevin@KCYDell:~$ cd /mnt/KCY/KCYDocs

Re: [sqlite] Things you shouldn't assume when you store names

And "full legal name" How about my dad, whose full name was Dr. John Michael Patrick Dennis Emmet O'Gorman, PhD. How many rules does that break? I've fought many companies over that apostrophe in my life. Governments tend to throw it away, but it's on my old passport and birth certificate.

Re: [sqlite] Date time input

On Tue, Oct 8, 2019 at 2:40 PM James K. Lowden wrote: > On Tue, 8 Oct 2019 09:06:24 -0700 > Jens Alfke wrote: > > > I think the idea of a semi-official ?SQLite++? has been floated here > > before > > OK, but it needs a better name. -- > SQLiteXTD -- -- --Ö¿Ö-- K e V

[sqlite] sqlite3 doesn't build with -DSQLITE_ENABLE_DBPAGE_VTAB with bitbake

I need sqlite3 to be built with -DSQLITE_ENABLE_DBPAGE_VTAB so that I can use the ".recover" command. The ".dbinfo" command doesn't work either. I add -DSQLITE_ENABLE_DBPAGE_VTAB to the sqlite recipe CFLAGS in various ways but I never get sqlite3 built with the option. Example error: the

Re: [sqlite] [EXTERNAL] Re: Documentation update request

ipp) > > -Ursprüngliche Nachricht- > Von: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > Im Auftrag von Kevin Benson > Gesendet: Donnerstag, 15. August 2019 20:40 > An: SQLite mailing list > Betreff: [EXTERNAL] Re: [sqlite] Documentation updat

Re: [sqlite] Documentation update request

On Thu, Aug 15, 2019 at 2:33 PM Jose Isaias Cabrera wrote: > Richard Hipp, on Thursday, August 15, 2019 01:32 PM, wrote... > > > > On 8/15/19, Simon Slavin, on > > > On 15 Aug 2019, at 5:20pm, Richard Damon, on > > > > > >> You under quote, the faq says it “can not be changed (except under > >

Re: [sqlite] Correct use of sqlite3_vtab_nochange/sqlite3_value_nochange

> On 13 Aug 2019, at 14:08, Richard Hipp wrote: > > I think that is correct. > Great, thanks. > But it never occurred to me that somebody might do this on the PRIMARY > KEY. I don't see any reason why it wouldn't work, though. I have a c++ interface built on top of the virtual table api

Re: [sqlite] [EXTERNAL] Correct use of sqlite3_vtab_nochange/sqlite3_value_nochange

> On 12 Aug 2019, at 07:53, Hick Gunter wrote: > > You did not state your argc and argv[0] values, Apologies, it is a 2 column table. Full details are: - argc is 4 - argv[0] is the value of the primary key for the row I want to update. - argv[1] is SQLITE_NULL, but as described,

[sqlite] Correct use of sqlite3_vtab_nochange/sqlite3_value_nochange

Hi, I have a without rowid virtual table with an implementation of xColumn that begins with if(sqlite3_vtab_nochange(ctx)) return SQLITE_OK; If I try to perform an update on this table that doesn't involve a primary key change, then my understanding from the documentation is that xUpdate will

Re: [sqlite] SQLITE_LOCKED means "database table is locked"?

On Wed, Jun 19, 2019 at 12:12 PM Carsten Müncheberg < carsten.muencheb...@native-instruments.de> wrote: > Am 19.06.2019 um 16:47 schrieb Igor Tandetnik: > > On 6/19/2019 10:39 AM, Carsten Müncheberg wrote: > >> Is there really something like a table lock? > > > > Yes there is:

[sqlite] Optimising multiple group by clauses

Hi, I am trying to find the best way to write a query that has two levels of group by where the outer group by columns are a subset of the inner group by columns. In my example below I want to do an aggregation grouping by per, prod, and mar, then I want aggregate the results of this

Re: [sqlite] picking random subset of rows

r mapping product to a random number and order by that in the subquery instead. I would be interested if there is a solution for sqlite 3.22 (i.e. no window functions) where it can be done so that the query gives a possibly different result each time it is executed. Thanks, Kevin __

[sqlite] picking random subset of rows

seeing similar results. Thanks, Kevin --- create table if not exists test_productattribs (product text primary key, attr, val

[sqlite] SEE

Any articles out there giving some hint how we use the SEE version of SQLite we compiled with our C# program that references System.Data.SQLite? Thanks in advance! Kevin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

Re: [sqlite] Regarding CoC

Richard, thank you for your further explanation of your team's Code of Conduct. After a bit of research on the Internet, everything makes sense. Well done. regs, Kev ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org

[sqlite] weekday time modifier

Hi, Not sure if this is me misreading it, but the description of the weekday modifier in the documentation seems a bit ambiguous. It says: > The "weekday" modifier advances the date forward to the next date where the > weekday number is N. Sunday is 0, Monday is 1, and so forth. It is not

Re: [sqlite] SQLiteJava

[Bcc'ing the openjfx-dev list] I see no indication that there is anything relating to JavaFX in your question, so there seems to be no need to include the openjfx-dev list. -- Kevin On 9/6/2018 3:21 PM, AmnoJeeuw wrote: I have a database table named company that looks like this: snapshot2

Re: [sqlite] Back on-line. Was: Mailing list shutting down...

On Thu, Jun 14, 2018 at 8:58 AM, Richard Hipp wrote: > ... > > So there you have it: If you want to harass someone by sending them > thousands of subscription confirmations, there is now a website to > assist you. Do we need any further evidence that the heart of man is > deceitful above

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

On Sun, Jun 10, 2018 at 12:45 PM skywind mailing lists < mailingli...@skywind.eu> wrote: > Hi, > > but to which directory should I set it? There is no general tmp directory > accessible. > > Regards, > Hartwig > > > Am 2018-06-10 um 02:30 schrieb Bob Friesenhahn < > bfrie...@simple.dallas.tx.us>:

Re: [sqlite] ROWID....

On Sat, Jun 9, 2018 at 7:03 AM Luuk wrote: > > In the docs (https://www.sqlite.org/autoinc.html) it says: > In SQLite, table rows normally have a 64-bit signed integer ROWID > > > Question: > Why it this a signed integer, and not an

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

On Sun, May 13, 2018 at 9:01 AM, Dennis Clarke <dcla...@blastwave.org> wrote: > On 05/13/2018 11:57 AM, Kevin O'Gorman wrote: > >> The arguments here are simplified >> > > > Will you stop top posting please? > > I am trying to follow along here about some x8

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

The arguments here are simplified, and assume some things that may or may not be true. The server I keep in my garage has 16 real cores, 32 threads. More importantly, it uses DDR4 memory which I think means there are 4 channels to memory which can be used in parallel -- perhaps not on exactly

Re: [sqlite] Multi threaded readers on memory sqlite cannot scale

It's not clear to me why reads must be serialized at all. Maybe this could be re-thought? Maybe there should be a way to tell SQLite that a certain DB or table is to be read-only and unserialized? On Sun, May 13, 2018 at 7:15 AM, Keith Medcalf wrote: > > Say Hi to Gene! >

Re: [sqlite] Broken DB?

Oops. Wrong list. Should go to a Django group. I noticed as soon as I sent this. Please ignore. On Fri, Apr 27, 2018 at 2:58 PM, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > I've got a working site, but I made a copy of the database in order to do > some development work

[sqlite] Broken DB?

])) I'm suspecting a problem has crept into my Log table, because it works fine if I change Log on the second line of handle() to any of the other tables. If it runs as shown here however, I get kevin@camelot-x:/build/comprosloco$ manage oiltest Traceback (most recent call last): File "./m

Re: [sqlite] Simple read-only program very slow

order for the entire btree structures to be cached in > >RAM -- you > >> probably want to make it as big as you can. > >> > >> --- > >> The fact that there's a Highway to Hell but only a Stairway to > >Heaven says > >> a lot about anticipated traffic volume. &g

Re: [sqlite] Simple read-only program very slow

On Sun, Nov 26, 2017 at 12:02 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Kevin O'Gorman wrote: > > I wrote a super simple program to the read the file and count how many > > records are already there. I got impatient waiting for it so I killed > > the process

Re: [sqlite] Simple read-only program very slow

On Sun, Nov 26, 2017 at 1:39 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 26 Nov 2017, at 3:13am, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > > > I've got a database of some 100 million records, and a file of just over > > 300 thousand t

[sqlite] Simple read-only program very slow

The code makes to changes to the database at all. Why does commit() make a difference? What else should I learn from this? The field being used for the lookup has an index. ++ kevin Code follows: #!/usr/bin/env python3 """Count the number of records that represent rows in

Re: [sqlite] Seg fault with core dump. How to explore?

On Sat, Sep 30, 2017 at 11:41 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > Kevin O'Gorman wrote: > > my latest trial run ended with a segmentation fault > > Really a segmentation fault? What is the error message? > What such things always say "seg

Re: [sqlite] Seg fault with core dump. How to explore?

From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On > Behalf Of Kevin O'Gorman > Sent: Saturday, September 30, 2017 3:55 PM > To: sqlite-users <sqlite-users@mailinglists.sqlite.org> > Subject: [sqlite] Seg fault with core dump. How to explore? > &g

Re: [sqlite] Seg fault with core dump. How to explore?

tables does contain primary keys (integer autoincrement primary key) of the other. I'm a little leery of switching on account of one crash, as it may weel be an over-reaction. On Sat, Sep 30, 2017 at 4:30 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > > On 30 Sep 2017, at

[sqlite] Seg fault with core dump. How to explore?

to explore a running Python program. The project is a hobby, so there's nothing proprietary, and I can post any information that would help. ++ kevin -- word of the year: *kakistocracy* ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http

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

I wonder if the answer at this following inquiry is suggesting that your last posted results are unremarkable: https://stackoverflow.com/questions/11872539/windbg-crash-dump-analysis and that suggested alternative approach may be more helpful than WinDbg ? -- -- -- " --Ö¿Ö--

Re: [sqlite] Linux top command and sqlite

:38 AM, Richard Hipp <d...@sqlite.org> wrote: > On 2/21/17, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > I'm not at all sure this is the right place to ask, but as it only comes > up > > when I'm running one of > > my sqlite jobs, I thought I'd start h

[sqlite] Linux top command and sqlite

I'm not at all sure this is the right place to ask, but as it only comes up when I'm running one of my sqlite jobs, I thought I'd start here. I'm running Python 3.5 scripts in Linux 16.04.1 using the sqlite3 package. Machine is Core i5, 32GB RAM. Some of my stuff takes a while to run, and I

Re: [sqlite] Problem compiling 3.17.0 in MSVS 12

On Tue, Feb 14, 2017 at 7:56 PM, Bart Smissaert wrote: > I had to install WinZip though and at the first unzip I got directly to the > files whereas now I had a .tar file first and had to unzip that. > Following on from David Empson's post... the WinZip docs show an

[sqlite] SQLAR, slight mod for symlink recursion & a high volume test

Hi, Richard, just to let you know, I have continued to use sqlar rather than tar.gz for my personal use. I found a problem with recursive symlinks. For example, I have a copy of sqliteodbc-0.9994.tar.gz which has a symlink source -> . Note, the Gnome Archive Manager has a nice arrow icon, but

Re: [sqlite] Retrieve INTEGER PRIMARY KEY

On Tue, Feb 7, 2017 at 4:11 PM, Clyde Eisenbeis wrote: > int iKeyID = (int)sqliteCmd.ExecuteScalar(); > I believe the type of last_insert_rowid() is *always* INT64 -- -- -- --Ö¿Ö-- K e V i N ___

Re: [sqlite] "DISTINCT" makes a query take 37 times as long

e above script, I think I'm done with this. I have a solution that works for me, and I'd just as soon get back to my real task. I just wanted to give feedback in case it would be useful. That's how i say thanks for a really useful product. Thanks. Mr. Hipp, and anyone else that has contributed to

Re: [sqlite] "DISTINCT" makes a query take 37 times as long

On Wed, Feb 1, 2017 at 6:35 PM, Richard Hipp <d...@sqlite.org> wrote: > On 2/1/17, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > I have a database of positions and moves in a strategic game, and I'm > > searching for unsolved positions that have been connected t

[sqlite] "DISTINCT" makes a query take 37 times as long

I have a database of positions and moves in a strategic game, and I'm searching for unsolved positions that have been connected to an immediate ancestor. I'm using Python 3.5.2, and the code looks like #!/usr/bin/env python3 """Output positions that are reachable but unsolved at census 18 or

Re: [sqlite] possible integrity problem

On Sat, Jan 14, 2017 at 5:04 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 15 Jan 2017, at 1:01am, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > > Update: the integrity check said "ok" after about 1/2 hour. > > the record count now takes

Re: [sqlite] possible integrity problem

Update: the integrity check said "ok" after about 1/2 hour. the record count now takes about 4 seconds -- maybe I remembered wrong and it always took this long, but I wasn't stopping it until it had hung for several minutes. Color me baffled. On Sat, Jan 14, 2017 at 4:49 PM, Kevi

[sqlite] possible integrity problem

I've got a database that has acted strangely from time to time. Or actually a series of them, since I erase and build from scratch sometimes, as I'm just starting this project. Anyway, the latest is that the DB is about 11 GB. It's pretty simple, just 2 main tables and maybe 5 indexes, no

Re: [sqlite] INSERT is corrupting a database

On Fri, Jan 13, 2017 at 3:34 AM, Clemens Ladisch <clem...@ladisch.de> wrote: > Kevin O'Gorman wrote: > > On Tue, Jan 10, 2017 at 11:29 PM, Clemens Ladisch <clem...@ladisch.de> > wrote: > >> Kevin O'Gorman wrote: > >>> If I go on to the second table

Re: [sqlite] INSERT is corrupting a database

On Tue, Jan 10, 2017 at 7:52 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 11 Jan 2017, at 3:28am, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > > I have a modest amount of data that I'm loading into an SQLite database > for > > the first time.

Re: [sqlite] INSERT is corrupting a database

On Tue, Jan 10, 2017 at 11:29 PM, Clemens Ladisch <clem...@ladisch.de> wrote: > Kevin O'Gorman wrote: > > If I go on to the second table, it appears to finish normally, but when I > > try to look at the database with sqlite3, a command-line tool for > > inter

[sqlite] INSERT is corrupting a database

This is a problem I don't quite know how to report in a way that will be useful. I'm using Python 3.5 and its builtin sqlite package. I have a modest amount of data that I'm loading into an SQLite database for the first time. For the moment it contains just two tables and a few indices, nothing

Re: [sqlite] new user seeking help

On Thu, Jan 5, 2017 at 1:26 PM, Chen, Hui wrote: > Hi there, > > I just recently started integrating System.Data.SQLite.dll into my > project, I started with a very simple winform application. > > I have a very simple method to create a connection, txtSqliteFile is >

Re: [sqlite] Out of date online documents

On Sat, Dec 31, 2016 at 4:04 PM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 31 Dec 2016, at 8:59pm, Kevin Benson <kevin.m.ben...@gmail.com> wrote: > > > > The Home page Search *DOES* result in linking to > > "other dot commands" but *NOT* >

Re: [sqlite] Out of date online documents

On Sat, Dec 31, 2016 at 3:20 PM, Paul Lambert wrote: > Web search. In fact I cannot find any link on the sqlite.org page that > links to the (dot) functions, alias special functions. > > The Home page Search *DOES* result in linking to "other dot commands" but *NOT* "special

Re: [sqlite] Weird chars inserted

"rb"); int ch = fgetc (pinfile);  /* changed from char to int to allow >127 & UTF */ Also, I use .mode csv and then a spreadsheet quite a lot. Note, at the end, I added typeof( ) - and most were BLOBs and a couple as TEXT. kevin@kevin-Aspire-V5-571G:~$ sqlite3 dir_md5sum

[sqlite] Weird chars inserted

Hi Martin, I had a go using a terminal session, with default encoding UTF-8. Try using the hex( ) and unicode( ) functions to check what is actually stored in the sqlite table. I put a couple of rows at the end of an existing simple table kevin@kevin-Aspire-V5-571G:~$ sqlite3 /home/kevin

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

t know how to bifurcate between the power supply and something on the mobo USB interface. And it hasn't happened again. On Wed, Dec 7, 2016 at 5:18 PM, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > Good feedback. I haven't done a memory check on that machine in a > while..

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

ity checked memory, just an undetected memory fault > which will cause random AHTBL. > > > -Original Message- > > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > > On Behalf Of Kevin O'Gorman > > Sent: Sunday, 4 December, 2016 09:21

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

don't know enough about mobos and USB to diagnose whether the problem was on the mobo or the power supply. Creepty. I had to do a hard reset to get thing going again, and it's been running fine for a day now. On Mon, Nov 21, 2016 at 9:51 AM, Kevin O'Gorman <kevinogorm...@gmail.com> wrote:

[sqlite] Speeding up a query

my query, especially the first time through. I can/should update the SQLite version, but I don't think that's the problem. Thanks for any help! Kevin ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

On Mon, Nov 21, 2016 at 9:41 AM, Roger Binns <rog...@rogerbinns.com> wrote: > On 19/11/16 08:08, Kevin O'Gorman wrote: > > System with problems: Running Xubuntu Linux 16.04.1, Python 3.5.2. > [...] > > System without this problem: Running Ubuntu Linux 14.04.5, Python

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

On Fri, Nov 18, 2016 at 10:18 AM, James K. Lowden <jklow...@schemamania.org> wrote: > On Fri, 18 Nov 2016 08:55:11 -0800 > "Kevin O'Gorman" <kevinogorm...@gmail.com> wrote: > > > All of the python code is a single thread. The closest I come > >

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

Ran Memtest86+ 5.01, two complete passes, with no errors. On Sat, Nov 19, 2016 at 8:19 AM, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > > On Sat, Nov 19, 2016 at 8:11 AM, Simon Slavin <slav...@bigfraud.org> > wrote: > >> >> On 19 Nov 2016

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

On Sat, Nov 19, 2016 at 8:11 AM, Simon Slavin <slav...@bigfraud.org> wrote: > > On 19 Nov 2016, at 4:08pm, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > > I have two different machines running this stuff. Only one is having the > > seg faults, but they ar

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

On Fri, Nov 18, 2016 at 3:19 PM, James K. Lowden wrote: > On Fri, 18 Nov 2016 10:56:37 -0800 > Roger Binns wrote: > > > Popen calls fork (it seems like you are doing Unix/Mac, not Windows). > > fork() duplicates the process including all open

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

On Fri, Nov 18, 2016 at 8:38 AM, Roger Binns <rog...@rogerbinns.com> wrote: > On 17/11/16 19:14, Kevin O'Gorman wrote: > > SO: I need help bifurcating this problem. For instance, how can I tell > if > > the fault lies in SQLite, or in python? Or even in the hardware, g

Re: [sqlite] I keep getting seg faults building my database using python sqlite3

On Fri, Nov 18, 2016 at 3:11 AM, Simon Slavin wrote: > Forgot to say ... > > Most of these problems result from attempting to reuse memory you've > already released. Even if the error is happening inside a SQLite routine, > it will be because you passed it a pointer to an

[sqlite] I keep getting seg faults building my database using python sqlite3

I ran this thing 3 times with identical inputs, it is deterministic, but it failed after 66, 128 and 96 minutes respectively. Each run started with no database at all, and gets a single input from which the rest is calculated. The calculations are cached (in flat files), so and it never got to

[sqlite] Accessing sqlite3Apis pointer when loading sqlite3 dll/so.

missing anything, i.e. does this work. 2) Will it be guaranteed in the future that the sqlite3_api_routines pointer will be passed to the extensions loaded by sqlite3_auto_extension. 3) Is there a better way to do this as it feels a little hacky. Thanks, Kevin

Re: [sqlite] Import 5000 xml files in a sqlite database file

Bob, my name is Kevin Youren, and I did this task about 4 years ago in Python 3, by parsing XML files and creating CSV files. The CSV files were used to load Sqlite tables, MS Xcel spreadsheets and IBM mainframe DB2 tables. The XML data was mildly complex, large, and error prone. If you have

Re: [sqlite] Is there a best practice for breaking up a large update?

te access to the database or if > it is just read-only. If the others only need read-only, let them access a > copy of the database while you make your changes in another copy, then just > swap the databases when done. -- Darren Duncan > > > On 2016-10-15 1:21 PM, Kevin O

[sqlite] Is there a best practice for breaking up a large update?

I'm new to this, and working in Python's sqlite3. So be patient, and don't expect me to know too much. This is also a personal hobby, so there's nobody else for me to ask. I've got a database of a some tens of millions of positions in a board game. It may be over a billion before I'm done

Re: [sqlite] enabling FK in VisualStudio

On Sat, Sep 24, 2016 at 5:14 AM, denis wrote: > Hello all, I want enabling foreign key in the file app.config of visual > studio 2015 is-it possible? if yes, what is the string? > I tested connectionString = "data source=d:\db.sqlite; ForeignKeys=true;" > but the FK does not

Re: [sqlite] Consistency, rollback and such

. They're quick, but conflicts are fairly likely, so it's probably the right solution. On Tue, Sep 20, 2016 at 3:02 PM, Richard Hipp <d...@sqlite.org> wrote: > On 9/20/16, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > Surely, Mr. Hipp is an authority, but I'm slightly puz

Re: [sqlite] Consistency, rollback and such

habit of always doing isolation_level = None, and doing everything > explicitly, but as long as you know what's going on then you're good. > > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Kevin O'Gorman &g

Re: [sqlite] Consistency, rollback and such

, Sep 20, 2016 at 10:09 AM, Richard Hipp <d...@sqlite.org> wrote: > On 9/20/16, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > c.execuite("BEGIN TRANSACTION IMMEDIATE") > > > > and is IMMEDIATE the right thing, or do I need EXCLUSIVE. > > IMMED

[sqlite] Consistency, rollback and such

I think I understand the basics of SQL and ACID properties, but I'm new to SQLite and not really experienced in any of these. So I'm having some trouble figuring out the detailed consequences of IMMEDIATE, EXCLUSIVE and DEFERRED and the autocommit mode of python's sqlite3. I expect my

Re: [sqlite] Clarification on "No Isolation On Same Db Connection"

It seems to me that the simplest, most portable approach for this sort of thing would to be having the SELECT create a temporary table of the desired actions, and not apply them until after the select has concluded. This would work in any database -- it does not depend on precise semantics of

Re: [sqlite] Setting temp location with Python

On Wed, Aug 10, 2016 at 6:50 AM, Jonathan Moules < jonathan-li...@lightpear.com> wrote: > Hi List, >I'm using Python's sqlite3 library to access a SQLite db. I'd like to > set the location for the temporary databases in a platform agnostic fashion > (*nix or Windows). > > This page -

Re: [sqlite] Bug in CREATE INDEX

On Sun, Aug 7, 2016 at 11:11 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 08/08/2016 02:03 AM, Dominique Pellé wrote: > >> Kevin O'Gorman wrote: >> >> CREATE INDEX has two problems: >>> 1) poor default location of temporary storage. >>> 2

Re: [sqlite] Bug in CREATE INDEX

On Mon, Aug 8, 2016 at 2:41 AM, Philip Newton <philip.new...@pobox.com> wrote: > On 7 August 2016 at 22:37, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > > I use the LTS (long-term support) version of Ubuntu, and like not having > to > > keep up with all

Re: [sqlite] Bug in CREATE INDEX

On Sun, Aug 7, 2016 at 12:03 PM, Dominique Pellé <dominique.pe...@gmail.com> wrote: > Kevin O'Gorman wrote: > > > CREATE INDEX has two problems: > > 1) poor default location of temporary storage. > > 2) gets wedged on very large indexes. > > > > I'm usi

Re: [sqlite] Bug in CREATE INDEX

it and I thought it was possible sort was being used under the covers. It's not, but it all worked out okay. Does anybody know where the actual defaults and controlling environment variables are documented, by operating system? Or are they? On Fri, Aug 5, 2016 at 12:36 PM, Kevin O'Gorman <kevinog

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

On Sat, Aug 6, 2016 at 2:49 PM, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > On Sat, Aug 6, 2016 at 2:09 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > >> On 08/06/2016 09:52 AM, Kevin O'Gorman wrote: >> >>> On Fri, Aug 5, 2016 at 2:03 PM, Dan Ke

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

On Sat, Aug 6, 2016 at 2:09 AM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 08/06/2016 09:52 AM, Kevin O'Gorman wrote: > >> On Fri, Aug 5, 2016 at 2:03 PM, Dan Kennedy <danielk1...@gmail.com> >> wrote: >> >> On 08/06/2016 03:28 AM, Kevin O'Gorman wro

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

On Fri, Aug 5, 2016 at 2:03 PM, Dan Kennedy <danielk1...@gmail.com> wrote: > On 08/06/2016 03:28 AM, Kevin O'Gorman wrote: > >> On Fri, Aug 5, 2016 at 1:08 PM, David Raymond <david.raym...@tomtom.com> >> wrote: >> >> .. >> >> Apart from

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

On Fri, Aug 5, 2016 at 3:03 PM, Darren Duncan wrote: > On 2016-08-04 7:27 AM, Jim Callahan wrote: > >> Steps >> Agree with Darren Duncan and Dr. Hipp you may want to have at least 3 >> separate steps >> (each step should be a separate transaction): >> >> 1. Simple load

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

led poorly. > > -Original Message- > From: sqlite-users [mailto:sqlite-users-boun...@mailinglists.sqlite.org] > On Behalf Of Kevin O'Gorman > Sent: Friday, August 05, 2016 3:41 PM > To: SQLite mailing list > Subject: Re: [sqlite] newbie has waited days for a DB build to co

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

On Fri, Aug 5, 2016 at 12:30 PM, Igor Korot <ikoro...@gmail.com> wrote: > Hi, Kevin, > > On Fri, Aug 5, 2016 at 3:18 PM, Kevin O'Gorman <kevinogorm...@gmail.com> > wrote: > > Okay, I followed some of the advice y'all gave and got some results. > > > &g

[sqlite] Bug in CREATE INDEX

CREATE INDEX has two problems: 1) poor default location of temporary storage. 2) gets wedged on very large indexes. I'm using the sqlite that came with Xubuntu 14.04, I think it's version 3.8.2. I created a table, and used .import to populate it with records, about 1.4 billion of them. The

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

nually. This is a deal-killer. So the questions are: Where do bug reports go? I seem to be running 3.8.2; is this fixed in any later version? On Thu, Aug 4, 2016 at 9:27 AM, Kevin O'Gorman <kevinogorm...@gmail.com> wrote: > The metric for feasability is coding ease, not runtime.

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

sweb.co.za> wrote: > > > On 2016/08/04 5:56 PM, Kevin O'Gorman wrote: > >> On Thu, Aug 4, 2016 at 8:29 AM, Dominique Devienne <ddevie...@gmail.com> >> wrote: >> >> >> It's even less dense than that. Each character has only 3 possible >> v

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

On Thu, Aug 4, 2016 at 8:29 AM, Dominique Devienne <ddevie...@gmail.com> wrote: > On Thu, Aug 4, 2016 at 5:05 PM, Kevin O'Gorman <kevinogorm...@gmail.com> > wrote: > > > 3. Positions are 64 bytes always, so your size guesses are right. They > are >

Re: [sqlite] newbie has waited days for a DB build to complete. what's up with this.

hen may want to load a fixed > number of rows into separate tables (per Darren Duncan) and then combine > using an APPEND > or a UNION query (doing so before steps 2 and 3). > > HTH > > Jim Callahan > Data Scientist > Orlando, FL > > > > > On Wed, Aug 3,

[sqlite] newbie has waited days for a DB build to complete. what's up with this.

I'm working on a hobby project, but the data has gotten a bit out of hand. I thought I'd put it in a real database rather than flat ASCII files. I've got a problem set of about 1 billion game positions and 187GB to work on (no, I won't have to solve them all) that took about 4 hours for a

Re: [sqlite] Conversion failure

-- -- -- --Ô¿Ô-- K e V i N On Thu, Jun 23, 2016 at 10:38 AM, Igor Korot wrote: > Hi, Clemens, > > On Thu, Jun 23, 2016 at 10:33 AM, Clemens Ladisch > wrote: > > Igor Korot wrote: > >> I am trying to find out why the following

[sqlite] Note, using SQLAR compared to TGZ archive

d overwrite the modified files in the SQLAR archive. regs, Kev On 3/29/16, Kevin wrote: > Richard, > > Just a note of thanks for the SQLAR tool. I'm glad you find it useful. Really is it just a proof-of-concept. If you are a C programmer and would like to try to enhance it, write to

[sqlite] Note, using SQLAR compared to TGZ archive

Richard, Just a note of thanks for the SQLAR tool. I am using it to store SQLite ".dump" output, which is of text data. The SQLAR file is 125.2M bytes. The corresponding tgz file is 125.1M bytes. The raw text content is in 20 files, totally 746.9M bytes. regards, Kev Youren

[sqlite] Order with another sequence

> On Fri, Oct 9, 2015 at 5:08 AM, Cecil Westerhof > wrote: > > > When I use ORDER BY an ? comes after a z. Is it possible to make an ? > come > > after a z? > > > > If it is important I am using SQLite 3.8.6 and Python 3.4.1. > Perhaps you might garner some insight from looking at other's code?

[sqlite] DbFunctions.TruncateTime

On Sun, Aug 23, 2015 at 10:53 PM, Joe Mistachkin wrote: > > The LINQ provider for System.Data.SQLite does not provide this function > directly; however, it may be possible to use one of the core date-time > related SQL functions to do it? > > https://www.sqlite.org/lang_datefunc.html >

[sqlite] : it seems to be only orber by and group

On Sat, Aug 22, 2015 > afriendandmore wrote: > > The table shall be ordered according to A. (Order by A) > > But if C ist true and to the value B1 in this Record, there exists > another Record with B2 and B2 = B1, then B1 should be ordered in the row > above B2. If the B1 and B2, to which you

[sqlite] Database sybchronisation

On Thu, Aug 13, 2015 at 4:05 AM, Chris Parsonson wrote: > So can someone give me a working example of two database ATTACHed and a > simple select using columns from a table in each database C:\SQLite3>sqlite3 C:\SQLite3\UpdateWolfpro.db3 SQLite version 3.8.11.1 2015-07-29 20:00:57 Enter

  1   2   3   4   >