sqlite-jdbc

SQLite JDBC Driver (by xerial)

Sqlite-jdbc Alternatives

Similar projects and alternatives to sqlite-jdbc

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a better sqlite-jdbc alternative or higher similarity.

sqlite-jdbc reviews and mentions

Posts with mentions or reviews of sqlite-jdbc. We have used some of these posts to build our list of alternatives and similar projects. The last one was on 2023-04-29.
  • Exciting SQLite Improvements Since 2020
    2 projects | news.ycombinator.com | 29 Apr 2023
    There's also a fairly popular JDBC driver for SQLite too:

    https://github.com/xerial/sqlite-jdbc

    Mentioning that because from (very) rough memory, Excel can work with JDBC too.

    So if the ODBC approach doesn't work for someone, there's potentially another thing they can try. :)

  • Janet for Mortals
    6 projects | news.ycombinator.com | 31 Mar 2023
    Sadly, another baseless assumption. I just downloaded sqlite java driver from https://github.com/xerial/sqlite-jdbc/. And compiled their sample program on the home page to native code. (all within ~1min after reading your response)

        javac Sample.java && native-image -cp .:sqlite-jdbc-3.41.2.1.jar Sample
  • Between using H2 and HSQLDB as a production DB, which is the better choice?
    3 projects | /r/java | 25 Oct 2022
  • Are there any reasons for not using SQLite as an embedded DB in a Spring Boot web app?
    2 projects | /r/java | 12 Oct 2022
  • What's the best approach for creating an embedded Postgresql to be used in production?
    3 projects | /r/java | 19 Sep 2022
    There is https://github.com/xerial/sqlite-jdbc, a full packaged sql lite for Java. We use it in production apps to store local user profile data. It works, is stable.
  • I’m Switching from VS Code to vs Codium
    10 projects | news.ycombinator.com | 12 Jun 2022
    > Take the Jetbrains IDEs. I don't mean to offend any VSC fans out there but the Jetbrains IDEs are simply better and more mature in every single way.

    I just discontinued my Jetbrains subscription after 10 years or so. Now I'm using VS Code and don't miss anything. My reasons for switching to VS Code are unrelated to the costs but purely due to quality issues and missing or poorly implemented features:

    1. For all Jetbrains IDEs, ISO keyboard layout with dead keys doesn't work on Ubuntu based distros. I was baffled when I found out after saying goodbye to Windows lately. When filing a bug I was asked to wade through years old pages of comments to find somewhere someone who posted a workaround that was not compatible with the Toolbox. Well, at least the support could have sent me the instructions to fix it to save me spending an hour to read those threads at the Youtrack.

    2. Vue 3 support was a disaster for itself. Still, Vue 3 support is very much behind the VS Code extension.

    3. Same for Svelte. They are not even working on bugs / feature requests like intellisense in the templates.

    4. Same for TailwindCSS. Never ending storing. Don't know and care if Jetbrains got it right by now.

    5. Starting maybe 2 years ago, Jetbrains added feature for feature that were just distracting and annoying. This "run command in terminal" thingie for example. They're bloating their IDEs with new (mostly useless stuff) but don't fix essential bugs or get Webstorm back into shape.

    6. Datagrip still doesn't (or maybe it does in the meantime) support SQLite STRICT TABLES (version 3.37). The simple answer from Jetbrains was: "The open source lib we're using does not support it so we don't." (Actually the lib (https://github.com/xerial/sqlite-jdbc) is currently unmaintained - another reason to be careful depending on a lib maintained by a single person.). The reply would be perfectly fine for an open source project, but not for a multi billion dollar company I as a customer had payed accumulated several thousand Euros in the last years.

    I'm using mainly Go, Rust and several frontend frameworks. VS Code support for those is really good. Many things work much better in VS Code.

  • Replacing JNI with Panama in the SQLite JDBC driver
    4 projects | /r/java | 7 Mar 2022
    I was working on this project for a few months: https://github.com/xerial/sqlite-jdbc/pull/568. I basically read this entire book to learn more about the C api: https://www.amazon.com/Using-SQLite-Small-Reliable-Choose/dp/0596521189 and studied the JNI for a few weeks.
    4 projects | /r/java | 7 Mar 2022
    The Xerial SQLite JDBC driver makes extensive use of JNI to call the SQLite C code. They make their own library with the JNI and SQLite code built together. Since the SQLite code can be built as its own library this looked like a good project to play with.
  • A remote interface for SQLite
    3 projects | /r/sqlite | 10 Feb 2022
    JDBC contains a lot of things many drivers do not implement, so I would not worry too much about that at first. You could implement only the basics first. See for example how https://github.com/xerial/sqlite-jdbc/blob/master/src/main/java/org/sqlite/jdbc4/JDBC4Connection.java does not implement many things.
  • What is something you made in Java to automate/make your job easier?
    12 projects | /r/java | 24 Dec 2021
    And often, sqlite-jdbc.
  • A note from our sponsor - WorkOS
    workos.com | 28 Mar 2024
    The APIs are flexible and easy-to-use, supporting authentication, user identity, and complex enterprise features like SSO and SCIM provisioning. Learn more →

Stats

Basic sqlite-jdbc repo stats
21
2,645
9.1
8 days ago
SaaSHub - Software Alternatives and Reviews
SaaSHub helps you find the best software and product alternatives
www.saashub.com