RE: [sqlite] Retrieve Database Metadata

Hi Joel, Have you already looked at: http://www.sqlite.org/pragma.html#schema (as well as sqlite_master as mentioned earlier) -Original Message- From: Joel Cochran [mailto:[EMAIL PROTECTED] Sent: Thursday, March 29, 2007 1:55 PM To: sqlite-users@sqlite.org Subject: [sqlite]

RE: [sqlite] Search engines and the Sqlite.Org website

Regarding: Does anybody know what "luggle.com" is? FWIW, I see that Luggle.com appears to be a small site run off a linux pentium by a few developers. It does contain mention of sqlite: http://luggle.com/~sean/Articles/sqlitePV.php Excerpt from page:

RE: [sqlite] sqlite Performance

Regarding: Creation of flat file takes 1.5 secs vs 3 seconds to create sqlite db. Flat file is 13 MB, sqlite db is 11 MB. "Any ideas how to get the sqlite output timings to a more respectable level would be appreciated. " I may be way off base if I'm not understanding correctly, but how can

RE: [sqlite] DB recovery

Regarding: "In a situation where if the sqliteDB gets corrupted is there a way to recover the data ?" "...The scenrio is an embedded device with sqlite in it and user does not have direct access to the DB. So, are there any Sqlite interfaces which do the recovery job mentioned in your

RE: [sqlite] DB recovery

Hi, Pavan, Regarding: "In a situation where if the sqliteDB gets corrupted is there a way to recover the data ? I understand that the word *corrupted* is too generic from technical point of view. But, still would like to know if anyone has faced a situation where indirect methods are used to

RE: [sqlite] bug in the cmd shell

Regarding: The .import cmd has a problem when it encounters binary zeros embedded in data. I should think this would be considered a bug. Hi Jim, While you can file a ticket for this, I wouldn't be shocked if it others disagreed. The command line utility requires

RE: [sqlite] I Need database fot some test

Regarding: "... I thought SINGLE QUOTES were thé standard ?" I believe single quotes are the standard for literal strings, but double quotes for table names. - To unsubscribe, send email to [EMAIL PROTECTED]

FW: [sqlite] Re: A few (probably) simple questions ...-- or "Learning right from wrong."

Regarding: where nothing is said about not supporting "RIGHT" UhRIGHT. Apparently, right is wrong. ;-) Though it may be corrected just by virtue of being posted on this list, anyone can submit a ticket on the documentation (or edit the wiki portion directly).

RE: [sqlite] A few (probably) simple questions ...

Stef, Regarding: "(I'm interested in this differences, because I'm trying to generate SQL statements from a visual design, like in MS-Access. If anyone knows good literature about generating SQL statements from graphical designs, I'ld be much obliged.)" === I wondered if the source for the

RE: [sqlite] Question about regexp function

Hi Neil, Re: " I would like to perform regular expression queries interactively, i.e. from the sqlite> prompt"I I'm not sure what operating system you're using, but there are sqlite GUI utilities that register a REGEX function. In windows, one such free one is Sqlite3Explorer:

RE: [sqlite] Re: Any way to know the numbers of rows affected by a cmd?

Regarding: Anderson, James H (IT) wrote: > I guess I forgot to mention the context. I'm interested in doing this > from the cmd shell. > > James, You can use the command pragma count_changes=1 in the shell to have it report the number of rows affected by insert, update, or delete

RE: [sqlite] Performance problem

Regarding: "Can only one index be used per query?" Yes, I believe that *is* the defined behaviour of sqlite (though it does support compound indicies). Larger DBMS often have very involved code to determine query plans.

RE: [sqlite] Importing data without a primary key

