Menu ▾ ▴

Connection to SQLite DB

Technical questions
Anonymous
2014-01-10
2016-01-16

  • Anonymous

    Anonymous - 2014-01-10

    I've been trying to connect to a sqlite database, so far with no success. Maybe I missed something obvious, but could you please provide some pointers at how to do this, e.g. how to install jdbc drivers (sqliteis not in list) or how to use odbc drivers with sqlite.
    Thanks, Claas

     

  • PAscal

    PAscal - 2014-01-10

    starting with release 2013.10.rc1
    we added support for SQLite3
    using jdbc driver xerial sqlite-jdbc-3.7.2.jar
    then using
    driver class: org.sqlite.JDBC
    url format: jdbc:sqlite:dbname.db

    I hope this will help
    Regards
    Pascal

     

  • Anonymous

    Anonymous - 2014-01-12

    Thank you Pascal, will try that on Monday!

     

  • Anonymous

    Anonymous - 2014-04-03

    Hi, is there any update on how to use SQLite?

    I'm using 2014.04.rc1, and downloaded xerial sqlite-jdbc-3.7.2.jar.

    When I try to install the driver SQLeo shows a number of classes and other things within sqlite-jdbc-3.7.2.jar. Which one is the driver to select so that I can connect and use my SQLite databases?

    Regards
    Vaughan

     

    • PAscal

      PAscal - 2014-04-03

      as mentioned before:

      driver class: org.sqlite.JDBC
      url format: jdbc:sqlite:dbname.db

       
  • Comment has been marked as spam. 
    Undo

    View and moderate all "Technical questions" comments posted by this user

    Mark all as spam, and block user from posting to "Discussion"

    Anonymous

    Anonymous - 2016-01-16

    I put a post together to describe this http://kenfallon.com/adding-sqlight-as-a-datasource-to-sqleo/ and recorded a podcast here http://hackerpublicradio.org/eps.php?id=1965

     

    • PAscal

      PAscal - 2016-01-16

      Many thanks for this post !
      just a remark: if you use the tool only for displaying graphs
      - you may be interested to save the positions of the tables in that graph when saving the SQL query ...
      this can be achieved by setting tools/preferences/Query builder/save table position in SQL syntax
      - you have choosen SQLite, but you could also use Csvjdbc driver (that is available in /lib directory) to view csv files as tables

       

      Last edit: PAscal 2016-01-16

Anonymous
Anonymous

Add attachments
Cancel