Search Results for "mysql crud generator"

hello-sql is a beginner-friendly, Spanish-language course repository that teaches the fundamentals of SQL and relational databases through practical examples. It focuses mainly on MySQL for lessons due to its ubiquity in education and professional environments, while also introducing PostgreSQL to broaden learners’ exposure to modern database tooling. The materials emphasize real-world query writing, schema design basics, and the mental model behind SELECT, JOIN, GROUP BY, and subqueries. Learners progress from setup and connection to hands-on exercises that build confidence with CRUD operations and data modeling. ...

Pony ORM is a Python ORM that enables developers to write database queries using generator expressions and Pythonic syntax, making code more readable and intuitive. It automatically translates Python expressions into SQL and supports multiple databases including SQLite, MySQL, PostgreSQL, and Oracle. With an emphasis on simplicity and maintainability, Pony ORM is suitable for both small projects and complex applications.

...Hostname to use for database connection. Not used for sqlite. username argument is OPTIONAL. Username for the database user. password argument is OPTIONAL. Password for database user. Only supported for mysql & PostgreSQL. locale argument is OPTIONAL. The localization of data to be generated ('en_US' as default). seed argument is OPTIONAL. Integer for seeding random generator to produce the same data set between runs. Note: uuid4 values still generated randomly.

Promet ERP is an ERP system in addition to the ERP functionality also provides message management, task / project management, document management. Any functionality can also be used individually. All data is stored in a central database. MSSQL, PostgereSQL, Firebird, SQLite, are the supported database systems. Orders, persons, articles can be managed with the ERP functionality. With the integrated report generator reports can be created visually. The Document Management helps to...

You assemble *blocks* in your django template, with each block wired to a tastypie resource, which in turn is mapped to a django model. Each *block* will reside in a dijit ContentPane which you must define in your template. You have a choice of 2 layouts for each *block*, Form or Grid based. Form displays a single record in either a 1, 2 or 3 column layout while Grid displays many rows in a spreadsheet like grid. You can perform edits in place on fields in both layouts. You can...

pyIRDG is a program written in Python to generate relational datasets in Prolog format. It uses data from the Internet Movie Database in combination with IMDbPY as backend. A graphical user interface written in pyQt allows the user to link multiple entities together as model for the generation process. The big four entities are Title, Person, Company and Character. Many attributes can be chosen for adding to the output .pl file. Three types of constraints on attributes are available to limit...

Intends to make an automatic interface generator for a given sql structure, with insert and update dialogs an delete functionability

Pony is an object-relational mapper. The most interesting feature of Pony is its ability to write queries to the database using generator expressions. Pony works with entities which are mapped to a SQL database. Using generator syntax for writing queries allows the user to formulate very eloquent queries. It increases the level of abstraction and allows a programmer to concentrate on the business logic of the application. Following is an example of a 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. ...

This tool generates Data Access Objects and Value Objects for PHP4/MySQL web applications. This greatly improves the readability of PHP scripts that use a MySQL database. Requires Python.

This tool creates a PHP class to interface to a given database table. The PHP class is a simple relational object mapper. It maps table columns to class attributes. It provides basic CRUD methods as well as utility methods such as CSV import and export.

reppy is a PDF-Report Generator for databases (MySQL, Postgres, CSV) written in Python. The report definition is based on an XML-template, which can be edited with the included program XTRed. It needs the python library reportlab for pdf-creation.