[Squirrel-sql-users] Use sqlite databases with SQuirreL SQL

[Till Biedermann]

Hi there,

i want to ask if it is possible to use sqlite databases with SQuirreL
SQL. If not, are there plans to supports sqlite in the future?

Thanks in advance.


Regards
Till

[Robert Manning]

Post by Till Biedermann
Hi there,
i want to ask if it is possible to use sqlite databases with SQuirreL
SQL. If not, are there plans to supports sqlite in the future?

Till,

In general, as long as there is a JDBC driver for a database, then
SQuirreL can access it. Having said that, I know of no one that has
reported use of SQuirreL with the SQLite database. If you have one
already setup and would like to use a JDBC driver (maybe
http://www.zentus.com/sqlitejdbc/) to access it, let us what your
experience is with it.

Rob

[Robert Manning]

Post by Robert Manning

Post by Till Biedermann
Hi there,
i want to ask if it is possible to use sqlite databases with SQuirreL
SQL. If not, are there plans to supports sqlite in the future?

Till,
In general, as long as there is a JDBC driver for a database, then
SQuirreL can access it. Having said that, I know of no one that has
reported use of SQuirreL with the SQLite database. If you have one
already setup and would like to use a JDBC driver (maybe
http://www.zentus.com/sqlitejdbc/) to access it, let us what your
experience is with it.

I decided to try my own advice. I downloaded the jdbc "pure" java
driver. It looks to be an all-in-one database engine and driver that
will read sqlite database files for you. I added the
driver to SQuirreL then made an alias using

jdbc:sqlite:test.db

The file it creates when I connect is called "test.db" and it is
located in the same dir as squirrel-sql.bat. I tried giving an
absolute path but on WinXP it doesn't seem to like c:/test.sb (I
consistently get out of memory error SQLExceptions)

Object tree in SQuirreL seems to work for basic types (tables and
views). Be careful though, I did notice that the developer of this
driver doesn't claim that it is complete, so there may be things that
SQuirreL asks for that aren't given. If you notice any weird
behavior, drop us a note (Please include any exceptions from
squirrel-sql.log and tell us exactly what you did to reproduce it when
describing problems)

Enjoy!

Rob

[Till Biedermann]

Hi,

Post by Robert Manning
I decided to try my own advice. I downloaded the jdbc "pure" java
driver.
[....]

Thanks for the help and hints. I also tested this driver.

Post by Robert Manning
The file it creates when I connect is called "test.db" and it is
located in the same dir as squirrel-sql.bat. I tried giving an
absolute path but on WinXP it doesn't seem to like c:/test.sb (I
consistently get out of memory error SQLExceptions)

No problems in this case for me. I tested on a Linux system. It also
works with absolute pathes and random locations for the database file.

Post by Robert Manning
[....] If you notice any weird
behavior, drop us a note (Please include any exceptions from
squirrel-sql.log and tell us exactly what you did to reproduce it when
describing problems)

I tested creating databases, tables and editing/adding values with
SQuirreL and open existing databases created by other tools with
SQuirreL. Everything works fine. No Problems occurred.
In case i make further tests and/or use SQLite/SQuirreL productive, i
will give another state report.


Regards,
Till
--
http://www.tbmnet.de






___________________________________________________________
Der frühe Vogel fängt den Wurm. Hier gelangen Sie zum neuen Yahoo! Mail: http://mail.yahoo.de