Re: [sqlite] Fwd: inserting new data only

he "VALUE" column, it will fail. -- People in sleeping bags are the soft tacos of the bear world. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Shell commands for controlling headers

ibility with something in the past. -- People in sleeping bags are the soft tacos of the bear world. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Opposite of SQLite

s it on, I go into the library and read a good book -- Groucho Marx Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Should SQLite distinguish between +0.0 and -0.0 on output?

is. > > -- > D. Richard Hipp > d...@sqlite.org -- This is clearly another case of too many mad scientists, and not enough hunchbacks. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

On Thu, Aug 30, 2018 at 11:12 AM Don V Nielsen wrote: > "Having successfully ported sqlite to z/OS Unix as a 32 bit app" > > Totally Awesome! Do I have a solution? No. But I'll bet John McKown will. I > believe he is a guru with the mainframe. > I don't know about b

Re: [sqlite] Insert with an '

Very good point. I think that everyone should do it that way. It is a bit more work, but is vastly superior. On Mon, Jun 11, 2018, 03:23 Olivier Mascia wrote: > > Le 11 juin 2018 à 10:07, Peter Nacken a écrit : > > > > I try to insert email addresses into a table and get an error with >

[sqlite] "missing" sqlite3 invocation option?

database.db3 sqlite> .read FILENAME sqlite> .quit This would mirror the PostgreSQL supplied psql command. For whatever that is worth. -- We all have skeletons in our closet. Mine are so old, they have osteoporosis. Maranatha! <>< John McKown __

Re: [sqlite] Window functions?

i/Abstraction_(computer_science)> > > > > -- > Sent from: http://sqlite.1065341.n5.nabble.com/ > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo

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

her link them into > your app, or build them as a library that the sqlite3 tool can load. > > —Jens > ___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-

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

___ > sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>

Re: [sqlite] UTF8 and NUL

h the command "type x.txt" where "x.txt" contained "abc~def" (where ~ is standing in for 0x1a) resulted in my seeing "abc". But "notepad x.txt" shows "abc def". So I guess it depends on how old the Windows

Re: [sqlite] C++ compiler

ng, but I can't prove it. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Move to Github!!?

t and​ Lotus 1-2-3 back in the MS-DOS days. But today's users want a word process which is WYSIWYG and want their spreadsheets to create pretty *π* charts. > > --- > The fact that there's a Highway to Hell but only a Stairway to Heaven says > a lot about anticipated traffic v

Re: [sqlite] Move to Github!!?

writing a "one off" for every SCM that they want to support. IMO, that would be very short sighted. ​ -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown ___ sqlite-users ma

Re: [sqlite] values ?

On Tue, Dec 12, 2017 at 12:34 PM, Mark Wagner wrote: > My reading of https://sqlite.org/syntax/select-core.html makes me think > that I should be able to issue something like values('foo'); and get a row > with a single column whose value is 'foo'. But I get a syntax error. > >

Re: [sqlite] random value get re-generated too often in SQLite

00 24Halt 0 0 000 920225462863128947|920225462863128947 -723158119245037038|-723158119245037038 ​Hope this at least explains what is happening. I don't know if this is "correct" or not.​ -- I have a theory that it's impossible to pr

Re: [sqlite] Emulate right-join

> sqlite-users mailing list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

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

Hauppauge, NY 11788 > 631-272-5947 / william.dr...@l3t.com > -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

[sqlite] make install tries to update /usr/share/tcl8.6 regardless of --prefix= value

portions into, perhaps: $PWD/bld/tcl8.6/sqlite3 I don't know if the action that I saw is intentional or not. -- I have a theory that it's impossible to prove anything, but I can't prove it. Maranatha! <>< John McKown ___ sqlite-users mailing list sq

Re: [sqlite] Wanting to return REAL as formatted TEXT

t some breadcrumbs to point > me in the correct direction. > > regards, Robert > > -- *L'Shanah Tovah Tikatevu* Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Is there a performance difference between COUNT(*) and COUNT(name)

list > sqlite-users@mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Caution! The OP is an hyperpolysyllabicsesquipedalianist and this email may cause stress to those with hippopotomonstrosesquipedaliophobia. Maranatha! <>< John McKown

Re: [sqlite] Getting number of rows with NULL

> insert into x values('2017-09-04', 4); sqlite> select count(*) from x; 5 sqlite> select count(*) from x where a is NULL; 2 sqlite> select count(*) from x where a is NOT NULL; 3 sqlite> ​ -- Caution! The OP is an hyperpolysyllabicsesquipedalianist and this email

