GNOME Bugzilla – Bug 130879
MySQL integration
Last modified: 2021-06-09 20:27:38 UTC
optionally use MySQL for storage - especially for multiuser access
There are plans for this, we just need someone to write a mysql scheme and work with Alvaro to get the libgda move done. Are you interested in helping out with this? You could join the development mailing list.
folks, I am a sysadmin, not a developer. I could maybe do the database design for you and that only by instinct and not scientifically. Coding is definitely not something I do. I am trying to help by making inane suggestions ;-)
:) If you have knowledge about the differences between postgresql and mysql that would help, we just need to convert the postgresql scheme to mysql.
sorry no :(
i can help with the mysql/postges schema/sql conversion, but moving to libgda would be totally beyond me. is that useful?
We need both a mysql schema and to change some postgres specific things in the code, so a schema would be a good start I guess :)
Created attachment 24194 [details] Schema from Lars Brandi Jensen
Just done a lot of this too while getting to the bottom of the dns_name issues . Don't think it will be too hard to look at doing the MySQL provider (he says !) support given we've now got a schema. I'm suggesting a dialog option of chooseing which database type to use (out of a preset list which is the provider string). The PostgreSQL provider is currently defined in 3 places in Planner.
gnome-db has widgets to control the access to database, so we can reuse them as isolated applicatiosn or borrowing the code from gnome-db ;-)
re: MySQL - I discovered after I dug around the code why MySQL isn't being used right yet. Its only in MySQL 5 with the stored procedures that MySQL supports cursors (of which the Planner code uses) though its since MySQL 3.23.44 that itz got the foreign keys but these are in the InnoDB tables. There may also be some sequences that may not be the same but that could be coded around. So its really when MySQL 5 is released and you would have to use InnoDB tables, that Planner + MySQL could get closer. As for ODBC ? - I'd have to let others comment on how hard that would be to have Planner talk to a ODBC connector.
hmm, any news guys?
-- GitLab Migration Automatic Message -- This bug has been migrated to GNOME's GitLab instance and has been closed from further activity. You can subscribe and participate further through the new bug through this link to our GitLab instance: https://gitlab.gnome.org/World/planner/-/issues/31.