RE: [sqlite] Join

If I understand your question, yes, you can join tables from different database files, and you can do it directly. http://www.sqlite.org/lang_attach.html E.g., ATTACH 'MyOtherDatabase.db' AS other Then, prefix tables in the second database with other. E.g., select other.addresses.postalc

RE: [sqlite] Re: How to obtain the integer part of a result

Hello, A.J. Regarding: I couldn't find that sentence (CAST) in the SQLite doc, neither in the Owens's book. Is it a SQL standard?, or a built-in SQL function? or a SQLite built-in aggregate function? You'll want to see the *syntax* section of the website, under the very useful page on *expr

RE: [sqlite] Powered by SQLite image?

Regarding: Is there any image/logo with "powered by SQLite"? You know, people with web services (not webservices) that rely on SQLite might like to say that to others :) Well, Alberto, there *was* one, but it was so very tiny, lightweight, and efficient that few could actually see it. ;-) Seri

RE: [sqlite] FW: Performance problem with complex where clause

regarding: "So it seems that indexes are not used at all, and that is pretty strange" There's a great feature in sqlite that lets you know for sure. Prefix your query with: EXPLAIN QUERY PLAN SELECT . And you can see just which, if any indices are used. For a more detailed look

RE: [sqlite] Best way to optimize this query?

Hi Tito, People ROWID, idx GUID, idx First, idx Last, idx Email ... The ROWID is indexed implicitly I believe, so it may be slowing things slightly if you index it explicitly. Regarding: "What if I have, say, 500 to retrieve?" You can create a

RE: [sqlite] Odd performance issue under Windows

I may be confused a bit. Regarding: 1) "the described slowdown occurs consistently on Windows XP Home and Pro and on Windows Vista." On its face, I would think this means that Xp Home and Vista do *NOT* have a problem, and that "fast" behaviour represents an integrity-risk problem. Regarding: 2

RE: [sqlite] Odd performance issue under Windows

John Elrick wrote: > "what the heck is happening that is creating a better than order of > magnitude difference in execution time on five out of seven Windows > machines?". John, If the database is opened and closed just once for your testing, I think you can find out if buffer flushing is invo

RE: [sqlite] SQL query, finding out which row a result is in

Hi Roy, If your statement "X" is represented below by "select ... Order by ..." Then would the following give you what you're looking for?? create temp table Xtab as (select Order by ); select ROWID from xTab where MemberID=4567373; (Without some "order by" clause, by the way

RE: [sqlite] Journal file question

> > I'm having the following problem: a sqlite database file is on an NTFS filesystem, in a directory with no permissions to create new files, You might consider: 1) do whatever it takes to get permission for file creation in the sqlite directory. 2) Use one of the wrappers that allows clien

RE: [sqlite] SQLite and nested transactions

Regarding: "...As Igor pointed out this does not resemble a full implementation of transactions, as nested transactions can be committed and rolled back independently of the outer parent transaction." Nonetheless, it would seem, just from the couple of pages below, that some DB vendors find the

RE: [sqlite] sqlite3.exe .import command

Ouch! I of course meant to write "can't" instead of "can" in the (corrected) sentence below. E.g. if you are importing a list of names, you *can't* just surround the name with quote chars, such as: "John Smith, Jr.",Anytown,USA --

RE: [sqlite] sqlite3.exe .import command

Re: "...The file I am importing is comma delimited text ..." I believe the default separator is the vertical bar (virgule, "|"), but as Igor wrote, you can easily change it with: .separator , I *don't* think you can quote commas which might appear in your text. E.g. if you are importing a l

RE: [sqlite] SQL and SQLite pronounciation?

re: "S. Q. Lite... that is my pronunciation..." And calling it "squirrelite" is simply a tongue-in-cheek affectionate affectation ;-) - To unsubscribe, send email to [EMAIL PROTECTED] -

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

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: http://b3n.chaosnet.org/cgi-bin/cs-alums/

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 o

RE: [sqlite] Format of csv file RE: [sqlite] date/time implementation question

Regarding: "What is the default separator?" [for using with .import in the command line utility] It is the vertical bar ("|", virgule, pipe character). By the way, I don't *think* that .import allows the separator to be quoted, does it? E.g., don't try to import 5,238,"Cohen, Jr.",Rafi expec

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 em

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 r

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 AS

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 d

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

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 sta

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 k

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 t

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 compa

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

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 SQL

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 co

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 P

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

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: http://www.sqlite.org/lang.ht

