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

Email: [Firebase] Client access to your Cloud Firestore database expiring in X day(s)

The easiest way to overcome this expiry is to change the date in the rules after logging into the account:match /{document=**} {// from previous date 2020, 11, 11 to new date 2021, 12, 11allow read, write: if request.time < timestamp.date(2021, 12, 11);} However, do note that it is important to drop access using this method … Continue reading Email: [Firebase] Client access to your Cloud Firestore database expiring in X day(s)

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

Database Design Utilities in Linux

If you are into designing databases, you can use the following open source database design software. I had a problem wherein it became quite difficult to manage a database with lots of tables and relationships, and these kind of software made database design much simpler. easyDesigner http://sourceforge.net/projects/easydesigner/ project Mogwai http://mogwai.sourceforge.net/index.html http://mogwai.sourceforge.net/erdesignerng.html DBDesigner4 http://www.fabforce.net/dbdesigner4/ Database Deployment … Continue reading Database Design Utilities in Linux