pony icon indicating copy to clipboard operation
pony copied to clipboard

Mention that PonyORM works with MariaDB as well

Open dlenski opened this issue 1 year ago • 7 comments

Because MySQL and MariaDB use the same on-the-wire protocol and most SQL-level features are identical, PonyORM also works with MariaDB, using the MySQL provider.

Tested on MariaDB 10.6.14.

After creating a 'test' database, and a user 'whoever' with access to that database (GRANT ALL PRIVILEGES ON test.* TO whoever), the "first steps" from https://docs.ponyorm.org/firststeps.html work fine, e.g.:

    from pony.orm import *
    db=Database()
    class Person(db.Entity):
        name=Required(str)
        age=Required(int)
    db.bind(provider='mysql', user='whoever', password='foobar', db='test')
    db.generate_mapping(create_tables=True)

dlenski avatar Mar 14 '24 22:03 dlenski

I'm aware of #270 (and its duplicate #548), which show that JSON manipulation does not yet work correctly with MariaDB.

dlenski avatar Mar 14 '24 22:03 dlenski

@kozlovsky This has 10 +1's - could you please considering merging this?

ottok avatar Apr 26 '24 03:04 ottok

I see main has no commits in past 10 months - wonder if PonyORM has been abandoned?

ottok avatar Jul 10 '24 00:07 ottok