At this moment we’re at the beginning of building a brand new Servoy app. What is the best back end database that we could/should use and also why? Maybe this will help us decide what to choose.
Thanks in advance for your advice.
We are in the exact same situation, and have decided to build our application with the included Sybase backend because it will be FREE to our clients. Many clients can simply not afford to pay for a MS SQL or MySQL license, or rather we would rather take the money for solution licenses.
We also intend to make it flexible enough to work with any SQL backend database, so if a large client happens to use Oracle, then they are free to do so, and do not need to use Sybase.
It is my understanding that a Servoy solution can work with any SQL database backend. All you have to do is setup the connection, configure the driver, and then run the SQL scripts for table/column generation. It is also my understanding that even if some clients of your solution are using MS SQL, some using Oracle, and others using Sybase, a new release you build can still be published and available to all those users without any further modifications on their part (Servoy will generate all the new tables/columns in the backend necessary for the new release).
Hope that helps.
Hi
I have used MySQL since starting with Servoy with quite a few installations now with no regrets.
Simple to setup and works first time every time. Servoy seems to work well with it, and fast. It is also quite a small download.
The advantage of MySQL is the number of tools that can be used with it, many of them free and very good. MySQL Administrator is excellent.
Depending on how you get the download you may have to pay a licensing fee.
remon kortman:
What is the best back end database that we could/should use and also why?
The question is what are your requirements.
Pretty much any (O)RDBMS works great with Servoy.
Like the others who have replied already mentioned if you don’t want to pay extra for a RDBMS then Sybase works well since you already paid for it. Only when you need to connect to it with other tools (PHP/JSP/etc.) then you need to buy a server license. And as a developer you can d/l the excellent Sybase Central for free as well.
PostgreSQL would be another option. It is a highly capable Open Source ORDBMS and distributed under the BSD license which means it’s totally free (as in beer) to use it. If you need (enterprise) support with it you can get support plans with a number of companies as well.
As for tools you can use the webbased phpPgAdmin or the cross-platform application PgAdmin3. But most commercial DBA tools support PostgreSQL as well.
As Robert mentioned, you can use the Sybase Central GUI tool to administer SQL Anywhere. It’s easy to use and should have pretty much everything you need to manage the database. Also, it includes other features that you may be interested in looking at, such as a visual query execution plan, application profiler, and index consultant.
The database itself is small, fast and reliable - and hopefully you can see this in the applications you develop.
Something else to keep in mind, which may not be applicable to your situation but I’ll mention anyway, is that SQL Anywhere is widely used in data synchronization environments. It is able to synchronize data to different types of backends, including Sybase ASE, Oracle, Microsoft and IBM DB2. Feel free to ask me any questions about this (or SA in general).
Good luck with your projects!
Regards,
Jose Ramos
Product Manager
Sybase iAnywhere