mito
An ORM for Common Lisp with migrations, relationships and PostgreSQL support (by fukamachi)
sxql
An SQL generator for Common Lisp. (by fukamachi)
mito | sxql | |
---|---|---|
4 | 3 | |
271 | 348 | |
- | - | |
6.0 | 5.5 | |
8 days ago | 12 days ago | |
Common Lisp | Common Lisp | |
- | BSD 3-clause "New" or "Revised" License |
The number of mentions indicates the total number of mentions that we've tracked plus the number of user suggested alternatives.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
mito
Posts with mentions or reviews of mito.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-22.
-
Circular class references possible?
Are you using a custom metaclass for your classes? I know that Mito's metaclass has some issues around this sort of thing for its col-type, so if you're using a metaclass that's trying to resolve the type too early that could lead to problems.
-
Mito: An ORM for Common Lisp
Mito is an object relational mapper for Common Lisp created by Eitaro Fukamachi. It supports MySQL, PostgreSQL and SQLite3. It automatically adds id (serial/uuid primary key), created_at and updated_at by default like Ruby's ActiveRecord. It also provides support for Migrations and DB schema versioning.
-
Adding slots to a class during finalisation
Using Mito, one can define a class that corresponds to a table in a database. Instances of this class then correspond to rows in the database, allowing you to work with data in the database through a CLOS interface. (This is pretty standard ORM stuff.)
- Which is your ORM of choice?
sxql
Posts with mentions or reviews of sxql.
We have used some of these posts to build our list of alternatives
and similar projects. The last one was on 2022-08-22.
-
Are there any SQL query helper libraries available for Emacs?
There are also packages (in Python, Ruby, R, etc.) that allow you to query databases without directly writing the SQL. I see that there's a package called SxQL that does this in lisp, but I haven't seen it used in Emacs.
-
Mito: An ORM for Common Lisp
You can build custom queries like this in Mito with sxql.
- Lisp and the Web: Creating Web Apps Through Lisp and GCE
What are some alternatives?
When comparing mito and sxql you can also consider the following projects:
pgloader - Migrate to PostgreSQL in a single command!
caveman - Lightweight web application framework for Common Lisp.
nyxt - Nyxt - the hacker's browser.
cl-warehouse - A sample Warehouse management app in Common Lisp
Caddy - Fast and extensible multi-platform HTTP/1-2-3 web server with automatic HTTPS
common-lisp-by-example - Repo for Common Lisp by Example [Moved to: https://github.com/ashok-khanna/lisp-notes]