Re: [sqlite] My 1st C++ SQLite3 program

> > -- > ArbolOne.ca > Using Fire Fox and Thunderbird. > ArbolOne is composed of students and volunteers dedicated to providing > free services to charitable organizations. > ArbolOne on Java Development in progress [ í ] > > __

Re: [sqlite] [OT] UTF8-BOM and text encoding detection (was: UTF8-BOM not disregarded in CSV import)

i/Byte_addressing), there was at least one machine (Honeywell) which had a 36 bit word which was divided into 9 bit "bytes" (i.e. an address pointed to a 9 bit "byte").​ -- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] [OT] UTF8-BOM and text encoding detection (was: UTF8-BOM not disregarded in CSV import)

on. https://www.ibm.com/developerworks/community/blogs/e0c474f8-3aad-4f01-8bca-f2c12b576ac9/entry/IBM_zEnterprise_redundant_array_of_independent_memory_subsystem ? -- Veni, Vidi, VISA: I came, I saw, I did a little shopping. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 3.19.3 README.md Doc bug

gt;# above creates directory ./sqlite x>mkdir bld # make directory ./bld x>cd bld x/bld>../sqlite/configure x/bld> # up to directory x, then down in into directory sqlite & run configure residing there x/bld> # results of configure are put in th

Re: [sqlite] feature req: PLEASE why the heck COMMENT fields are not supporte in years!!

erican government went to IBM to come up with a data encryption standard and they came up with ... Student: EBCDIC! Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] thousand separator for printing large numbers

ne user at a time" to "multiple concurrent users". Just my opinion, of course. Others may reasonably disagree. -- Our calculus classes are an integral part of your education. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Query truncating String column at 255 chars long

be more "straight forward" as it is normally programmed). -- There’s no obfuscated Perl contest because it’s pointless. —Jeff Polk Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] SQLite Query truncating String column at 255 chars long

1112 sqlite> select length(testtext) from testit; 401 sqlite> ​ -- There’s no obfuscated Perl contest because it’s pointless. —Jeff Polk Maranatha! <>< John McKown ___ sqli

Re: [sqlite] [OT] mySQL ORDER BY clause in Views

Loved that explanation. I could easily understand it. On Jan 19, 2017 17:14, "James K. Lowden" wrote: > On Wed, 18 Jan 2017 23:36:14 + > Peter Haworth wrote: > > > if I include a WHERE claus, the view's ORDER BY clause is ignored and > > the rows

Re: [sqlite] locating a minimum in SQLite 2

from info where price=(select min(price) from info) limit 1; 1|a sqlite> ​ -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Datatype for prices (1,500)

Point. https://en.wikipedia.org/wiki/Decimal_floating_point > > Thanks, > Chris > -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.o

Re: [sqlite] .mode column .width .separator

ppears, to me, to be a rather simple change in shell.c. > dvn > > -- Heisenberg may have been here. Unicode: http://xkcd.com/1726/ Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] AS being optional

sqlite-users > -- Klein bottle for rent -- inquire within. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] 64-bit SQLite3.exe

Michael.j.Falconer. > -- Klein bottle for rent -- inquire within. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Missing source code in 3.14 release

ll fossil checkout version-3.14.0 It is not in the "trunk" branch right now. And it appears to be available on this page: http://sqlite.org/download.html ​ -- Klein bottle for rent -- inquire within. Maranatha! <>< John McKown ___ s

Re: [sqlite] Correct, best, or generally accepted database structure for groups of things

because they're sure that something won't be right. Optimistic people check once, trust in Solis-de to keep the ship safe, then blow everyone up." "I think you're mistaking the word optimistic for inept." "They've got a similar ring to my ear." From "Star Nomad&qu

Re: [sqlite] Trouble coding conditional UNIQUE

;I think you're mistaking the word optimistic for inept." "They've got a similar ring to my ear." From "Star Nomad" by Lindsay Buroker: Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] I solved the problem with gridview and database

quot;undeliver" an already delivered mass mailing. Can't be done.​ -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown ___ sqlite-users mailing list sqlite-users@mailinglists.sqlit

[sqlite] SQL Help: Finding case insensitive matches

; efficiently? > ?how about: SELECT group_concat(user,"|") FROM os_users GROUP BY upper(user) HAVING count(*) > 1 ?? > > Thanks, --DD > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

