GitPlanet

Cheap and reliable Node.js hosting starts at $3/month, and $1/month static HTML hosting

Created with love in Canada, visit hostnodejs.com today

Feel like to post an Ad? Learn Details
All Projects → ponyorm → Pony

ponyorm / Pony

Licence: apache-2.0
Pony Object Relational Mapper

Programming Languages

python
139335 projects - #7 most used programming language
javascript
184084 projects - #8 most used programming language

Labels

mysqlpostgresqlormsqliteoraclecockroachdbcockroach

Projects that are alternatives of or similar to Pony

Typeorm
ORM for TypeScript and JavaScript (ES7, ES6, ES5). Supports MySQL, PostgreSQL, MariaDB, SQLite, MS SQL Server, Oracle, SAP Hana, WebSQL databases. Works in NodeJS, Browser, Ionic, Cordova and Electron platforms.
Stars: ✭ 26,559 (+861.59%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite, cockroachdb
Db
Data access layer for PostgreSQL, CockroachDB, MySQL, SQLite and MongoDB with ORM-like features.
Stars: ✭ 2,832 (+2.53%)
Mutual labels:  orm, mysql, postgresql, sqlite, cockroachdb
Qxorm
QxOrm library - C++ Qt ORM (Object Relational Mapping) and ODM (Object Document Mapper) library - Official repository
Stars: ✭ 176 (-93.63%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite
Linq2db
Linq to database provider.
Stars: ✭ 2,211 (-19.95%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite
Freesql
🦄 .NET orm, Mysql orm, Postgresql orm, SqlServer orm, Oracle orm, Sqlite orm, Firebird orm, 达梦 orm, 人大金仓 orm, 神通 orm, 翰高 orm, 南大通用 orm, Click house orm, MsAccess orm.
Stars: ✭ 3,077 (+11.4%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite
Xo
Command line tool to generate idiomatic Go code for SQL databases supporting PostgreSQL, MySQL, SQLite, Oracle, and Microsoft SQL Server
Stars: ✭ 2,974 (+7.68%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite
Servicestack.ormlite
Fast, Simple, Typed ORM for .NET
Stars: ✭ 1,532 (-44.53%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite
Smartsql
SmartSql = MyBatis in C# + .NET Core+ Cache(Memory | Redis) + R/W Splitting + PropertyChangedTrack +Dynamic Repository + InvokeSync + Diagnostics
Stars: ✭ 775 (-71.94%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite
Chloe
A lightweight and high-performance Object/Relational Mapping(ORM) library for .NET --C#
Stars: ✭ 1,248 (-54.82%)
Mutual labels:  oracle, orm, mysql, postgresql, sqlite
Aioodbc
aioodbc - is a library for accessing a ODBC databases from the asyncio
Stars: ✭ 206 (-92.54%)
Mutual labels:  oracle, mysql, postgresql, sqlite
Pop
A Tasty Treat For All Your Database Needs
Stars: ✭ 1,045 (-62.17%)
Mutual labels:  orm, mysql, postgresql, sqlite
Elefant
Elefant, the refreshingly simple PHP CMS and web framework.
Stars: ✭ 188 (-93.19%)
Mutual labels:  orm, mysql, postgresql, sqlite
Rom Sql
SQL support for rom-rb
Stars: ✭ 169 (-93.88%)
Mutual labels:  oracle, mysql, postgresql, sqlite
Sqitch
Sensible database change management
Stars: ✭ 2,320 (-16%)
Mutual labels:  oracle, mysql, postgresql, sqlite
Eosio sql plugin
EOSIO sql database plugin
Stars: ✭ 21 (-99.24%)
Mutual labels:  oracle, mysql, postgresql, sqlite
Hunt Entity
An object-relational mapping (ORM) framework for D language (Similar to JPA / Doctrine), support PostgreSQL and MySQL.
Stars: ✭ 51 (-98.15%)
Mutual labels:  orm, mysql, postgresql, sqlite
Nut
Advanced, Powerful and easy to use ORM for Qt
Stars: ✭ 181 (-93.45%)
Mutual labels:  orm, mysql, postgresql, sqlite
Ebean
Ebean ORM
Stars: ✭ 1,172 (-57.57%)
Mutual labels:  oracle, orm, mysql, sqlite
Prisma
Next-generation ORM for Node.js & TypeScript | PostgreSQL, MySQL, MariaDB, SQL Server, SQLite & MongoDB (Preview)
Stars: ✭ 18,168 (+557.78%)
Mutual labels:  orm, mysql, postgresql, sqlite
Adminer Custom
Customizations for Adminer, the best database management tool written in PHP.
Stars: ✭ 99 (-96.42%)
Mutual labels:  oracle, mysql, postgresql, sqlite
View All Similar Projects ➔

Downloads

Downloads Downloads Downloads

Pony Object-Relational Mapper

Pony is an advanced object-relational mapper. The most interesting feature of Pony is its ability to write queries to the database using Python generator expressions and lambdas. Pony analyzes the abstract syntax tree of the expression and translates it into a SQL query.

Here is an example query in Pony:

select(p for p in Product if p.name.startswith('A') and p.cost <= 1000)

Pony translates queries to SQL using a specific database dialect. Currently Pony works with SQLite, MySQL, PostgreSQL and Oracle databases.

By providing a Pythonic API, Pony facilitates fast app development. Pony is an easy-to-learn and easy-to-use library. It makes your work more productive and helps to save resources. Pony achieves this ease of use through the following:

  • Compact entity definitions
  • The concise query language
  • Ability to work with Pony interactively in a Python interpreter
  • Comprehensive error messages, showing the exact part where an error occurred in the query
  • Displaying of the generated SQL in a readable format with indentation

All this helps the developer to focus on implementing the business logic of an application, instead of struggling with a mapper trying to understand how to get the data from the database.

See the example here

Support Pony ORM Development

Pony ORM is Apache 2.0 licensed open source project. If you would like to support Pony ORM development, please consider:

Become a backer or sponsor

Online tool for database design

Pony ORM also has the Entity-Relationship Diagram Editor which is a great tool for prototyping. You can create your database diagram online at https://editor.ponyorm.com, generate the database schema based on the diagram and start working with the database using declarative queries in seconds.

Documentation

Documenation is available at https://docs.ponyorm.org The documentation source is avaliable at https://github.com/ponyorm/pony-doc. Please create new documentation related issues here or make a pull request with your improvements.

License

Pony ORM is released under the Apache 2.0 license.

PonyORM community

Please post your questions on Stack Overflow. Meet the PonyORM team, chat with the community members, and get your questions answered on our community Telegram group. Join our newsletter at ponyorm.org. Reach us on Twitter.

Copyright (c) 2013-2021 Pony ORM. All rights reserved. info (at) ponyorm.org

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].