Create database-oriented applications with an extensible library of highly reusable schema modules.
«Abstract» means that a schema is independent from
- the data storage system (for example an SQL database server)
- the GUI to be used (Web, Graphical, Command-line, ...) An Adamo database can run via a Web or GUI application, via console interface, via agents, or via any combination of those.
This document introduces the special features of Adamo.
You may prefer to look at pizzeria1.py which illustrates Adamo using a simple example.
Adamo features
- develop reusable Entity/Relationship schemas in Python
- define business logic and design the user interface without worrying whether it is for a Web or a GUI application.
- Database schemas with Adamo don't use any SQL. Any SQL is automatically generated if necessary.
- The concept of a table is not limited to tables in a relational database: any data with tabular structure can become a table for Adamo. However currently there is only an SQL implementation of tables.
- Adamo manages links between tables in a transparent way.
- Adamo can also be considered as a "object relational mapper" since you access the database rows as objects.
- Examples — Here is a list of code snippets that demonstrate what a Python programmer can do with Lino. more
- Features : Automatic SQL generation , Multiple connections per database , Populating databases , Shared tables ,
Refering articles:
- SQLAlchemy (16.08.06) — Todo: check whether SQLAlchemy is a replacement for Adamo. Start with the Tutorial.
- start to make use of Lupy (et cetera 13.04.05) — How to integrate Lupy into a Lino application? It seems that there must be one Indexer per Database or per Application. more
- new package lino.reports (code changes 05.01.05) — Last night I had 2 important ideas at once: a completely new implementation for reports. See reports1.py for a quick example. Reports had to go out of Adamo because they make sense also without adamo. And together with this a solution for the redundant table names. more