[sqlite] Illegal SQL not rejected

t; > P.S.: This is a rhetorical question, BTW. > > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

[sqlite] Illegal SQL not rejected

On Fri, Apr 29, 2016 at 12:41 PM, Igor Korot wrote: > Hi, > > On Fri, Apr 29, 2016 at 1:28 PM, John McKown > wrote: > > On Fri, Apr 29, 2016 at 12:00 PM, Jann Roder > > wrote: > > > >> Hi, > >> It seems like a too obvious omission to not be

[sqlite] Illegal SQL not rejected

SUM(A). > > Jann > -- The unfacts, did we have them, are too imprecisely few to warrant our certitude. Maranatha! <>< John McKown

[sqlite] Primary key values can be NULL

ogrammer. ?But this last is how I think of ?using SQLite. I use for permanent storage, in preference to reading regular file and putting the data into something like a Java Hashmap. > > > Cheers, > Ryan > -- "He must have a Teflon brain -- nothing sticks to it" Phyllis Diller Maranatha! <>< John McKown

[sqlite] Primary key values can be NULL

application will not know of it and thus not use it. > As I see it, it is as with partial indexes. That is a big change (I think), > but it did not break backward compatibility. > > -- "He must have a Teflon brain -- nothing sticks to it" Phyllis Diller Maranatha! <>< John McKown

[sqlite] Article about pointer abuse in SQLite

so the program wouldn't fit into? memory. And, the ever popular: END OF FILE ON UNIT 05 AT RUN TIME -- How many surrealists does it take to screw in a lightbulb? One to hold the giraffe and one to fill the bathtub with brightly colored power tools. Maranatha! <>< John McKown

[sqlite] attach db limit

ling list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- A fail-safe circuit will destroy others. -- Klipstein Maranatha! <>< John McKown

[sqlite] EBCDIC tester needed

o two values('two'); sqlite> select * from one; 1 sqlite> select * from two ...> ; two sqlite> insert into one values('ugly'); sqlite> select * from one; 1 ugly sqlite> .quit ~/projects/sqlite-test$ exit logout Script done on Mon 08 Feb 2016 03:07:41 PM CST ===? -- The man has the intellect of a lobotomized turtle. Maranatha! <>< John McKown

[sqlite] Efficient relational SELECT

The condition of any backup is unknown until a restore is attempted. He's about as useful as a wax frying pan. Maranatha! <>< John McKown

[sqlite] Running Sqlite under Linux Terminal Server

where I am." Computer Science is the only discipline in which we view adding a new wing to a building as being maintenance -- Jim Horning Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. He's about as useful as a wax frying pan. Maranatha! <>< John McKown

[sqlite] Function patternCompare() not EBCDIC friendly

as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] whish list for 2016

. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] whish list for 2016

l a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] whish list for 2016

On Thu, Dec 24, 2015 at 10:14 AM, Simon Slavin wrote: > > On 24 Dec 2015, at 3:12pm, John McKown > wrote: > > > ?I'm curious as to why. Doing so would, most likely, require rewriting > the > > entire table. If you want a SELECT * to get the columns in a particular &g

[sqlite] whish list for 2016

n which we view adding a new wing to a building as being maintenance -- Jim Horning Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Problem with accumulating decimal values

chrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] "Shipping a New Mindset" - SQLite in Windows 10

until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] A little light reading

On Sun, Nov 8, 2015 at 10:36 AM, Simon Slavin wrote: > > On 8 Nov 2015, at 4:11pm, John McKown > wrote: > > > I'm not a developer. So I guess that it's my ignorance as to why a > program > > would be confused by the string value of "null" or any variant th

[sqlite] A little light reading

I'm not a developer. So I guess that it's my ignorance as to why a program would be confused by the string value of "null" or any variant thereof. I do understand looking for a string of length 0. If I were to want a special name for Some purpose, I'd likely use xyzzy. I thought of plugh as well,

[sqlite] Simple Math Question

ile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Simple Math Question

p: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Using CTE with INSERT

AS (SELECT 1) INSERT INTO t(x) SELECT * FROM p; sqlite> select * from t; 1 sqlite> ? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax fry

[sqlite] Order with another sequence

He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] How do i submit a bug?

- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] get the data anyway no matter what the entry of the second table is existing or not

th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Handling the whole select query from an index

