Re: [sqlite] Statistics on integer primary key - Cardinality

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,

Re: [sqlite] Very Slow DB Access After Reboot on Windows

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 ___

Re: [sqlite] Very Slow DB Access After Reboot on Windows

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

Re: [sqlite] How to invoke successive SQLite script files

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

Re: [sqlite] Sqlite Insert Speed Optimization

-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

Re: [sqlite] Ticks to unixepoch date

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.

Re: [sqlite] Sqlite Insert Speed Optimization

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 the fastest records-per

Re: [sqlite] network access problem

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

Re: [sqlite] Very Odd... where field1='' or field2='' is slow

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 one index

Re: [sqlite] WHERE = does not work

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

Re: [sqlite] WHERE = does not work

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

Re: [sqlite] Direct access of table data

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. Re:

[sqlite] FW: Direct access of table data

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

Re: [sqlite] FW: Direct access of table data

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 structure

Re: [sqlite] Northwind example database

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 the

Re: [sqlite] sqlite3 error: database or disk is full when commit transaction

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

Re: [sqlite] Fwd: Sqlite User

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

[sqlite] suitable UI -- RE: What's the problem with my INSERT clause?

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

Re: [sqlite] Fwd: Sqlite files in temp folder

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

Re: [sqlite] Error: no such table on .import

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 to

Re: [sqlite] Index creation in a memory database

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

Re: [sqlite] Unique column constrained to 0 .. 2^32?

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

Re: [sqlite] selective result columns

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

Re: [sqlite] trim'ming a column

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

Re: [sqlite] trim'ming a column

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 there

Re: [sqlite] Corrupted SQLITE database recovery

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

Re: [sqlite] New sqlite bug report: Problem with /* */ comment followed by Non-SQL (sqlite-specific) command

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

Re: [sqlite] New sqlite bug report: Problem with /* */ commentfollowed by Non-SQL (sqlite-specific) command

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

Re: [sqlite] index optimal?

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: [sqlite] How to skip the first field on .import

-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

Re: [sqlite] How to decide which table is the outer table and whichtable is the inner table?

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

Re: [sqlite] How to input a double num?

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 something

Re: [sqlite] Grammar of X is Y

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

Re: [sqlite] SQLite server for Windows/Linux?

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

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

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 program

Re: [sqlite] [Windows] Good GUI alternative to sqlite.exe?

: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 first and the last row

Re: [sqlite] SQLite DB Structure

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

Re: [sqlite] Like do not use index as previous version

-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

[sqlite] Use of .TIMER within sqlite3 commandline utility: was RE: sqlite-users Digest, Vol 21, Issue 122

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

Re: [sqlite] Sqlite reading all column data on selects.

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

Re: [sqlite] Index usage

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

Re: [sqlite] replace extra carriage returns?

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

Re: [sqlite] create a view and add a column

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 *are*

Re: [sqlite] How long should Insert take?

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

Re: [sqlite] Attached database

-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

Re: [sqlite] Reverse string comparison for searches

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

Re: [sqlite] A problem with versions of SQLite

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 ascii.sql

Re: [sqlite] SQLite: Porting to another Operating system.

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

Re: [sqlite] SQLite: Porting to another Operating system.

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 you

Re: [sqlite] Db design question (so. like a tree)

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

Re: [sqlite] SQlite performance on multi process env

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

Re: [sqlite] SQL error: database disk image is malformed

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

Re: [sqlite] How to check the healthy of database and the indexes ofthe tables

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

Re: [sqlite] How to check the healthy of database and the indexesofthe tables

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

Re: [sqlite] How to exit from sqlite shell?

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

Re: [sqlite] SQL error: database disk image is malformed

-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

Re: [sqlite] How to create a table from a text file via c/c++ interface?

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 program,

Re: [sqlite] Difference between all the joins

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

Re: [sqlite] Appending Text to a Column

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

Re: [sqlite] Strange sqlite_busy deadlock behavior

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,

Re: [sqlite] Possible bug

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

Re: [sqlite] Strange sqlite_busy deadlock behavior

-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

Re: [sqlite] export table to csv

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

Re: [sqlite] creating unique data takes many hours, help

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 then

Re: [sqlite] Replacement for COPY

-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

Re: [sqlite] Documentation on SQLite indirectBLOB?

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

Re: [sqlite] problems with shared cache?

-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 pragma integrity_check; integrity_check --- ok sqlite select id, count(id) from cards

Re: [sqlite] Export the results from a select to excel

-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

Re: [sqlite] problems with shared cache?

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 ideas? Obviously, that user is not playing with a full deck. ;-)

Re: [sqlite] Speed of DROP INDEX

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

Re: [sqlite] how many tables can I have in one database

-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] httpd server ???

-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

Re: [sqlite] SQLITE : documentation and search topics

-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

Re: [sqlite] SQLITE : Constraint question

-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

Re: [sqlite] Slow performance with Sum function

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

Re: [sqlite] Transactions and attached databases

-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

Re: [sqlite] SQLite caching

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

Re: [sqlite] number of columns in a table

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

Re: [sqlite] Hundreds of thousands of INSERTs

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, you could

Re: [sqlite] Hundreds of thousands of INSERTs

-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

Re: [sqlite] Full Table Read

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

Re: [sqlite] Full Table Read

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...@sqlite.org] On Behalf Of Nathan Biggs Subject: Re: [sqlite] Full

Re: [sqlite] Limits in SQLite

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

Re: [sqlite] Fast and simple database merge

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

Re: [sqlite] Index keywords

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:

Re: [sqlite] Transaction behavior with large numbers of inserts

-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

Re: [sqlite] help : sqlite database restore

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

Re: [sqlite] help : sqlite database restore

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 looking for a GUI frontend, they are legion, including

Re: [sqlite] help : sqlite database restore

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

Re: [sqlite] Is this a bug?

-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

Re: [sqlite] Recover deleted records

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

[sqlite] FW: A list as an SQL paramater

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

Re: [sqlite] Upgrade sqlite 3.3.4 to sqlite 3.6.7

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

Re: [sqlite] Bool Values

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:

Re: [sqlite] meta command via string via shell?

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

Re: [sqlite] SQLITE_MAX_VARIABLE_NUMBER and .import for very widefile

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 intend

Re: [sqlite] confusing with how to to this in sqlite

-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

Re: [sqlite] IN expression performance

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,

Re: [sqlite] REGEXP

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

Re: [sqlite] data dump in sqlite

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   2   3   >