Re: [sqlite] Database size

This is so good to hear! The advances in database theory and practice have put the old ideas to rest. Hooray for today! Ted On 09/01/2012 07:08 PM, Richard Hipp wrote: > On Sat, Sep 1, 2012 at 6:34 PM, Ted Rolle, Jr. <ster...@gmail.com> wrote: > >> Back in the olden

Re: [sqlite] Database size

companies got through it with few problems --- a tribute to the programming staff. Ted On 09/01/2012 07:51 PM, Simon Slavin wrote: > On 1 Sep 2012, at 11:34pm, "Ted Rolle, Jr." <ster...@gmail.com> wrote: > >> Back in the olden days we predicted a database's storage to be

Re: [sqlite] How do you load a ".csv" and skip the first line?

Text editor to remove the offending line(s)? This way you can see what you've removed. The other solutions (tail, less, more) would work better for LARGE files. ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Database size

Back in the olden days we predicted a database's storage to be about 5 times the size of the data. By 'olden' I mean IBM's IMS, VSAM, DB2. ..., 70s, 80s. I hope this is still not the case... Ted ___ sqlite-users mailing list sqlite-users@sqlite.org

Re: [sqlite] UPSERT again

the record if it didn't exist then I could use the trigger you have suggested. two triggers? one AFTER INSERT, one AFTER UPDATE. jr. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] primary key autoincrement updation problem in case refereced

plain text attachment) examples of your shell use and the relevant C code, plus a few sample records, I'd be happy to look it over (later tonight, off to work soon). jr. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/c

Re: [sqlite] primary key autoincrement updation problem in case refereced

can see there's no problem with the table design (created them here). jr. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] primary key autoincrement updation problem in case refereced

On 11/01/12 06:05, Durga D wrote: if I understand correctly: first you created tables t1 and t2, then you say 'create if not exist' -- but they already do. instead of (re-)creating tables t1 and t2, ALTER TABLE statements can be used to modify the existing. jr

Re: [sqlite] How to sort within a text field

prdtype may have up to 8 sub prdtype, i.e. '2|21|27|28|33|40|43|55' I really appreciate your help on this if you could. Thank's. Rick a small Tcl script perhaps? then, for each record, it'd be simply a split, lsort, join sequence. jr. ___ sqlite

Re: [sqlite] Aggregating Forex data

I will spend a couple of days learning about sqlite > optimization. > since much of that time will be spent in the strftime() calls and calculations, how about adding a lookup table with pre-computed date/times? jr. ___ sqlite-users mailing list

Re: [sqlite] adding fdopen to VFS?

On Mon, Feb 28, 2011 at 15:12, Richard Hipp <d...@sqlite.org> wrote: > On Mon, Feb 28, 2011 at 8:36 AM, Paweł Hajdan, Jr. < > phajdan...@chromium.org> wrote: > >> >> I remember a part of earlier discussion that there is a problem with >> journal and possib

Re: [sqlite] adding fdopen to VFS?

