MISSION: Rapidly generate a Data-Access-Object (D.A.O) for embedding SQLite into any Java Aplication. Database Server not required!
I tossed this together to speed-up the creation of a lot of SQLite3 code recently, I thought that I would share this effort with you.
These classes will generate the C.R.U.D operations for a DAO (DML.) Schema / SQL Table creation & drop (DDL.) The implementation is designed for super-fast growth.
Full support for all SQLite (TEXT, Integer, Real, & BLOB/CLOB) built-in data-types, as well.
Project: https://github.com/soft9000/SQLMate
Demonstration on how to use the package is in GenTestTable.java.
Output class from same is in SqlTestTable.java.
NEW: 2024 - We're now able to:
- Dynamically SELECT Columns.
- Dynamically detect aliases, as well as to:
- Use a key / value pair to populate any generated Java Class.
Feel free to join us on Facebook.
Cheers,
Randall Nagy -- Soft9000.com
If you're into Python, you might also enjoy PyDAO.
If you want to support the effort, I seek no donations. Instead, simply feel free to purchase one of my educational or printed productions?