j256 / Ormlite Core
Licence: isc
Core ORMLite functionality that provides a lite Java ORM in conjunction with ormlite-jdbc or ormlite-android
Stars: β 488
Programming Languages
java
68154 projects - #9 most used programming language
Projects that are alternatives of or similar to Ormlite Core
Jooq
jOOQ is the best way to write SQL in Java
Stars: β 4,695 (+862.09%)
Mutual labels: orm, database
Prisma1
πΎ Database Tools incl. ORM, Migrations and Admin UI (Postgres, MySQL & MongoDB)
Stars: β 16,851 (+3353.07%)
Mutual labels: orm, database
Rel
π Modern Database Access Layer for Golang - Testable, Extendable and Crafted Into a Clean and Elegant API
Stars: β 317 (-35.04%)
Mutual labels: orm, database
Maghead
The fastest pure PHP database framework with a powerful static code generator, supports horizontal scale up, designed for PHP7
Stars: β 483 (-1.02%)
Mutual labels: orm, database
Think Orm
Think ORMββthe PHP Database&ORM Framework
Stars: β 303 (-37.91%)
Mutual labels: orm, database
Freezer
A simple & fluent Android ORM, how can it be easier ? RxJava2 compatible
Stars: β 326 (-33.2%)
Mutual labels: orm, database
Mikro Orm
TypeScript ORM for Node.js based on Data Mapper, Unit of Work and Identity Map patterns. Supports MongoDB, MySQL, MariaDB, PostgreSQL and SQLite databases.
Stars: β 3,874 (+693.85%)
Mutual labels: orm, database
Gnorm
A database-first code generator for any language
Stars: β 415 (-14.96%)
Mutual labels: orm, database
Sqlboiler
Generate a Go ORM tailored to your database schema.
Stars: β 4,497 (+821.52%)
Mutual labels: orm, database
Sequelizer
A GUI Desktop App for export sequelize models from database automatically.
Stars: β 273 (-44.06%)
Mutual labels: orm, database
Nohm
node.js object relations mapper (orm) for redis
Stars: β 462 (-5.33%)
Mutual labels: orm, database
Orm
ORM with clean object design, smart relationship loading and powerful collections.
Stars: β 266 (-45.49%)
Mutual labels: orm, database
Architect
A set of tools which enhances ORMs written in Python with more features
Stars: β 320 (-34.43%)
Mutual labels: orm, database
Wetland
A Node.js ORM, mapping-based. Works with MySQL, PostgreSQL, SQLite and more.
Stars: β 261 (-46.52%)
Mutual labels: orm, database
Crecto
Database wrapper and ORM for Crystal, inspired by Ecto
Stars: β 325 (-33.4%)
Mutual labels: orm, database
Sqlhelper
SQL Tools ( Dialect, Pagination, DDL dump, UrlParser, SqlStatementParser, WallFilter, BatchExecutor for Test) based Java. it is easy to integration into any ORM frameworks
Stars: β 242 (-50.41%)
Mutual labels: orm, database
Python For Entrepreneurs Course Demos
Contains all the "handout" materials for Talk Python's Python for Entrepreneurs course. This includes notes and the final version of the website code.
Stars: β 247 (-49.39%)
Mutual labels: orm, database
Reladomo
Reladomo is an enterprise grade object-relational mapping framework for Java.
Stars: β 336 (-31.15%)
Mutual labels: orm, database
Android Orma
An ORM for Android with type-safety and painless smart migrations
Stars: β 442 (-9.43%)
Mutual labels: orm, database
ORMLite Core
This package provides the core functionality for the JDBC and Android packages. Users that are connecting to SQL databases via JDBC will need to download the ormlite-jdbc package as well. Android users should download the ormlite-android package as well as this core package.
- For more information, visit the ORMLite home page.
- Online documentation can be found off the home page. Here's the getting started information. Here are the Javadocs for the code.
- Browse the code on the git repository.
- Maven packages are published via
- I've published a number of example programs.
ORMLite is easy to use and provides the following features:
- Setup your classes by simply adding Java annotations.
- Powerful abstract Database Access Object (DAO) classes.
- Flexible query builder to easily construct simple and complex queries.
- Supports MySQL, Postgres, Microsoft SQL Server, H2, Derby, HSQLDB, and Sqlite and can be extended to additional databases relatively easily.
- Provisional support for DB2, Oracle, ODBC, and Netezza. Contact the author if your database type is not supported.
- Handles "compiled" SQL statements for repetitive query tasks.
- Supports "foreign" objects with the class field being the object but an id stored in the database table.
- Basic support for database transactions.
- Auto generates SQL to create and drop database tables.
- Spring configuration support for DOAs and class configurations.
- Support for configuring of tables and fields without annotations.
- Supports native calls to Android SQLite database APIs.
Enjoy, Gray Watson
Code Example
The following is a quick code example to give you a taste on how to use the library.
// this uses h2 but you can change it to match your database
String databaseUrl = "jdbc:h2:mem:account";
// create a connection source to our database
ConnectionSource connectionSource = new JdbcConnectionSource(databaseUrl);
// instantiate the DAO to handle Account with String id
Dao<Account,String> accountDao = DaoManager.createDao(connectionSource, Account.class);
// if you need to create the 'accounts' table make this call
TableUtils.createTable(connectionSource, Account.class);
// create an instance of Account
String name = "Jim Smith";
Account account = new Account(name, "_secret");
// persist the account object to the database
accountDao.create(account);
// retrieve the account
Account account2 = accountDao.queryForId(name);
// show its password
System.out.println("Account: " + account2.getPassword());
// close the connection source
connectionSource.close();
ChangeLog Release Notes
See the ChangeLog.txt file.
Note that the project description data, including the texts, logos, images, and/or trademarks,
for each open source project belongs to its rightful owner.
If you wish to add or remove any projects, please contact us at [email protected].