Skip to content

soft9000/SQLMate

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

57 Commits
 
 
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

SQLMate

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:

  1. Dynamically SELECT Columns.
  2. Dynamically detect aliases, as well as to:
  3. Use a key / value pair to populate any generated Java Class.

Cheers,

Randall Nagy -- Soft9000.com

If you're into Python, you might also enjoy PyDAO.

zSupport?

If you want to support the effort, I seek no donations. Instead, simply feel free to purchase one of my educational or printed productions?

About

Rapidly generate a Java / JDBC DAO for SQLite.

Topics

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages