Re: [sqlite] GUI for SQLite

Hello, Everyone has their own opinion on which SQLite GUI is 'best'. I've had the best consistent luck over the years using the SQLite Manager/Firefox plugin, in terms of a good mix of features and availability on different platforms. There may be better ones out there though, depending on

Re: [sqlite] Tedious CSV import question

On c.Mundi's CSV inquiry, One way I (interactively) address the need to import CSV data into sqlite databases is to use Mrinal Kant's SQL Manager add-in. This offers what I believe are more robust facilities for performing this type of bulk import. I'm not sure if SQL Manager is an option for

Re: [sqlite] Convert byte-array to in-memory DB?

Jeff, I'm not sure if I completely understand your intended work flow, but in these cases I'd generally try to work with data like this via a memory-mapped mechanism, especially relevant when you know the size of the data object in question ahead of time, as you apparently do, once a streaming

Re: [sqlite] SQLite Tools recommended: SQLite Manager

Hello Barton, Here is one suggestion to try: SQL Manager. I use SQLite Manager (by Mrinal Kant (http://sqlite-manager.googlecode.com) and find it extremely useful. It is developed in Xulrunner, Gecko, thus runs only under Mozilla/Firefox. That said, it runs essentially as a stand alone

Re: [sqlite] sqlite, MPI and PostgreSQL

Hello Rogrigo, I'll take a shot at a response to this, bearing in mind there are quite a few salient details you haven't yet provided in this post. --As a principle, I'd recommend keeping your solutions architecture as simple as possible, and use either PostgreSQL or SQLite, but not both,

Re: [sqlite] How many tables can a database hold?

J.R, --I'd suggest you check out URL: http://www.sqlite.org/limits.html --joins are typically limited to 64 tables --Assuming you (CAN) define a database with >1000 tables, IMHO, this is a fairly unconventional design strategy, if rarely needed -- some would say this is inadvisable. Typically

Re: [sqlite] sqlite on flash devices

Paul, here are a few odd thoughts on this: --Flash memory devices in general are subject to 'finite' numbers of I/O events, mostly affecting writes; more recent flash memory devices ease this constraint a bit, if only by supporting more I/O events before they hit their useful life-limit. I think