craftconomy3 icon indicating copy to clipboard operation
craftconomy3 copied to clipboard

Published 20 hours ago • verified publisher icon greatman

Sql -> h2

Open Bennyboy1695 opened this issue 9 years ago • 5 comments

hi i was wondering if there was any easy ways that you knew of converting the sql data for your plugin over to h2 data instead. i know theres documentation out there but as your the plugin developer i thought you would be bound to know of an easy and simple conversion tool

Bennyboy1695 avatar Jun 30 '15 22:06 Bennyboy1695

You want Mysql => H2 ?

greatman avatar Jul 01 '15 05:07 greatman

Yeah thats correct and was wondering if you knew of any ways that will make us not lose any data and have minimal downtime while the data is changed over :P

Bennyboy1695 avatar Jul 01 '15 10:07 Bennyboy1695

Porting it is rather easy, H2 is simply a SQL database engine very similar to MySQL in terms of SQL commands support. There's nothing in cc3 atm doing the MySQL => H2 conversion since nobody asked for it. People usually do the other way around.

greatman avatar Jul 03 '15 04:07 greatman

we have been having sql issues with cc3 lately and another plugin and was going to try moving it to a h2 database to see if it solves the issue or at least temporarily fixes them otherwise we wouldn't be moving over

Bennyboy1695 avatar Jul 07 '15 00:07 Bennyboy1695

What kind of issues? Probably just a question of configuration / optimization.

greatman avatar Jul 07 '15 00:07 greatman