> I like navicat lite generally, though the lite version does not have
> diagramming. Their commercial edition does have this and they have 30 day
> free trials, so I'd probably check that out first and see if it does what you
> need. Mac users seem to universally adore sql editor (Puneet just s
Hi Sean,
> That said, having looked at tens of free options and seen the average
> quality, I would strongly recommend paying a few hundred bucks for a
> professional product if I needed this functionality.
Do you have any recommendations on commercial database diagram products?
Thanks,
Malcol
>> A user who has rated movie 1 twice
>> and has not rated movie 10,
>> would show up in your result..
> I vote that all future discussion on this list be in the form of Haiku.
Brilliant :) +1
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.o
Simon,
> convert your text file to .csv format, and use the SQLite command-line tool
> to make a table out of it.
Will this technique work with multi-line fields (fields with newlines)
or blobs?
Thank you,
Malcolm
___
sqlite-users mailing list
sqlite-
Another +1 on the "awestruck"!
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Jay,
Every system that uses a database must deal with this problem, and there
are no real easy answers. But here are a few deeper points to consider
...
Beautifully written!!
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite
Dr. Hipp,
> Your OS and filesystem configuration have a big impact too. I've notice, for
> example, that transactions are really slow on RieserFS on Linux compared to
> Ext3.
In your experience, which Linux file system(s) provide the high
performance platform for SQLite?
Which Linux file syste
This is a continuation of the "SQLite vs. Oracle (parallelized)"
thread with a request to learn how others are using SQLite with
very large data sets. The context of this post is processing
large data sets from a single process perspective, eg. this
question is being asked from a batch data process
Alexey,
Thank you for your reply and for sharing your success with SQLite. I'm
excited by your results (60x faster). On an informal basis, we've been
going back and re-benchmarking some of our old, 'traditional'
(Oracle/Informatica) ETL/DW projects and we now believe the majority of
these systems
, SQL Server and ETL tools like Informatica, Ab Initio, BO
Data Integrator, etc.
My goal is to be able to offer our customers cost effective, high
performance alternatives to traditional commercial ETL solutions. We
recently re-implemented a mid-sized Oracle/Informatica based ETL system
in Python
P Kishor,
>> Most computers these days are multi-core. ..
> One of things easy to overlook is that SQLite is not a PC-exclusive
software. About 10 million copies of SQLite run on iPhone. Who knows
how many run on other handhelds, embedded platforms, Vxworks, the
like. SQLite used to fit on a flop
Hi Billy,
>> Are there any plans to enhance SQLite to support some of Oracle's
>> parallel processing or partitioning capabilities?
> I realized that you're asking Richard, and not the peanut gallery, but
> I figured I might as well ask out of curiosity: why do you want to
> see these features
Dr. Hipp,
> The story goes like this: ...
Great story!
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dr. Hipp and others,
Thank you for your replies to my question.
Regards,
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Dr. Hipp,
When you say "SQLite is way faster than Oracle in a single-user
applications" do you mean that SQLite can be faster than Oracle even
when Oracle's parallel processing features are being used? For example
Oracle's support for parallelization can speed up table loading from an
external dat
Stefan and Michael,
Thank you very much for your feedback.
Regards,
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Is there any advantage to having data pre-sorted (in index order)
before loading it into SQLite and indexing it? Or does indexing
work best if the index values are randomly ordered at data load
time?
Thanks,
Malcolm
___
sqlite-users mailing list
sqlite-us
Igor,
> You could, I suppose, implement a VFS on top of a block of memory. See
> http://sqlite.org/c3ref/vfs_find.html
Great suggestion.
An idea for a future release of SQLite might be a memory based VFS that
would allow "small" SQLite databases to be manipulated entirely in
memory. SQLite data
Is it possible to open a SQLite database without physically storing the
SQLite database file on disk?
Background: Customer has application that generates SQLite databases
with proprietary pricing information. They would like their users to
download these databases from their SSL secured website an
Can SQLite take advantage of multiple CPU's and/or multiple
cores?
Thank you,
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
processing very large text based log files (> 16G each). We will be
using Python 2.52 as our SQLite scripting tool.
Thank you,
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Zbigniew,
> You can try "SQLite Studio" http://sqlitestudio.one.pl/
Thank you,
Malcolm
PS: For those following this thread, SQLite Studio is now (as of May 3
2008) a free product with GPL license.
___
sqlite-users mailing list
sqlite-users@sqlite.org
Tom,
> I started a tabulated comparison of various SQLite GUI applications for Mac:
> http://www.tandb.com.au/sqlite/compare/
Wow! Your list is quite comprehensive. Thanks!
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org
Hi Donald,
>> I think you're right for general purpose applications. But if you have ETL
>> or data conversion/analysis applications that can be re-run after a failure
>> (using source content), this type of pragma sounds like a reasonable choice.
> I very much agree with your statement -- I tu
> I use Firefox and I installed the SQLite add-in. I really like it!
Thanks Jeff!
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Thanks Kees!
> I played with a few other frontends, but always find myself back in
> Sqlite3Explorer.
> ... find a way to start FireFox with this add-on opening the database I'm
> interested in from a shell script, or associate my preferred sqlite3 filename
> extension (.db3) with it.
I've be
Thanks Robert!
> tkSQLite at http://reddog.s35.xrea.com/wiki/TkSQLite.html
Regards,
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Donald,
> http://web.utk.edu/~jplyon/sqlite/SQLite_optimization_FAQ.html#pragmas
>
> Am I right in that the article above promotes the use of "PRAGMA
> synchronous=OFF" without even a TRACE of warning that this may result in
irretrievable database corruption? Isn't that a bit reckless?
I think
> But my advice stands. Set things up and see how things work. If you want/need
> better performance, start tweaking. But there is a good chance that the
> performance "out of the box" will be fine.
Thanks Gerry!
Regards,
Malcolm
___
sqlite-users mail
Hi Gerry,
> Much care and thought have gone into setting up the default behaviors in
> SQLite.
> My advice would be not to use any pragmas initially.
That may be the safe solution, but my impression was that SQLite
defaults to conservative settings that may not apply to many of today's
high RAM
Hi Dennis,
> On Windows I like SQLiteSpy from
> http://www.yunqa.de/delphi/doku.php/products/sqlitespy/index
> For cross platform use (Mac, Windows, and Linux) you may be interested
> in the SQLite Manager add-on for Firefox at
> https://addons.mozilla.org/en-US/firefox/addon/5817.
Thanks fo
P Kishor,
> I have started liking Malcolm Hardie Company's SQL Editor (an inexpensive,
> ERD diagramming tool that can read and write SQLite databases, among other
> db)... not really a db front-end, but a utility nonetheless.
Thank you,
Malcolm
___
s
P Kishor,
> http://www.sqlite.org/cvstrac/wiki?p=ManagementTools
Oops, that's embarrassing!
Do you have a favorite on this page that you would recommend?
Thank you,
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/c
Looking for recommendations for 3rd party SQLite utilities for browsing,
maintaining, importing/exporting and repairing SQLite database files.
My primary development environments are Windows and Linux although I'm
open to Mac only products as well.
My 'google' research on this topic follows my si
27;m thinking PRAGMA TEMP_STORE = MEMORY and possibly
others???)
BTW: I'm interfacing to SQLite via Python 2.5 on Windows and Linux
systems with lots of RAM.
Thank you,
Malcolm
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite
P Kishor,
> I have no idea how I conveyed that impression. I think FTS3 is really
> wonderful, and have implemented it in my own personal website. I firmly
> believe in the "Why file when you can full-text search" doctrine.
Excellent! Thanks for the follow-up. You answered my questions. And put
>> Is SQLite's full text ready for production use yet?
> as ready as it will be. FTS 1/2 are deprecated.
You don't sound too thrilled :) Are there any limitations that one
should be aware of?
Thank you,
Malcolm
___
sqlite-users mailing list
sqlite-u
re two add-on modules for
full text search: FTS1 and FTS2.
Is SQLite's full text ready for production use yet?
I'm also wondering where I can find out if the version of SQLite that
ships as part of Python 2.5 includes automatic support for full text
search.
Hi,
What is the most efficient way to enter python binary data such as lists or
dictionaries in to sqlite? Has anyone had any experiences with this? We will
be inserting a list of lists of integers into our database.
For example:
[[1,2,3],[1,4,6],[1,1,1],[2,4,6],[12,32,4],...,[1,3,4]]
Any
39 matches
Mail list logo