Hi Peter,
Regarding:
"Selectivity is known -- since it's a primary key, which is unique -- it will
be 1. Cardinality can vary."
I wonder if you're referring to the definition of *cardinality* as used in
mathematics
http://en.wikipedia.org/wiki/Cardinality
In mathematics,
Regarding win/dos COPY command and /b option:
Thanks for correcting me, Michael. I somehow thought that NUL being the target
would introduce some sort of "text affinity" but it's good to know the truth
instead.
___
sqlite-users mailing list
Regarding:
Also...try doing a "copy my.db nul:" to get it cached once before you use
it.
Am I right in thinking he may want to include the "/b" (binary) option so that
the copy doesn't stop at the first nul byte?
copy /b my.db nul
___
Regarding: "My question is, what command do I use in script-A to invoke
script-C, script-B, etc?
Is it the same ".read" command? "
I believe it does work that way. What did you get when you tried it?
___
sqlite-users mailing list
Griggs, Donald wrote:
> Is the percentage of the final rowcount really a criterion?
The answer to that, according to my brief exploration, is somewhere between
"yes" and "very much yes", depending on various factors.
Thanks, Eric. I guess I was wondering if
Hi Roberto,
Re: Please find a test database in the attachment.
I don't think attachments are permitted on the mailing list messages.
If it's only ten rows, perhaps just using the command line utility to perform a
.dump
Command and pasting the text into a new message would do the trick.
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of John Drescher
Sent: Tuesday, July 13, 2010 12:37 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Sqlite Insert Speed Optimization
> I also wrap my
I just tried
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Black, Michael (IS)
Sent: Monday, May 24, 2010 2:37 PM
From: sqlite-users-boun...@sqlite.org on behalf of Art
Sent: Mon
Regarding:
select * from table1 where field1='x' or field2='y'
Hi, Ray,
I believe you sent two messages -- the first with "OR" and the second with
"AND".
Since your subject consistently says "OR" and your last email says "AND" I'll
assume you meant "AND".
Sqlite using a maximum of
Would this query help determine if any extraneous characters present?
SELECT * FROM MyTable
WHERE LENGTH(resourceType) <> 3
AND resourceType LIKE 'PSM' ;
___
sqlite-users mailing list
sqlite-users@sqlite.org
Ecforu,
Re: What's the diff?
In sqlite, LIKE without a "%" (percent-sign ) would be a case-insensitive
search, whereas == would be case-sensitive.
sqlite> select 'cat' like 'CAT';
1
sqlite> select 'cat' == 'CAT';
0
___
sqlite-users mailing list
Briggs,
Re: "I guess I'm just getting greedy since sqlite is so much faster than our
standard databases ("progress")."
That's a distinct possibility.;-)
Re: "When you run a query for select * from table, does it literally copy the
contents of the table, or does it just build a
From: Nathan Biggs [mailto:nbi...@mycfs.com]
Sent: Wednesday, April 21, 2010 2:43 PM
To: Griggs, Donald
Subject: Re: [sqlite] Direct access of table data
Griggs,
Thanks for the quick reply. I guess I'm just getting greedy since sqlite is so
much faster than
Hello Biggs, this is Griggs,
Re: "Is there a way to read the values of a table directly without building and
executing a query. I have a function that has predefined memory..."
No easy way. The sophistication of database abstraction is the reason you
presumably chose to use sqlite.
On 27 Mar 2010, at 10:46am, GeoffW wrote:
> Just for educational purposes I have been experimenting a little with
> the Northwind Sqlite database contained on the sqlite official site.
> Download link: http://download.vive.net/Northwind.zip.
>
> Am I misunderstanding here or are the dates in
Tim,
Regarding: "I guess when do the transaction, the database was duplicated, and
it caused no free disk space"
Unless you do something such as "vacuum" the database should not actually be
duplicated. A rollback journal file,
though, **is** created.
(details at
Hello, Alexis,
Regarding:
> how many user at the same time ken use sqlite
I'm afraid the answer is, "it can vary widely depending upon your application
statistics, your programming, your CPU speed and ram, etc."
I'm writing to you from the sqlite users mailing list. Perhaps you could write
Regarding:
BTW, can you recommend me suitable UI to work with SQLite?
Maybe you've already tried out some of the GUI tools listed at:
http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
I'm not sure what your requirements and preferences are, or what operating
system you're using, or
Mark,
> Can you offer any advice on how to
> stop the files being written, and remove the
> programme(s) that are writing these files.
Hello, I'm (simply) a member of the sqlite mailing list.
As you probably know, it is not sqlite itself that is creating these files, but
some program on the
sqlite> .import C:\HEAD.txt head;
Error: no such table: head;
Any idea why I'm getting "no such table"?
Hi Phil,
The "dot" commands -- such as .import -- don't require a semicolon terminator,
and the utility is interpreting your trailing semicolon as part of the table
name.
You may also want
Regarding: Maybe the question for this issue is why it's not ok this syntax:
create index memoria.Dispositivos_TipoDispositivo on memoria.Dispositivos
>From my reading of the CREATE INDEX syntax at:
http://www.sqlite.org/lang_createindex.html
the parentheses are required, not
Regarding: ...is to use an MD5/sha1 or similar checksum of the record and use
the last 32 bits of that checksum. It is extremely unlikely for there to be a
collision ...
Except that the OP wrote: "...I don't think it works very well for 2^32
possible values (when there may well be only a
I'm not clear. Were you able to use Simon's syntax link:
http://sqlite.awardspace.us/syntax/sqlitepg09.htm
To correct your syntax?
SQL works with sets, and will always return the same number of columns, but you
*can* use sql to force a NULL, an empty string, or a space to be returned for a
> UPDATE LSOpenJobs
> SET vEmail = TRIM(vEmail);
>
> Given the state of the world economy, I hope that LSOpenJobs is an
> ever-expanding table. ;-)
Why do you say this? Will the table grow because of this statement? I have
fixed the client data entry to take care of this in the future, but
Regarding: I know that trim(vEmail) will do it, but what would be the command
to run to trim all of the existing records?
UPDATE LSOpenJobs
SET vEmail = TRIM(vEmail);
Given the state of the world economy, I hope that LSOpenJobs is an
ever-expanding table. ;-)
Regarding: Also, how to I
Regarding:
I have a small corrupted sqlite 3 database.
... Are there any tools for a more detailed analisys?
I'm not aware of any, Marko.
You may want to try
.dump mytable1
.dump mytable2
etc
On individual tables to see if some are salvageable.
For failing tables, if you *can* read a
comment lines in sql begin with --
Regards,
Simon
===
But both types are supported, right?
http://www.sqlite.org/lang_comment.html
C comments can span any number of lines. C-style comments begin with
"/*" and extend up to and including
Regarding:
/*
Here comes the comment. Source is reduced to show core of the problem.
*/
.mode column
==
FWIW, I reproduced error on 3.16.19 windows.
Of course, I presume this is not a problem with sqlite itself, but with
the sqlite3 utility program.
Interesting in
Hi Sylvain,
Regarding: can you describe an output of a "explain"?
==> A very short answer could be that, in the output of EXPLAIN QUERY
PLAN
"If you see the name of an index, then that index is used."
Regarding: is there something to tell us the best index to have for a
specified
Re: How to decide which table is the outer table and whichtable is the
inner table?
Possibly relevant:
http://www.sqlite.org/lang_analyze.html
___
sqlite-users mailing list
sqlite-users@sqlite.org
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ted Rolle
Sent: Friday, October 30, 2009 10:36 AM
To: sqlite-users
Subject: [sqlite] How to skip the first field on .import
The first field in my table is ID primary integer
Regarding: How to input the num
"212345678901234567890123456.988290112"?
Purely curious, if it's not confidential -- how are you acquiring
numbers of such precision?
If these are measurements, I'm just awed by the precision the device is
achieving. If instead these numbers represent
Depends on what your definition of "is" is.
(Sorry, non-English speakers. This is a tiny joke based in American
political history)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
:19:17 -0400, "Griggs, Donald"
<donald.gri...@allscripts.com> wrote:
>I'm grateful to Mike Cariotoglou for Sqlite3Explorer
> http://www.singular.gr/sqlite/
Unless I overlooked it, it won't let me copy all the rows into the
clipboard (tried CTRL-A, also tried selecting the
Regarding: "...copy the output of a SELECT into the clipboard so I can
paste it elsewhere."
Sorry for piling on another "me too" post, but:
I'm grateful to Mike Cariotoglou for Sqlite3Explorer
http://www.singular.gr/sqlite/
You can copy/paste the results of a select instantly into a
Gilles,
I know almost nothing about them, but the following may possibly be of
interest:
http://sqlrelay.sourceforge.net/
http://www.it77.de/sqlite/sqlite.htm
http://www.sqlite.org/cvstrac/wiki?p=ClientServer
Donald
___
sqlite-users mailing list
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of ge...@iol.it
Sent: Wednesday, October 21, 2009 2:03 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Like do not use index as previous version
Hi all,
it seems that in last
Regarding:
"I NEED HELP! I have SQLite3 DB (contacts from iPhone), it
contains 1 record, but when I open it with NOTEPAD.EXE, I see more than 1
record.
I need to repair all records from it"
С уважением,
I received your db (via private email) and the good news is
I believe one must enable the .TIMER option when compiling sqlite3. I
think the pre-compiled versions have this disabled by default (at least
for the Windows binaries).
Donald
___
sqlite-users mailing list
sqlite-users@sqlite.org
Hello, Adam,
Regarding: "... are there plans to stop sqlite3 from reading in all
column data on specific select queries? i.e I would like sqlite to ONLY
read column data for columns which are specified in the select and where
clauses."
I'm no sqlite expert, and moreover I'm not sure I understand
Matthew,
Regarding: "There's no way to optimize your query to be fast in both
situations."
I do *not* know if this would be of any help, but the newest 3.1.18
sqlite release which includes the SQLITE_ENABLE_STAT2 feature may
possibly be of interest: (and excuse me if you've mentioned this
Hi Matt,
Regarding:
"Is there a more comprehensive function list other than
http://www.sqlite.org/lang_corefunc.html;
Is there an sqlite-supported function that's not listed there, or are
you saying you want more functions?
If the latter, sqlite struggles to keep the "lite" on, but you can
Regarding:
"...I need to generate a view and add a ID column to that view. Is
this possible?"
I may well not be understanding your question, Tim. If so, you may want
to provide more information, such as what software you're using to speak
to the database, do you work with SQL, etc.
If you
Hi Rod,
Regarding: *Insert rate*: 7/sec.
You'll want to wrap your INSERT loop in a transaction, i.e., BEGIN /
COMMIT.
Without a transaction, each INSERT has to wait for multiple disk
revolutions.
http://www.sqlite.org/lang_transaction.html
If you have a huge number of inserts, you may want to
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Filipe Madureira
Is there a way to get a list of attached databases?
Either by SQL or by function call?
==
Greetings, Filipe,
PRAGMA
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Shaun Seckman
(Firaxis)
Sent: Friday, August 21, 2009 2:33 PM
To: General Discussion of SQLite Database
Subject: [sqlite] Reverse string comparison for searches
Hello everyone,
Regarding: "1. Provide a pre-compiled 2,1 (for Windows), or ..."
Hi Rod,
IN A SEPARATE PRIVATE EMAIL TO YOU I've attached a windows executable
command line utility for version 2.13.
Conversion is easy. Open the database using the version 2 executable
and use commands like ".output
Re: "I can't see how you get to that page."
I found the link from page:
http://www.sqlite.org/features.html
And perhaps it's linked from others as well.
Re: "I would expect to reorganise the physical database on a regular
basis..."
Once again, I'd look at the VACUUM command, though
Hi, CityDev,
Regarding:
All you have to do is copy
That's handy - I didn't realise that. However I suggest it's good
practice to dump and reload in these kinds of situations. I don't yet
know how SQLite works but I suspect a reload will get the physical data
into a better shape and clear out
Regarding:
I could start the id initially with 10 to allocate
That WOULD allow for a bunch of bull.;-)
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Subject: Re: [sqlite] SQlite performance on multi process env
Hello, Zhrahman,
Regarding: "... kindly suggest how to properly have the database
shared in memory among n number of processes. So they can execute select
operatins(read only no update on teh
database) effeciently."
If the
Joanne,
I don't want to imply that you *have* to take my suggested course of
action (and probably MOST of the folks on this list know better sqlite
than I), but, nonetheless, I'm still wondering about the results of my
suggestions. Maybe if you could either give your results for each, or
a
Hello Joanne,
Regarding: "Is there any command to check if the index or database in good
condition."
That's why I listed the pragma below in my email of last night and repeat email
earlier.
You're in luck if only the index is corrupted of course.
SAVE a copy of your current database (very
Hi Joanne,
It's possible you'll have to resort to your most recent backup. But before
doing that, I wasn't sure from your reply that you saw the other points I
listed.
-- Hold tight to my backups of my data.
-- Run "PRAGMA integrity_check;" as soon as possible.
-- See if the problem can be
-Original Message-
From: sqlite-users-boun...@sqlite.org [mailto:sqlite-users-boun...@sqlite.org]
On Behalf Of Joanne Pham
Sent: Monday, May 04, 2009 2:51 PM
To: General Discussion of SQLite Database
Subject: [sqlite] SQL error: database disk image is malformed
Hi All,
I ran the
I find it easy to confuse myself if I have either an unclosed quote, an
unclosed "/*" comment, or an unterminated command (semicolon).Below
is an example of two simultaneously.
SQLite version 3.6.10
Enter ".help" for instructions
Enter SQL statements terminated with a ";"
sqlite> select
Hi, Feng,
I don't think that "load data from" is part of the sql standard -- I may
be wrong.
At any rate, the source code to the command line utility is freely
available.
When you wrote that "Using ' insert into values' ... is very time
comsuming" did you mean time consuming to write the
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Andrey Fedorov
Sent: Tuesday, April 21, 2009 1:27 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Difference between all the joins
Hi all,
According to the join-op syntax [1],
Text concatenation is done with
||
Two vertical bars (virgules).
update tblEntry set Tags = Tags || ' new text' where RowID = 13
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dave,
Regarding: "I understand what a deadlock is, and I know it's not
technically a deadlock. This is why I stated the title as deadlock
behavior."
My apologies, Dave. I thought there might actually have been a
difference in definition that was adding to your problem. After your
reply,
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Dave Brown
Sent: Wednesday, April 08, 2009 1:16 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Strange sqlite_busy deadlock behavior
I tried the BEGIN
Hi, Arthur,
This mailing list, like many, will automatically strip attachments. Posting
onto your own webspace is a great way, as you have discovered, to reference
files.
I'm writing just to say that I *did* reproduce a problem.
I'm using Windows XP SP3.
I narrowed the problem to the sql
Hi Richard,
The sqlite3 utility allows a *single* dot-command on the command line
itself.
You can have an unlimited number of commands in a separate text file,
though.
http://www.sqlite.org/sqlite.html
So, using Windows syntax, you can have something like:
===
Set
Hi Michael,
Two thoughts -- and I hope others will chime in if I'm off-base here:
1) Build just one index after the import:
>From page:
http://www.sqlite.org/lang_createtable.html
"The UNIQUE constraint causes an unique index to be created on the
specified columns."
I think that if you
Hi Mark,
There's a good reason for your difficulty -- Sqlite uses dynamic typing:
http://www.sqlite.org/datatype3.html
As far as I know, the term "IndirectBlob" is not defined within sqlite
and is likely a term from the BitPim developers.
Sqlite allows one to use most anything as a type --
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of BOB_GOREN
Sent: Tuesday, March 24, 2009 10:49 AM
To: sqlite-users@sqlite.org
Subject: [sqlite] Replacement for COPY
Sqlite 2.8.13 supported statements like:
COPY
-Original Message-
On Sat, Mar 21, 2009 at 2:27 AM, Griggs, Donald <donald.gri...@allscripts.com>
wrote:
>>>>>
>>>>>> However, when I ask the user to send me their deck, I find that:
>>>>>>
>>>>>> sqlite> p
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of d...@dommel.be
Sent: Monday, March 23, 2009 11:28 AM
To: General Discussion of SQLite Database
Subject: [sqlite] Export the results from a select to excel
Hello,
what is the
> However, when I ask the user to send me their deck, I find that:
>
> sqlite> pragma integrity_check;
> integrity_check
> ---
> ok
> sqlite> select id, count(id) from cards group by id having
> count(id)
>> 1;
> sqlite>
>
> Any
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of
mrobi...@cs.fiu.edu
Sent: Wednesday, March 18, 2009 7:26 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] how many tables can I have in one database
Dear colleagues,
I
Re: [sqlite] Speed of DROP INDEX
This may not be useful to your situation, but my (not terribly informed)
*guess* is that the reason it takes so long is that the index pages are
spread throughout your 8-millon row database.
If by chance it's feasible to either:
-- Not create the index until
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Ken
Sent: Tuesday, March 17, 2009 7:31 PM
To: sqlite
Subject: [sqlite] httpd server ???
===
Hi, Ken,
Mr. Hipp's Tiny Web
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of
REPKA_Maxime_NeufBox
Sent: Monday, March 16, 2009 3:11 PM
To: General Discussion of SQLite Database
Subject: [sqlite] SQLITE : documentation and search topics
Hello,
A main
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Wolfgang Enzinger
Sent: Sunday, March 15, 2009 1:39 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] SQLITE : Constraint question
BTW, is there a document that explains in
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Trainor, Chris
Sent: Wednesday, March 11, 2009 5:31 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Slow performance with Sum function
> Do not be tempted
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Tito Ciuro
Sent: Wednesday, February 25, 2009 6:36 PM
To: sqlite-users@sqlite.org
Subject: [sqlite] Transactions and attached databases
Hello,
If I attach one or more
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of manohar s
Sent: Monday, February 23, 2009 4:59 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] SQLite caching
Thanks for your quick replies, although restarting my machine, disc
cache is
hi,
my question is how to get the number of columns in an existing table.
example if i can retrieve the number of rows with SELECT count(*) FROM
table , is there also some simple query to do the same thing for
counting the number of columns
==
Hello, "r"
You can use sql to query
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Paolo Pisati
Sent: Tuesday, February 17, 2009 4:55 PM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Hundreds of thousands of INSERTs
Griggs, Donald wrote
> p...@ferret:~/log_analyzer >date ; ./log_parser_ms_sqlite.pl 2
> vmta2-2009-02-16_1400-success.log.bz2.done.ec.ed ; date Tue Feb 17
> 15:07:40 CET 2009 Tue Feb 17 15:13:22 CET 2009
>
> it's a 75% shave of application time, amazing!!!
>
> --
>
If you really have to have even more performance,
Griggs, Donald wrote:
> > On linux you can do
>
>> dd if=database.db of=/dev/null bs=1M
>> and after perform "select ..."
>>
>
> =
> From: sqlite-users-boun...@sqlite.org
> [mailto:sqlite-users-boun...@sq
> On linux you can do
> dd if=database.db of=/dev/null bs=1M
> and after perform "select ..."
=
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Nathan Biggs
Subject: Re: [sqlite] Full Table Read
We are actually using
Greetings, Ha Le,
When you asked "What are the factors which determine the different limits", I
suspect I'm not understanding just what you're asking.
You referenced
http://www.sqlite.org/limits.html
And one of your two examples was "Maximum Depth Of An Expression Tree"
The webpage
Regarding: "...Really cool would be something like:
cat db1.dat db2.dat db3.dat > final.dat"
I don't think there are any "really cool cat's" available. ;-)
The format of the database is fairly fancy, though it is documented if
you think you'd be interested in writing a utility
Hi Vance,
Could you maybe give one or two examples on exactly what you need that
you're not finding on the website?
As far as syntax, it's pretty much all linked from:
http://www.sqlite.org/lang.html
E.g. for automatically incrementing primary key, see:
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Roger Binns
Sent: Wednesday, January 28, 2009 1:12 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] Transaction behavior with large numbers of inserts
Venkat,
Sorry. I really intended to quote page:
http://www.sqlite.org/sqlite.html
Though
http://www.sqlite.org/quickstart.html
May be helpful as well.
___
sqlite-users mailing list
sqlite-users@sqlite.org
On 1/27/09, Griggs, Donald <donald.gri...@allscripts.com> wrote:
>
> Venkat,
>
> If you have a ".db" file it almost certainly *is* an sqlite database.
> A great attribute of sqlite databases is that they are contained in a
> single file.
>
> If you're loo
Venkat,
If you have a ".db" file it almost certainly *is* an sqlite database.
A great attribute of sqlite databases is that they are contained in a
single file.
If you're looking for a GUI frontend, they are legion, including good
free ones such as sqlite3explorer and a plug-in sqliteManager for
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of J. R. Westmoreland
Is there a way to get an autoincrement field without being a primary
key?
Yes, you can create a trigger to do this. (This also allows you great
Hi Alex
I can't answer your specific questions, but I presume you've already
studied the file format document (most recently mentioned by Roger
Binn's recent post):
http://www.sqlite.org/fileformat.html
___
sqlite-users mailing list
Regarding:
"This would definitely work but does incur the overhead of
sqlite3_prepare each time I want to run the query."
Maybe you would be preparing hundreds or thousands of different queries
per minute -- but if by chance you're not -- could anyone be expected to
Subject: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7
Hi,
I consider upgrade sqlite 3.3.4 to sqlite 3.6.7. So, I wonder there is
any change (or problem) of file format.
===
Upgrading from version 2 to version 3 (understandably) required a dump
and restore, but
A design constraint of SQLITE was to avoid adding a bunch of bool
present in other DB's.
(Bad joke, couldn't resist)
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Emil Obermayr
Sent: Friday, January 09, 2009 2:58 PM
To:
Regarding:
"...but this doesn't work because the .mode tabs isn't separated from
the regular SQL.
Could someone point out how to accomplish this?"
If I understand correctly, all you need to do is write the desired
commands out to a text file, then either direct stdin to the text file,
or
Regarding:
>> I am sure there is a better way to deal with 12K rows by 2500
>> columns, but I can't figure it out
I wonder if you might want to use *sed* or *awk* or *perl* to preprocess
the data before import.
A "master" table could contain the unique person id, plus the fields
that you
-Original Message-
From: sqlite-users-boun...@sqlite.org
[mailto:sqlite-users-boun...@sqlite.org] On Behalf Of Rachmat Febfauza
Sent: Sunday, December 28, 2008 9:13 AM
To: General Discussion of SQLite Database
Subject: Re: [sqlite] confusing with how to to this in sqlite
thanks simon
Regarding:
Is there a way to use a prepared statement and bind a (variable)
array of integers?
Like in:
SELECT FROM table WHERE someinteger IN ( 2,18,19,340,1,72, 15
... )
Becomes:
SELECT FROM table WHERE someinteger IN ( ? )
I don't know that you can bind these,
Regarding: "...No regexp() user function is defined by default..."
The reason, if I recall correctly, is that the regexp routines that were
available were GPL'd and would mess with the licensing of sqlite.
___
sqlite-users mailing list
I'm not certain I understand your question, but here goes:
Sqlite3.exe is a command-line interface, so you don't really "browse" at
all.
However, you can specify the path and name of a database on the command
line when you invoke sqlite3, e.g. (In windows):
Sqlite3
1 - 100 of 275 matches
Mail list logo