2011/2/28 Richard Hipp <d...@sqlite.org> > On Mon, Feb 28, 2011 at 7:39 AM, Paweł Hajdan, Jr. < > phajdan...@chromium.org> wrote: > >> I'd like to add an equivalent of fdopen to the sqlite's VFS ( >> http://www.sqlite.org/c3ref/vfs.html). The signature wo

[sqlite] adding fdopen to VFS?

I'd like to add an equivalent of fdopen to the sqlite's VFS ( http://www.sqlite.org/c3ref/vfs.html). The signature would similar to this: int (*xFdOpen)(sqlite3_vfs*, int fd, sqlite3_file*, int flags, int *pOutFlags); This would be needed to cleanly implement fd-passing in Chromium, from the

Re: [sqlite] Involving in sqlite development

On Fri, Oct 8, 2010 at 15:28, sjtirtha wrote: > 1. setup an development environment for SQLite (I'm using Ubuntu) >Do you have any preference which editor or IDE should I use? It's very easy. Download the sources, compile the "standard" way (./configure; make). Any

Re: [sqlite] upstreaming Chromium patches for file handle passing support

On Tue, Aug 31, 2010 at 19:51, Richard Hipp wrote: > My suggestion is that you make a copy of the os_unix.c source file (call it > chromium_vfs.c or anything else that you like) and apply your edits to that > copy. FYI, that's what finally happened.

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

rst place. > They are untested and unsupported. We'll get around to patching them, if > you insist, but right now we are busy trying to 3.7.1 out the door. > > On Wed, Aug 18, 2010 at 4:41 PM, Paweł Hajdan, Jr. > <phajdan...@chromium.org>wrote: > > > On Tue,

Re: [sqlite] upstreaming Chromium patches for file handle passing support

On Tue, Aug 31, 2010 at 10:51, Richard Hipp wrote: > My suggestion is that you make a copy of the os_unix.c source file (call it > chromium_vfs.c or anything else that you like) and apply your edits to that > copy. Since you started with an exact copy of the original os_unix.c

Re: [sqlite] Which data type is better for date?

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 And in addition, the TZ offset might be handy to convert to UTC. Local time is locally determined while UTC is constant, and other local offsets can be applied to display time in local terms. For example, EST is UTC-5; EDT is UTC-4; PST is UTC-8; PDT

Re: [sqlite] upstreaming Chromium patches for file handle passing support

2010/8/31 Richard Hipp > os_unix.c is very unlikely to change in ways that you care about. I think the biggest concern is just copying that code, please see http://groups.google.com/a/chromium.org/group/chromium-dev/browse_thread/thread/7f8e9bf0f034322f/b26e422d4aa711c7. I

Re: [sqlite] upstreaming Chromium patches for file handle passing support

On Tue, Aug 31, 2010 at 10:51, Richard Hipp wrote: > My suggestion is that you make a copy of the os_unix.c source file (call it > chromium_vfs.c or anything else that you like) and apply your edits to that > copy. Since you started with an exact copy of the original os_unix.c

Re: [sqlite] upstreaming Chromium patches for file handle passing support

On Fri, Aug 27, 2010 at 18:27, Paweł Hajdan, Jr. <phajdan...@chromium.org>wrote: > > >> At start-time, simply call sqlite3_vfs_register() to register your >> customized VFS with SQLite. >> > > That's what our implementation effectively does, see > http:

Re: [sqlite] upstreaming Chromium patches for file handle passing support

On Fri, Aug 27, 2010 at 04:58, Richard Hipp wrote: > The VFS interface is published, stable, and documented. I think the VFS is > the interface you should be using. > > You do not have to patch os_unix.c. Leave it unchanged. Sounds good to me. This is one of my goals - to

[sqlite] upstreaming Chromium patches for file handle passing support

Please take a look at chromium_sqlite3 functions in http://src.chromium.org/viewvc/chrome/trunk/src/third_party/sqlite/src/src/os_unix.c?view=markup They are needed because in Chrome the browser process will pass a file descriptor to the child renderer process instead of a file path. Here's the

Re: [sqlite] Length=10

So simple. I never thought of using the command-line sqlite3... > in the sqlite3 shell, set output mode to file, and then select as > above. All your select output will go to your file. > > ___ sqlite-users mailing list sqlite-users@sqlite.org

[sqlite] Length=10

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I have a table of UPCs with lengths varying from 6 to 12. I'd like to print those with length=10 to a file for printing. SELECT * FROM UPCs WHERE LENGTH(UPC)=10; works just fine. But when I export the table I naturally get the whole table. Would

[sqlite] SQLite fails to build for WinCE 4.2 (WM 2003)

.), it should be checked Why 2 conditions ("0x420" and "420")? In eVC 4.0 variable $(CEVER) (_WIN32_WCE get value from it) has "decimal form", but in VS2005 and later this variable has "hex. form". --- WBR, Aleksandr Jr. ___

Re: [sqlite] errors running test suite (couldn't execute "testfixture")

After updating the tests run fine now. Thanks for the quick update! By the way, I usually avoid having "." in the PATH for security reasons. On Fri, Aug 20, 2010 at 05:30, Dan Kennedy <danielk1...@gmail.com> wrote: > > On Aug 20, 2010, at 6:07 AM, Paweł Hajdan, Jr.

[sqlite] errors running test suite (couldn't execute "testfixture")

I updated to latest fossil version, ran make distclean, ./configure, make, make test and got this: avtrans-9.19.4-5116... Ok avtrans-9.19.5-5116... Ok avtrans-9.20.1-5640... Ok avtrans-9.20.2-5640... Ok avtrans-10.1... Ok avtrans.test-closeallfiles... Ok avtrans.test-sharedcachesetting... Ok

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

On Tue, Aug 10, 2010 at 13:16, Paweł Hajdan, Jr. <phajdan...@chromium.org>wrote: > Now, how about fts1 and fts2? The original chromium patch is at > http://codereview.chromium.org/174387 . Could you take a look and suggest > a way to upstream those fixes to SQLite? > Pi

Re: [sqlite] [PATCH] cache preloading

, Aug 11, 2010 at 23:23, Damian Pietras <da...@daper.net> wrote: > On Tue, Aug 10, 2010 at 05:46:26PM -0700, Paweł Hajdan, Jr. wrote: > > So this is another chromium patch I'd like to submit: > > > http://src.chromium.org/viewvc/chrome/trunk/src/third_party/sqlite/preload-ca

[sqlite] [PATCH] cache preloading

So this is another chromium patch I'd like to submit: http://src.chromium.org/viewvc/chrome/trunk/src/third_party/sqlite/preload-cache.patch?revision=26596=markup I'm not the author of that one, but the main idea seems to be that with preloading we get better performance with many scenarios

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

does it need to be changed to > > > > > >ch = (ch>='A' && ch<='Z') ? ch - 'A' + 'a' : ch; > > > > > > There is only one such instance of code remaining in FTS3 (at > > > fts3_tokenizer1.c:196) but I want to understand what the issue is

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

On Wed, Aug 4, 2010 at 15:23, Paweł Hajdan, Jr. <phajdan...@chromium.org>wrote: > I'm attaching a suggested patch to fix locale-unsafe usage of tolower in > FTS code. The goal is to make Chromium closer to the upstream, so if you > have a better solution, that's great. Oh, I ha

Re: [sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

On Wed, Aug 4, 2010 at 16:30, Scott Hess wrote: > You should probably pull the current SQLite code and make sure the > patch even applies, and if not, check to make sure that the problem > hasn't already been fixed. ext/fts3 should no longer have the flaw in > question, as

[sqlite] [PATCH] Fix locale-unsafe usage of tolower (upstreaming Chromium change)

I'm attaching a suggested patch to fix locale-unsafe usage of tolower in FTS code. The goal is to make Chromium closer to the upstream, so if you have a better solution, that's great. This is upstreaming a Chromium patch

Re: [sqlite] [PATCH] Verify number of arguments in icuRegexpFunc

On Thu, Jul 29, 2010 at 22:53, Dan Kennedy wrote: > Looks like it was fixed for 3.6.22: > > http://www.sqlite.org/src/ci/c34cf23efb Thank you. I have changed chromium's copy of sqlite to contain the above version of the code, so we're closer to upstream now.

[sqlite] [PATCH] Verify number of arguments in icuRegexpFunc

I'm attaching a suggested patch to verify number of arguments in icuRegexpFunc. Please review it. This is upstreaming of http://src.chromium.org/viewvc/chrome/trunk/src/third_party/sqlite/icu-regexp.patch?revision=34807=markup According to the commit message from above, it has been reported

Re: [sqlite] problems with running test suite

On Thu, Jul 29, 2010 at 16:34, Richard Hipp wrote: > The test suite now requires Tcl 8.5. You appear to be running Tcl 8.4. > That's right. After upgrading from tcl8.4 to tcl8.5 the tests run just fine. Thanks! ___ sqlite-users

[sqlite] problems with running test suite

I'm planning to contribute some patches (upstreaming patches Chromium project applies to its local copy of sqlite). I've checked out the fossil repository, configured and compiled sqlite, and tried running "make test" (I didn't make any changes). I'm pasting below the test result and some fossil

[sqlite] Removing duplicate entries from a database

I just found an elegant query to identify duplicate entries in a table. It is from Microsoft. http://support.microsoft.com/kb/139444 Here's the information: create table t1(col1 int, col2 int, col3 char(50)) insert into t1 values (1, 1, 'data value one') insert into t1 values (1, 1, 'data

Re: [sqlite] Numbers as CHARs.

On Tue, 6 Jul 2010 17:13:44 -0500 P Kishor wrote: > I have no idea why you would say that. It works just fine. > > sqlite> CREATE TABLE UPCs (UPC TEXT); > sqlite> INSERT INTO UPCs VALUES ('043000205563'); > sqlite> SELECT * FROM UPCs; > UPC > > 043000205563 >

Re: [sqlite] Numbers as CHARs.

On Tue, 6 Jul 2010 17:13:44 -0500 P Kishor wrote: > sqlite> CREATE TABLE UPCs (UPC TEXT); > sqlite> INSERT INTO UPCs VALUES ('043000205563'); > sqlite> SELECT * FROM UPCs; > UPC > > 043000205563 > sqlite> I did as you said with sqlite and it worked perfectly.

[sqlite] Numbers as CHARs.

I, (or more to the point, SQLite) can't seem to retain leading zeros on numbers. The receiving field is defined as CHAR; I'm using the SQLite Manager in Firefox. I've also tried sqlite3 from the command line. Here's a typical (and minimal) statement: UPDATE UPCs SET UPC=043000205563; UPDATE UPCs

Re: [sqlite] Oracle joins the SQLite Consortium

On Fri, 25 Jun 2010 01:46:08 +0100 Simon Slavin <slav...@bigfraud.org> wrote: > > On 24 Jun 2010, at 10:38pm, Ted Rolle, Jr. wrote: > > > I can't see anything good coming out of this if there are lawyers > > involved. > > Big North American companies like O

Re: [sqlite] Oracle joins the SQLite Consortium

I can't see anything good coming out of this if there are lawyers involved. -- __ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world!

Re: [sqlite] Why is there no test suite for ''make check' ?

Does the TEA tarball have the tests? -- __ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world! 8164062862089986280348253421170679 http://pi314.at PI VOBISCUM!

Re: [sqlite] UTC/GMT conversion back and forth

On Fri, 28 May 2010 20:12:54 +0300 Andrejs Igumenovs wrote: Finally! A question that I can answer. For all practical (and most impractical) (Drum roll) UTC = GMT, or alternatively, GMT = UTC UTC is Coordinated Universal Time, which one would think would be

Re: [sqlite] Leading zeros disappear

Thanks to all who replied! Single quotes? How simple...I used double quotes... Ted -- __ 3.14159265358979323846264338327950 Let the spirit of pi 2884197169399375105820974944592307 spread all over the world!

[sqlite] Leading zeros disappear

I'm entering UPCs. 0071318119 becomes 71318119. This is not good, or expected, for that matter . The column is specified as TEXT. I thought that TEXT values went in 'as entered'. After reading the docs, Section 2.0: "If numerical data is inserted into a column with TEXT affinity it is converted

Re: [sqlite] .importing file into a BLOB

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Wed, 09 Dec 2009 11:48:31 -0800 Roger Binns wrote: > http://catb.org/~esr/faqs/smart-questions.html What wasn't clear? I apologize for any murkiness. My understanding is that a BLOB takes any piece of data and stores it

[sqlite] NULL vs ''

When I .import a file into a table, || results in a value of '' for the data item. How can I get a NULL value stored? This also happens when the item is at the end (EOL) of the row. Currently, I: UPDATE table SET value=NULL where value=''; Ted ---

Re: [sqlite] Putting images into SQLite.

On Sun, 6 Dec 2009 17:57:06 -0800 Stephan Wehner wrote: Base64? Then just add it with an .import statement? I thought about that with MIME encoding. Ted --- 3.14159265358979323846264338327950 Let the

[sqlite] Putting images into SQLite.

>From what I read, it is necessary to have a programmatic interface to put images into a database. True? --- 3.14159265358979323846264338327950 Let the spirit of pi spread 2884197169399375105820974944592307 all around the world!

[sqlite] It's done, except for this nit:

I need for computed total price to display with leading and trailing zeros. E.g. 1 -> 1.00 2.5 -> 2.50 .9 -> 0.90 The extended price is computed with this statement: round(purchase.qty*inventory.price/100.0,2) Ted

[sqlite] SQLite data types.

I'm laboring under a false impression. I thought that the SQLite data types were limited to text, integer, float, and something else. On the SQLite site there's Currency, date-time with and without timestamps. Where can I find a listing of these? Ted

Re: [sqlite] Looking for a cryptographic library

John Raymond Hurst wrote: > Search for the following on the web: > BeeCrypt, CryptoPP, OpenSSL > Ray Hurst > > [EMAIL PROTECTED] wrote: >> Hi all: >> I'm writing an application that uses SQLite to store user's data, and >> need a library to

Re: [sqlite] Help speeding up very slow query

D. Richard Hipp wrote: What's the schema? Do you have an index? CREATE TABLE Master ( playerID text, managerID text, hofID text, birthYear integer, birthMonth integer, birthDay integer, birthCountry text, birthState text, birthCity text, deathYear integer, deathMonth integer, deathDay integer,

[sqlite] Help speeding up very slow query

Hi, First let me say that I am new to sqlite. My situation is this, I have two tables in an sqlite 3.0.8 database. One table (Master) is a list of biographical data about baseball players: firstname, lastname, hometown, etc. The second table (Batting) is comprised of each players stats: hits,

[sqlite] Wich compiler to use in Windows

, what you suggest ? Thanks Rubens Jr.

[sqlite] One or many db and vacuum (Improving speed)

of S1 will be one right after another and sqlite has not to scan all 400 Megabytes) Obs: using version 3.03 Thanks Rubens Jr.

[sqlite] Sqlite 3.0.2 with LCC for Windows

' ? Thanks Rubens Jr.

Re: [sqlite] execution order of Update

> > No, all consts or data from other column are put into expression before > execution. Read > http://www.sqlite.org/lang.html#update > > I did not notice the " ...All expressions are evaluated before any assignments are made.." Thanks Again ! Rubens Jr. --- Outg

Re: [sqlite] execution order of Update

f1 will receive value of f2 (now with xxx) !! Rubens Jr. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.682 / Virus Database: 444 - Release Date: 11/05/2004 - T

[sqlite] execution order of Update

not shure that this may be done with only one sql command ... Thanks Rubens Jr. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.682 / Virus Database: 444 - Release Date: 11/05/2004

[sqlite] 1/2 OFF : Leave a few records on a table

Hi ! Sorry by Off, but I do not know how to do this with SQlite ! Supose : Create Table test (ID integer primary key, log text); After inserting some records how can I maintain only the last 10 records ? Note that ID may have 'roles', that some records may be deleted. Thanks Rubens Jr

[sqlite] use sqlite_compile vs sqlite_exec

with comandos like Insert, delete and update (that returns no rows) I must call sqlite_step or is not necessary ? sqlite_compile (db, "insert into ..."); sqlite_finalize (db, NULL); will work ? Thanks Rubens Jr. - To unsu

Re: [sqlite] Diferent behavior in 2.8.12 and 2.8.13

t; > Ok, Thanks a LOT !! I read the OnLine Doc many times and I do not notice this : "SQLite expects the SQL string that you pass in to be unchanged until the SQL has finished executing." If this is in OnLine Doc I suggest it must be In a m

Re: [sqlite] Diferent behavior in 2.8.12 and 2.8.13

since internal variables may have moved > around and are not being scribbled upon. > > Derrell > I used the same data in both version ... Thanks Rubens Jr. - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]

[sqlite] Diferent behavior in 2.8.12 and 2.8.13

sible to use same buffer in sqlite_exec and the callback function ? If so I have to rewrite / review all of my application :( Someone had notice that ? Some workaround (and still use 2.8.13) ? Thanks Rubens Jr. - To unsubscribe,

[sqlite] Change the behave of LIKE

in their languages this helps A LOT !! Someone alredy did this ? Change UpperToLower will resolve this problem ? Thanks Rubens Jr. -- Mensagens enviadas estão livres de vírus. Verificado por AVG Anti-Vírus (http://www.grisoft.com). Version: 7.0.224 / Virus Database: 261.9.8 - Release Date: 24

RE: [sqlite] Can't get to work w/ PHP

or directory make: *** [sqlite.lo] Error 1 `make' failed The entire make output is below. I appreciate any advice you can give. Am also posting this the php list to see if they have any ideas. Thanks! JR [EMAIL PROTECTED] html]# pear download http://pecl.php.net/get/SQLite-1.0.tgz File SQLite-1.0

RE: [sqlite] Can't get to work w/ PHP

. JR './configure' '--prefix=/usr' '--exec-prefix=/usr' '--bindir=/usr/bin' '--sbindir=/usr/sbin' '--sysconfdir=/etc' '--datadir=/usr/share' '--include' 'dir=/usr/include' '--libdir=/usr/lib' '--libexecdir=/usr/libexec' '--localstatedir=/var' '--sharedstatedir=/usr/com' '--mandir=/usr/share/man