RE: [sqlite] query limited

Hello, Is it the "LIMIT" clause you need? If so, did you check the syntax page? http://sqlite.org/lang_select.html [LIMIT integer [( OFFSET | , ) integer]] For example, SELECT * FROM mytable LIMIT 100; >From the above page: -- The LIMIT clause places an upper bound on the n

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

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 sma

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 ht

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 sp

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 al

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 delim

[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., comma-separated

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 us

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 safekeeping

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

RE: [sqlite] Extra functions - New Project?

Regarding: A non-standard SQL function I like, and don't think I've seen anywhere but an Aspentech product is SUBSTRING. Alex, Is the second option ("positional") not identical to the existing "substr" function? E.g. for strFoo = 'abcdefgh'; Instead of substring(strFoo from 1 for

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 17

RE: [sqlite] Dumping Memory-DB to File

Henning, Since enclosing your inserts in a transaction (see below) would likely result in a *HUGE* increase in speed, might this remove your need for a :memory: database altogether? BEGIN; INSERT...; INSERT...; ... COMMIT; (In addition to using a transaction, you can

RE: [sqlite] Temporary tables

Regarding: "I am thinking of keeping these temp tables in a separate database file.." Hello Unit, If you haven't already, you may want to read: http://sqlite.org/pragma.html#pragma_temp_store and http://sqlite.org/pragma.html#pragma_temp_store Donald Griggs Opinions are no

RE: [sqlite] New Kexi for MS Windows released

Regarding: Download demo of International "2006" Edition for MS Windows: http://www.kexi.pl/wiki/index.php/Kexi_for_MS_Windows ... regards / pozdrawiam, Jaroslaw Staniek / OpenOffice Polska = Where does one go for the full, non-demo Win32 binary p

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 hel

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

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

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: http://www.sqlite.or

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

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 usin

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 key

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 Visua

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] ATTACH, query and differentiate

Hi Andrew, Perhaps I shouldn't be replying since I don't think I'm understanding your question fully. When you wrote: "with each entry having a unique id" did you mean that you are creating a unique identifier, or instead that you are making use of the ROWID within sqlite? Regarding: "it

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 Healthcare

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 cha

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 t

[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: h

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 36

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 compar

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 ne

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 c

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? http://sqlrelay.sourceforge.ne

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

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

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 a

RE: [sqlite] SQLite Tutorial - [Request For Comments]

Re: SQLite Tutorial http://prdownloads.sourceforge.net/souptonuts/README_sqlite_tutorial.html?do wnload Thanks for providing this. I did notice that the document insists on displaying at about 20% wider than my screen, causing lots of horizontal scrolling. My screen res is set to 1024x768.

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 to

RE: [sqlite] strange rounding problem

Isn't this a possibility with most any computer language when one uses binary floating point numbers? Since a real number such as 35.8 can't be EXACTLY represented as a binary fraction, there can always be a bit of floating point fluff added or subtracted, right? Its analogous to the fact that,

RE: [sqlite] One more question on the C API performance

Regarding: "... why the complex query takes x milliseconds to execute from > the sqlite command line but it takes 15 seconds with the APIs?" If you were to double the timeout limit, does the query then require 30 seconds? If so, that would certainly point to a timeout you're experiencing. Do

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: Tool licenses Thanks, Fred, a good point -- I would tend toward open-source solutions as well. I was not the poser of the question, though, just someone hoping to add a little to the information about the options. -Original Message- From: Fred Williams [mailto:[EMAIL PROTECTED] Sent:

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: http://www.ch-werner.de/sql

RE: [sqlite] Bulk insert or saving in memory database to file?

> sqlite yourbigdatabase > COPY yourbigdatabase.yourbigtable FROM yourbigdatafile Shawn, To follow-up on Puneet's answer: -- You can choose your delimiter. E.g. if you had comma-delimited data: COPY mytable FROM 'myfile.csv' USING DELIMITERS ','; Remember the nee

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 sup

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 expen

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

RE: [sqlite] time calculations

(Shoot! My previous email was another sent before it was quite ready. My apologies to all.) -regarding specialized needs for date/time calculations: An alternative (but way overkill for sqlite, right?) is to use specialized software to keep atomic time (TAI), or it's cousin, the GPS epoch time,

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 d

<    1   2   3   4   >