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] 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] 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] 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