In hindsight of this topic here i was wondering how hard do you guys think writing a piece of code that when run, would convert your MySQL database into a Text File Based system and getting it fully working (accounting for differences in DB/tables/rows etc) as i may need to code this v-soon.
Thanks
coding a conversion from MySQL data to flat file
Moderator: General Moderators
-
malcolmboston
- DevNet Resident
- Posts: 1826
- Joined: Tue Nov 18, 2003 1:09 pm
- Location: Middlesbrough, UK
Re: coding a conversion from MySQL data to flat file
You can use adodb for database abstraction, which supports sqlite, and then its just a matter of rewriting queries that don't specifically work on sqlite.malcolmboston wrote:In hindsight of this topic here i was wondering how hard do you guys think writing a piece of code that when run, would convert your MySQL database into a Text File Based system and getting it fully working (accounting for differences in DB/tables/rows etc) as i may need to code this v-soon.
Thanks
As to how much work it is, it depends on the complexity, number of db calls, and a dozen other factors. One game I recently ported to adodb took (literally) *one day*. But that was because they already had their own db-abstraction layer, so it was fairly straightfoward.