On Thu, Sep 17, 2015 at 9:41 AM, R.Smith wrote: > > > On 2015-09-17 02:22 PM, Richard Hipp wrote: > >> On 9/17/15, John McKown wrote: >> >>> Well, this may be a heretical answer. >>> >> Yes, it is. >> >> ?? ?? > (11) This forum

[sqlite] Handling the whole select query from an index

a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Handling the whole select query from an index

ally curious about it.? > > Rob. > > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Handling the whole select query from an index

ers mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] I don't understand how to use NOT EXISTS

Very good! I'll keep that one. On Tue, Sep 15, 2015 at 1:26 PM, Igor Tandetnik wrote: > On 9/15/2015 2:04 PM, John McKown wrote: > >> sqlite> select count(a) from x; >> > > Better still: > > select exists (select 1 from x); > > The difference is tha

[sqlite] I don't understand how to use NOT EXISTS

sum() it does not produce > the same result to total() when no lines satisfy the WHERE clause. Sorting > out the possibilities is more complicated. > > Simon. > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] sqlite3 file as database

gt; Cheers -- Tim > > ___ > sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Feedback request: JSON support in SQLite

e. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] BEGINNER - Transactions in shell script

e, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Does PRIMARY KEY imply NOT NULL?

restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] WHERE clause not working in combination with random()

lman/listinfo/sqlite-users > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] order by not working in combination with random()

are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] order by not working in combination with random()

sts.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Is this a bug ? How to rename a table and all dependencies ?

w to update all the dependencies. To implement, send all the required commands to the sqlite3 API. ? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Getting row number in a sorted list.

I am not sure that it is guaranteed to work on all past and future versions of SQLite. It depends on the non-standard ROWID facility in SQLite. Perhaps Dr. Hipp can address this last issue. ? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] order by not working in combination with random()

On Aug 17, 2015 21:53, "Yuriy M. Kaminskiy" wrote: > > ... and then, at some wonderful moment, sqlite devs will implement query > flattening for CTE (like they did for subquery above), and you'll be in > square one. > > (Or, maybe, they will finally implement "common subexpression > elimination",

[sqlite] Enhance the SELECT statement?

n Monday".? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Enhance the SELECT statement?

ad_ to do a SELECT startement, not an INSERT INTO. I finally had some time to test and this works. ? > > Cheers ! > > Mon Aug 17 2015 17:44:58 CEST from "John McKown" > > Subject: [sqlite] Enhance the SELECT > >statement? > > > > I use both SQLite3

[sqlite] Enhance the SELECT statement?

BY random_number; -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

ful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Lawyers, encryption, and RC4

a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] I don't know how to cast ‘const unsigned char*’ to a 'const std::string'

chrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

dition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Read data from database slow the first time but then very fast thereafter. How can I improve the speed for the first time read?

Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Thanks SQLite

restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Thanks SQLite

On Fri, Jul 31, 2015 at 7:40 AM, Simon Slavin wrote: > > On 31 Jul 2015, at 1:26pm, John McKown > wrote: > > > WITH summary AS > > ( SELECT var, count(var) as total FROM table GROUP BY key ) > > SELECT a.var, 100*a.var/b.total as percentage FROM table AS a > &

[sqlite] Thanks SQLite

t;$2" #name of output CSV file shift key="$3" #name of the key field shift varlist="$@" #names of other variables to output, in order # Put in some percentages. sqlite3 << John McKown

[sqlite] CSV excel import

> sqlite-users mailing list > sqlite-users at mailinglists.sqlite.org > http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] CSV excel import

ot;line1a",line1b,line1c "line2""a",line2b,'line2b' joarmc at mckown5 2015-07-30T14:43:25 ~/junk ? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] CSV excel import

sider that a "bug fix" request.? -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] CSV excel import

own until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Query takes 8 seconds on one machine but I abort after 40+ minutes on other machines

, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] Query takes 8 seconds on one machine but I abort after 40+ minutes on other machines

ers > -- Schrodinger's backup: The condition of any backup is unknown until a restore is attempted. Yoda of Borg, we are. Futile, resistance is, yes. Assimilated, you will be. He's about as useful as a wax frying pan. 10 to the 12th power microphones = 1 Megaphone Maranatha! <>< John McKown

[sqlite] convert a PostgreSQL to sqlite

the sqlite3 command. Or not. Just "for fun" (no profit), I did the commands: $ pg_dump -C -c -n racf -f racf.info -O --column-inserts --quote-all-identifiers joarmc $ sqlite racf.db2 < John McKown

  1   2   >