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