-Original Message- From: Sebastian Tennant [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 28, 2007 12:56 PM To: sqlite-users@sqlite.org Subject: [sqlite] Importing data without a primary key Hi all, I have a CSV file of data that doesn't include a column suitable to be the primary

RE: [sqlite] SQL query - TOP

Regarding: "It would appear that the "TOP" syntax is not supported by SQLite (maybe just a Microsoft thing?). However is there an alternative? " Take it to the "LIMIT", Mark. See: http://sqlite.org/lang_select.html The LIMIT clause places an upper bound on the number of rows returned in

RE: [sqlite] Performance problems potentially related to index scalability

Regarding: "...Next, I add in an index on [one] of my numeric columns. ... This is where the problem comes in." You may already know this, but if you can tolerate waiting until the loads are complete before adding the index, the total performance should be better.

RE: [sqlite] Is there a SQLiteSpy-like thing that will let me change data from a grid?

Regarding: "If I want to change data ." Sqlite3Explorer is free software, and works as you describe. I imagine there are several others. http://www.singular.gr/sqlite/ (Not sure if there will be future releases of this or not) [opinions are my own, not necessarily those of my

[sqlite] Sqlite used in open source phone system (pbx)

Maybe this is old news, but I noticed that Sqlite is used by "OpenPBX," an open source PBX. I would think it's yet another tribute to Sqlite's reliability that it was chosen to run in a phone switch. - OpenPBX is a fork of the Asterisk PBX. On the home page of the OpenPBX

RE: [sqlite] Odd indexing behavior, 2nd request for help

Hi Michael, Regarding: "I sent this 2 days a go but have not received an explanation or solution. Anybody had this problem?" Joe Wilson tried providing some explanation on 2 January: "Hitting both the index and the underlying table can often be slower than just doing a table scan if you have

RE: [sqlite] Joining tables in a single file

Regarding: " I need something like: cat A.db B.db C.db > full.db # kidding" - Hi Alberto, My first inclination is to consider this a classic use of the ATTACH DATABASE command http://www.sqlite.org/lang_attach.html

RE: [sqlite] a question about muticonnection

-Original Message- From: Nikki Locke [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 06, 2006 6:06 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] a question about muticonnection Hongdong wrote: > I just have a base question: > assume user A and user B now both connection to

RE: [sqlite] Re: Saving tables

Regarding: sebcity <[EMAIL PROTECTED]> wrote: > ... After you create your tables how do you save them so > they are permenently there? And Igor T's reply: They are "permanently there" from the very moment you create them. All changes are written to the database file when a >>transaction is

RE: [sqlite] Importing text file via .bat file

Echo .mode csv >MyCommands.tmp Echo .import ReadCode.txt ReadCode >>MyCommands.tmp Sqlite3 ReadCode.db ".read myCommands.tmp" = -Original Message- From: RB Smissaert [mailto:[EMAIL PROTECTED] Sent: Wednesday, November 15, 2006 1:13

RE: [sqlite] Importing text file via .bat file

Regarding: "...but how would I combine all this in one .bat file ...?" Hello, RBS. The following is in windows commandline syntax: Echo .mode csv >MyCommands.tmp Echo .import ReadCode.txt ReadCode >>MyCommands.tmp Sqlite3 ReadCode.db ".read myCommands.tmp" or,

RE: [sqlite] Dropping Tables

Regarding: "Since I cannot learn how to drop a table from a database by referring to Owens' book, I hope that someone here can point me in the right direction." See: http://www.sqlite.org/lang_droptable.html Just take the syntax link for most any syntax question:

RE: [sqlite] Re: number problem with 3.2.8

-Original Message- From: Lloyd Thomas [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 25, 2006 7:49 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Re: number problem with 3.2.8 I did try number literal >10 but mad no difference. I will rebuild the database row as an integer.

RE: [sqlite] Escaping wildcards when using LIKE & UTF-16

Re: "..a possible optimization I'm thinking of ..." Is it simple to place, say, 10 SQL Bind operations in series, then see if this time is even perceptible? Since this is a human interface, is it not likely that any efforts to avoid the binds will go unnoticed because the execution time is so

RE: [sqlite] new sqlite-based webserver

Greetings, Günter, Regarding: "...my server is running at home ... and has a dsl-(2mbit) connection to the world." Do you know if your connection is symmetric? In the U.S. most all home DSL circuits are ADSL, with the upload maximum speed just a fraction of the download maximum. Places like

RE: [sqlite] Optimize performance - reading from multiple databas e files, processing and writing to separate results database file?

Regarding: "...I believe my only option is to attach databases one at a time,..." I can't say I know enough of your system to be sure, but keeping each subject's data in a separate database may not serve you well in the long run. Since I would suspect you will want to do various searches that

RE: [sqlite] Optimize performance - reading from multiple databas e files, processing and writing to separate results database file?

Hi Serena, I hope that more expert users will chime in here, but my initial thoughts were: -- 1 Gbyte is not at all too big for Sqlite to handle in one file. -- Some portion (large??) of the performance advantages of transactions will be lost in opening/closing files, even if transactions were

RE: [sqlite] Problem with EXPLAIN in Sqlite-3.3.5

Re: EXPLAIN is omitted by default. Recompile with -DSQLITE_DEBUG=1 to turn it on. That certainly explains it. - To unsubscribe, send email to [EMAIL PROTECTED]

RE: [sqlite] Problem with .import

Regarding Rich Shepard's problem: "...tells me that 31 columns are expected, but it found 32." And tagging onto Dennis Cote's explanation: "...I suspect you may have trailing spaces at the ends of your lines." I agree with Dennis. Apparently there are different interpretations for

[sqlite] The term "flat-file" as applied to sqlite

I've noticed that more than one contributor to this list has referred to sqlite as a "flat file database." I had always thought of a flat file as a file composed of single table of records, with records defined either by fixed-width allocations or by some sort of delimiter (e.g.,

RE: [sqlite] how to ".import" an Ascii file

Hi Randall, Regarding: how to ".import" an Ascii file (separator is " ") Assuming that no translations have occurred in transit, it looks as though you're using a single ascii space as a separator. So, given a file such as: cat dog koala bananna orange kiwi You should be able to import it

RE: [sqlite] Recovery tool ?

"...alimentation interruption..." --- Power interruption -- fascinating how languages work! Yohann, Sqlite tends to be pretty good in the face of power interruptions on most OS's, sorry you are having trouble. I think you'll want to: 1) copy your database in its current state (for

RE: [sqlite] Replace of substring in sqlite-table - how can I do this?

Hi Wolfgang, Regarding: "...thank you very much for your reply. But is there no command within sqlite to do this? In my case, only substrings of the cells of one column need to be changed!" Sqlite was designed as a small SQL library -- extremely small, considering its capabilities --

RE: [sqlite] Control the scheme layout

Delf, If I understand your question, the FAQ may help: http://sqlite.org/faq.html#q9 Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, May

RE: [sqlite] sqlite_get_table performance problems

-Original Message- From: Patrik Svensson [mailto:[EMAIL PROTECTED] Subject: [sqlite] sqlite_get_table performance problems ... Can someone PLEASE PLEASE PLEASE help me? = Hi Patrik, The good folks on this list likely cannot

RE: [sqlite] testing Avg() function in other database engines

FWIW, Informix 7.31 returns REALs for both averages and also for sum(a)/count(a) Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board of directors. -Original Message- From: Dennis Cote [mailto:[EMAIL PROTECTED] Sent: Wednesday, February 08,

RE: [sqlite] can ignore n lines when .import data file?

Regarding: I want to use .import ... but the first line is the variable(fields), so I want to ignore it. = Possible option #1: If it wouldn't violate any database-enforced constraints, why not import the entire file, then delete the first row via SQL? DELETE

RE: [sqlite] ring buffer table

-Original Message- From: Paul Bohme [mailto:[EMAIL PROTECTED] Sent: Friday, December 23, 2005 2:10 PM To: sqlite-users@sqlite.org Subject: Re: [sqlite] ring buffer table Cory Nelson wrote: >afaik, sqlite doesn't store row counts so count(*) causes a full table scan. > >On 12/23/05,

RE: [sqlite] Slowness with in-memory database

Regarding: ... Something is misconfigured as it takes ~20 times as long to insert into an in-memory db, as it does to select from Sybase and store to a file. ... I'm not sure you're using transactions. If not, BEGIN a transaction before starting the loop of INSERTs and END it when done. This

RE: [sqlite] foreign keys? (sqlite3)

Re: I've created a class that generates the necessary sql statements to describe the primary-foreign key relationship between two tables. Todd, I suspect there would be interest to some on the list. You may also want to review Cody Pisto's utility linked from page:

RE: [sqlite] Anyone ?

Regarding: Hi Don, No, I did not received, any email from Jens Miltner's in fact, I notice, that posting from the sqlite list, are becoming very sparse in coming there are hours of gaps sometime nothing for a day. I don't think it's unusual for there to be day-long gaps. Others may know

RE: [sqlite] Anyone ?

Richard, No loop commands on your part are needed. Did you receive Jens Miltner's post of 9:55am (UTC-4hr)? Was it relevant? --- Are you sure your text file has the correct line-endings? From a quick look at the shell sources, it looks like the shell expects native

RE: [sqlite] Bitwise comparison -- consider not getting bit

Regarding: "...What's the best way to do a bitwise comparison in a sql query...?" Hi Debra, Dennis Cote gave you a direct answer to your question -- since sqlite supports bit operations directly in SQL. But I wondered if you might want to evaluate dispensing with bit-wise variables and

RE: [sqlite] SQLite kind-of memory leak (PATCH) - bug reports

Hi Clifford, Page http://www.sqlite.org/support.html Suggests that you *not* directly email the (actually pretty responsive) author, but instead start a ticket at: http://www.sqlite.org/cvstrac/tktnew Donald Griggs Opinions are not necessarily those of Misys Healthcare Systems nor its board

RE: [sqlite] Encryption and fixed header values (was Re: [sqlite] Why can i open a textfile?)

Regarding Mrs. Brisby's ending comment: "A better defense: use a different key each time. Encrypt the session key separately." I may way off in asking this, but: Since we're talking about the encyption of data at rest, and aren't in a client-server situation, how could sqlite make session

RE: [sqlite] Convert / Import

-Original Message- From: administrator [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 16, 2005 5:01 AM To: sqlite-users@sqlite.org Subject: [sqlite] Convert / Import Does anybody know a good/quick way to convert from V.Fox 8 .dbf to sqlite format ? I tried to export to .csv from

RE: [sqlite] Coverting databases - 2.8 to latest 3

Re: how do I convert databases? -- The command-line utility (for both versions) has a nice ".dump" command, and you just feed sqlite3 on it's output. If you don't need to keep the .dump output file you can just pipe it: sqlite OLD.DB .dump | sqlite3 NEW.DB

RE: [sqlite] Data/time storing?

Re: Wonder what the best way is to store a date (and time). Hello Edwin, If you haven't already, you'll want to read about the sqlite date/time functions at: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Donald Griggs Opinions are not necessarily those of Misys

RE: [sqlite] Limit how much data to read - substr syntax

Regarding: Where in the documentation that explains how to use the sqlite substr() function? Hi Shawn, >From the main sqlite.org page, take the SYNTAX link, then EXPRESSIONS http://www.sqlite.org/lang_expr.html substr(X,Y,Z) Return a substring of input string X that begins with the Y-th

RE: [sqlite] Efficient record insertion techniques?

Regarding inserting log records to sqlite database: Re: OK then I guess I need to batch them to improve performance. Temp tables best way to go? Yes, if, after leaving the database open, you still need more performance improvement, then batching multiple inserts per transaction should help

RE: [sqlite] Efficient record insertion techniques?

I'm no expert, but I hope the following are accurate. Regarding: 1) Should I use a transaction even for a single record? You already are, since your inserts automatically become one-line transactions. Re: 2) I open the DB, insert the record and close the DB for every record inserted. What if

[sqlite] re: Where can I find all of these [date/time] functions documente d?

regarding: Where can I find all of these [date/time] functions documented? See: http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions Which is linked from the front of the wiki: http://www.sqlite.org/cvstrac/wiki Donald Griggs Columbia SC, USA Opinions are not necessarily those

RE: [sqlite] sqlite3.exe timed queries

Thomas and Dave, Re: "...it would be extremely handy to have an option in the sqlite3.exe program for printing the execution time of a query." If you're using windows, Mike Cariotoglou has given the community a great free gui front-end, Sqlite3Explorer, that includes this feature:

RE: [sqlite] Getting data into PilotSQL

Regarding: "I have an SQLite database with 2 columns and 66,000+ rows that I would like to use on a Palm Tungsten T3." Klaus, I googled up the following. http://www.jpilot.org/pipermail/jpilot/2002-November/001121.html It implies that comma-delimited data is importable to the pilot.

RE: [sqlite] NFS Query Performance

I'm not sure how your network is set up, but if you're using 100mbps ethernet, the full- table-scan queries are only 4-5 times slower over the net. Wouldn't that be the same order of magnitude as the ratio of link speed to ATA local disk bus speed? As for the inserts, if you're achieving over

RE: [sqlite] Some Functional Questions

Hi Ken, I don't know enough to respond to all of your questions, but maybe the following will help for a few of them. Locking and concurrancy info: http://www.sqlite.org/lockingv3.html Date/timestamp variables: http://www.sqlite.org/lang_createtable.html Date/time manipulation

RE: [sqlite] Re: Index not used with "between"

Hi Cory, Regarding: Is there a reason [the sql command] BETWEEN can't use [an index]? Hmm... nobody has an answer? Or did my message get eaten by a spam filter :( I can't answer your question by providing you the reason, but it appears to be a fact that you will want to use separate

RE: [sqlite] Version 3.2.0

Regarding: and added a column to a table. then using the 3.0.8 sqlite3 went into the same database. Did you vacuum (using 3.2.0) after adding the column? That's required if you want to manipulate the database with older version 3 code. Donald Griggs Opinions are not

RE: [sqlite] Newbe question on collations

Hi Ben, >From the syntax page: http://www.sqlite.org/lang.html There are mentions of how to use the COLLATE keyword for CREATE TABLE, CREATE INDEX, and SELECT. For example, a select statement might end with: ORDER BY lastname COLLATE NOCASE; I think NOCASE and BINARY are built-in

RE: [sqlite] Re: [unclassified] Re: [sqlite] getting rid of dirty SQLITE_BUSY workaround

Regarding: ... As an example the ethernet card you're probably using right now. ... they detect the collision, wait a short period, and retry. For those using Unix/Linux, would this provide the queuing needed for those apps with numerous parallel writes?

[sqlite] Wiki -- a few links vandalized -- needs revert

FYI; I have yet to learn much about Wiki's but I understand they can be easily reverted to undo vandalism -- and someone seems to have vandalized the last few links of page: http://www.sqlite.org/cvstrac/wiki to point to inappropriate content. Donald

RE: [sqlite] foreign keys? (sqlite3)

> -Original Message- > From: Dick Davies [mailto:[EMAIL PROTECTED] > Sent: Tuesday, February 01, 2005 3:52 PM > To: SQLite > Subject: [sqlite] foreign keys? (sqlite3) > > > The docs seem to say sqlite3 does'nt support foreign keys, is > that correct? > > If so, I don't understand what

RE: [sqlite] db admin tool

Sten, Regarding: Is there any free or commercial DB admin tool that works with sqlite 3.08 and runs under Windows. I posted this 1 Dec, but in case you didn't find this: -- Regarding: Are there any tools like sqliteplus that work with version 3? Not sure what platform you

RE: [sqlite] Tools for sqlite ver 3

Amir, Regarding: Are there any tools like sqliteplus that work with version 3? Not sure what platform you need, but SqliteExplorer http://www.sqlite.org/contrib And SqliteCC (Control Center) http://home.student.uu.se/frax0795/ Look for sqlitecc-api3-exe.zip and you must

RE: [sqlite] ALTER TABLE statement?

Richard, When you wrote, "...as my boss feels that he can't easily alter the database with a GUI tool" Is there any chance you meant to type "withOUT a GUI tool" instead? If so, and if you're on a PC, then the nice utility: SqliteExplorer http://www.sqlite.org/contrib has the ability

RE: [sqlite] How can i get the column's names from a table with t he sqlite.exe command line ?

Subject: [sqlite] How can i get the column's names from a table with the sqlite.exe command line ? Bonjours, Christian. As far as I know, you could either: Parse them from the output of .schema tablename or, more simply, if the table is non-empty: .headers on

RE: [sqlite] Re: sqlite-users Digest 22 May 2004 05:23:11 -0000 I ssue 115

Re: The subject of licenses on toolkits: ".Anyway, better solutions [than Microsoft's] have already been offered so I'll say no more on this thread." Am I correct in that the Borland solution offered earlier has a license restricting it to *personal* use only? If so, then (gulp) is it

RE: [sqlite] SQLite and ODBC

Regarding: "I was more think of ways to get an SQLite Database connected to every day database objects and controls." A good point! This may be a naive comment of mine, but if you just forgot about the vanilla sqlite download page, and instead considered page:

RE: [sqlite] Re: Report writer

Regarding: ...though I am ultimately interested in having my product work natively on Linux Then I'm even more out-of-my-league here, but there's a free beta-ish JDBC wrapper for SQLITE at: http://www.ch-werner.de/javasqlite/overview-summary.html and Linux OpenOffice

RE: [sqlite] Report writer

Ron Aaron [mailto:[EMAIL PROTECTED] wrote: Does anyone have a generic report writer which could be used with SQLite? Hi Ron, Are you developing for Windows? If so, I don't know if one of these might be of help: 1) I see there's a commercial, but not

RE: [sqlite] Where are the acrhives?

re: Where can I check older (last week) emails posted in the SQLite list? Indexed by thread or date: http://www.mail-archive.com/[EMAIL PROTECTED]/ - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands,

RE: [sqlite] time calculations

Hi Ken, Regarding: " But the events can take place in any setting whatsoever. For instance, if the events represent some sort of timing for stock trades, or ..., then the database host's internal clock has no relevance." You're absolutely right. Regarding: "(Here I'm assuming that SQLite

RE: [sqlite] time calculations

In "after-pressing-SEND hindsight:" I suppose that for a system to really care about a leap second jump, it would have to be at least reasonably synched to the NIST clocks as a precondition -- otherwise the normal computer clock drift would mean that the clock is off by multiple seconds

<    1   2   3