On 16 Apr 2014, at 4:42pm, Dominique Devienne <ddevie...@gmail.com> wrote:
> On Wed, Apr 16, 2014 at 3:41 PM, Simon Slavin <slav...@bigfraud.org> wrote: >> I would recommend that you download the SQLite shell tool and get to know it >> a little. Not only is it useful in creating a SQLite database from an SQL >> command dump or CSV files, but it allows you to test whether SQLite >> understands your SQL commands or not (you might be using a trick that works >> only in Postgres). If something works in the shell tool but not in your own >> code, you know it's because of a bug in your own code. > > I also recommend the shell tool. > > But note that there are tons of GUI tools for SQLite as well, although > I suspect many (all?) may not like 5B rows ;) Indeed. And GUI tools are frequently easier to use than command-line tools. But my reason for mentioning the Shell Tool specifically is more for debugging your code than for the things it does. It is written and maintained by the same team who writes and maintains SQLite itself so it is a way to tell if something should or shouldn't work in SQLite. If a SQL command works in the shell tool it is definitely legal and you should definitely get the same results from the same command in your code. It can save hours of trial and error trying to figure out whether the problem is a misunderstanding of how SQLite works. This is not true of other tools available for working with SQLite. I have seen countless examples of things various tools can't do, or of incorrect results (including incorrect error messages) they can return. Most of this isn't the result of bad programming, it's a natural consequence of trying to fit SQL to a GUI: the two don't really match up well, and the programmer naturally has to make simplifications and compromises. Other problems arise because the programmer isn't working directly with the SQLite API but instead with a data-manipulation framework designed for their OS, and the framework does not implement SQLite well. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
