How to install Oracle SQL developer data modeler on Linux Mint 21 or Ubuntu Linux

One of the best tools for database design is the Oracle SQL Developer Data Modeler and it's free. As a developer who designs databases this tool is indispensable due to the features it has. The tool can be downloaded from https://www.oracle.com/database/sqldeveloper/technologies/sql-data-modeler/. Note that you need to have an account with Oracle. The only issue is … Continue reading How to install Oracle SQL developer data modeler on Linux Mint 21 or Ubuntu Linux

Where to place SQLite 3 database for use in a Java Project in Eclipse

My Eclipse Java project path is as follows: ~/workspace/PayrollApp/src/org/username/payrollapp/payroll.db I had placed the SQLite database file payroll.db in the above path, and found it was not getting used when I ran the Java program. Upon inspecting the contents of ~/workspace/PayrollApp, I found that payroll.db was there with 0 bytes. That implied that the file needs … Continue reading Where to place SQLite 3 database for use in a Java Project in Eclipse

Write Ahead Logging in SQLite 3.7.0 version and above

So far, SQLite did support transaction control, but entirely in memory. Version 3.7.0+ of SQLite now have a Write-Ahead Logging feature that allow more speed and flexibility to SQLite to manage record locking and journal management. This feature is called 'wal' in SQLite 3.7.0+. To activate WAL on a SQLite database, start up SQLite and … Continue reading Write Ahead Logging in SQLite 3.7.0 version and above

Use SQLite with Java

In order to use SQLite 3 with Java, you need to do the following steps on your Linux or Windows box. I have deliberately kept off specific commands. Install SQLite3 from your Linux distribution repository. You can also download the Windows edition if you use Windows. Visit https://bitbucket.org/xerial/sqlite-jdbc and download the JDBC driver. I downloaded … Continue reading Use SQLite with Java