Yes, we think alike. H2 looms big for porting to Mac for the app. Please take a look at the current app if you have a chance, http://www.knowledgenotebook.com/
Thanks. P.S. Nice some college professors recommend it to their students (people told me...) On Nov 28, 5:24 am, Thotheolh <[email protected]> wrote: > Porting is always a pain to handle. What you are asking is more of an > architecture based question than a H2 specific question but it's > welcomed. > > What is your Windows application programming language made of ? Is it > MS .NET based ? Java ? Python ? C / C++ ... > > If you want to make your database accessible via Windows and Mac, you > can go MySQL, SQLite, H2, Postgres ... all these are good databases > that can be found across Windows, Mac and Linux. Their licenses are > open source as well. > > How do you define quickest / least effort to port a platform specific > (MS Access) database to something you expect to run across Windows and > Mac or more platforms ? > > Some solutions you might want to use is to make your variable types in > the MS Access database friendly to MySQL, SQLite, H2 .. preferably via > standards like the SQL92 standard despite these standards not always > that solid. What you need to do is to use common formats and variable > types for the table design in the database and then export them in SQL > or better, CSV format from the MS Access. When your application runs > in Mac using non-Access db, you can use the SQL script or CSV to > import them in for use in Mac environment. > > I would strongly recommend that you move away from using MS Access as > your database if you want to have a cross-platform application that > can execute on Windows or Mac. Something like MySQL or SQLite would > suit. Maybe Postgres ? > > If you application is Java-based, then H2 is a very good option. > > To answer your question if H2 is a good candidate, I think you need to > provide more information and scenarios for a clearer picture before a > better recommendation could be given. Please give more information. > > On Nov 27, 5:47 am, justaguy <[email protected]> wrote: > > > > > > > > > Hi, > > > I've decided to port my current app to support Mac as well. > > Currently, the off-line app supports Windows OS only because it's > > back- > > end data storage vehicle is MS Access. > > > There seems quite a few options out there... and I've eliminated a > > few > > of them already including mySQL... > > > A couple of things stand out here... > > a) quickest / least effort to port the Access db to its equivalent or > > the like for Mac > > b) the new database would have to be accessible by Railo on Mac, that > > is, via a datasource > > c) this new database on Mac platform is free, hence, I can bundle it. > > > Would H2 be a good candidate for this? Thoughts? > > > Thanks. -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
