[sqlite] Appropriate Uses For SQLite

Hi Dr. Hipp, group, > In a feeble effort to do "marketing", I am sure that nothing you do is "feeble"! > I have revised the "Appropriate > Uses For SQLite" webpage to move trendy buzzwords like "Internet of > Things" and "Edge of the Network" above the break. See: Nothing wrong with TLAs

[sqlite] Best JDBC driver for SQLite?

Hi all, I am currently working on a project which will use several different databases as a back end. I'm going to try and take advantage of the various features of the different databases as I go along, but obviously I will need to code some features by hand. As I'm going to be using Java, I

Re: [sqlite] Best JDBC driver for SQLite?

Hi, I sent this message to the list > As I'm going to be using Java, I would like to know what is the best > JDBC driver for SQLite - or if there isn't a "best" one, what are the > pros and cons of the different ones. two days ago - and haven't received a single reply. Is this not the

Re: [sqlite] Best JDBC driver for SQLite?

Hi, Thanks for your input. > Yes and yes. >  http://www.catb.org/~esr/faqs/smart-questions.html I followed the links on this page - http://sqlite.org/support.html and found this http://sqlite.org:8080/cgi-bin/mailman/private/sqlite-users/ It did not have a search function - I assumed that

Re: [sqlite] Best JDBC driver for SQLite?

Hi, Thanks for your reply. >> Gigs - what I'm interested in is sharding and using SQLite instances as >> shards in a larger ensemble. > Well now you've told us what you want out of it, we can comment usefully. Oh, goody! > You can handle your shards yourself, and you can implement sharding

Re: [sqlite] Proper way to escape table name and column name

2011/6/6 Jean-Christophe Deschamps : >>What is the official way to escape table name that contains a space >>and column name that contain a spaces? > You can use square brakets or double-quotes: > [This is a long name for a small table] > "This is a long name for a small

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

> Thanks. I was prepared to receive alternate suggestions :) > I wanted to have hands on and control over a browser with which > can follow sqlite versions quicker. If you want something that works on Linux as well as Windows, try the Firefox SQLite extension - it's the dog's! Rgs, Paul...

Re: [sqlite] sqlitebrowser - anyone compiled a recent one?

2011/6/9 Christoph P.U. Kukulies : >> If you want something that works on Linux as well as Windows, try >> the Firefox SQLite extension - it's the dog's! > I've heard big caveats about that one - to avoid like the .., no, I > don't want to open another can of worms :) I

Re: [sqlite] current version support wal mode?

2011/7/2 Kees Nuyt : > Just feed it the SQL statement: >        PRAGMA jounal_mode=WAL; I'm not being nasty here, but that is *_not_* an SQL statement. It is a C directive (or, at least, that's what I think it is!). Rgs, Paul... -- lineh...@tcd.ie Mob: 00 353 86

Re: [sqlite] current version support wal mode?

2011/7/3 Danny : > Like the old saying goes ... "When all else fails, read the manual." > http://www.sqlite.org/pragma.html Oooops However, I would argue that this "The PRAGMA statement is an SQL extension specific to SQLite" is the equivalent of saying that

Re: [sqlite] Performance Improvement

> I can at least store all the data, for the cases I have tested till > now (600 billion entries for now), but it is awfully slow. I'm not surprised. Maybe you should consider some sort of partitioning scheme? Take a look at VoltDB.com - it might be an approach? Paul... -- Hmmm a "life":

Re: [sqlite] Suggest some Tools for Sqlite

2011/8/18 Madhankumar Rajaram : > I hope there should be some good Free or Licence Tools for using Sqlite. > For ex : Toad for Oracle. Hmmm Toad for SQLite - there's a thought. ;) > so, Kindly suggest the best Free / Licence Tool for using Sqlite > Thanks Try the

Re: [sqlite] update required

2011/8/21 Richard Hipp : > But we've also gotten messages (including some irate late-night > phone calls to my personal telephone) complaining of problems with > English-language versions as well. That is a disgrace, and I hope that I speak for everyone on this list in

Re: [sqlite] Feature about Foreign Keys

> I would ask for a feature: to have a meta table where the foreign keys are > listed. > This feature it would be nice for large schemes. There are lots of nice-to-have features that one could add to SQLite. If you want to keep track of your foreign keys, download Datamodeler from Oracle -

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011/9/27 Patrick Proniewski : > I'm facing a challenging problem. I want to log some data into an SQLite3 DB. > Data come from a system command (iostat) in an endless steam, one row every X > seconds: Take a look at a utility called dstat. I've twiddled with the source and

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011/9/27 Patrick Proniewski : > That's what I do, but I think using a loop is ugly, and I would like to find a > way to feed data continuously into sqlite. cron Paul... > patpro -- Hmmm a "life": wonder where I can download one of those? lineh...@tcd.ie Mob:

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011/9/27 Patrick Proniewski : > That's what I do, but I think using a loop is ugly, and I would like to find > a way > to feed data continuously into sqlite. I can't see why you would want to do this more than once every minute - or do you? If not, ==

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011/9/27 Patrick Proniewski : >> Take a look at a utility called dstat. > no, it's linux only. But it is written in Python - so it should be relatively transportable. I've even managed to modify the code myself - and if I can do it, anybody can! 8-) Paul... > patpro

Re: [sqlite] feed "endless" data into sqlite, thru a shell script

2011/9/27 Patrick Proniewski : >> I can't see why you would want to do this more than once every minute >> - or do you? > The granularity I'm looking for is between 1 second and 10 seconds. Cron is > not > an option here. I woke up this morning and there is a way that cron

[sqlite] Tables as ASCII - is it possible?

Hi all, Is there a way of storing SQLite data (tables) as ASCII text rather than as binary data? I want to be able to run scripts against my data as well as use SQLite. If it's not available as a "normal" option, is there a patch on the interweb somewhere? If it does not exist, I respectfully

Re: [sqlite] Tables as ASCII - is it possible?

2011/10/23 Simon Slavin : >> I want to be able to run scripts against my data as well as use SQLite. > I recommend you script the sqlite3 shell tool to pipe whatever data you want, > or to make a text file of it which you can then read: Looks that this is the way to go

Re: [sqlite] Tables as ASCII - is it possible?

2011/10/23 Mr. Puneet Kishor : >> I want to be able to run scripts against my data as well as use SQLite. > Are you suggesting that you want to treat text data as a SQL data store? No, I'm suggesting that the SQLite engine be able to have table data available as text