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 (s
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 files - table1.txt, table2
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 alright!
>> If it does
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 s
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 *_could_* do what y
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
--
Hmmm a "lif
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,
==
cron iostat > myfile.
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: 00 353 86 864 5772
__
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
have its output go
> 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 - it's
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
condemning this sort of co
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 Firefox extension - I t
> 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": w
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 T-SQL or PL/SQL is SQL, it is
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 864 5772
___
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 don't wish to cause con
> 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...
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 table as well"
Or, wha
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 b
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 th
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
correct
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 wo
22 matches
Mail list logo