Saturday, September 20, 2008

The future of database devoloping

This summer I have been looking to new development tools that can help me in being more productive. I have to develop a lot of database applications (you know, a small database, some reports) and always a special feature that makes difficult to implement this in something like access.

So, I started looking in the Internet for a different tool than the normal I use (Visual c++ or visual c# and SQL server express database + crystal reports). I have found that there are special tools that offer a lot better performance, and I have tried to test 3 of them:

- Genexus: it seems to be a very good tool, but the price (more than 4000 euros), makes very difficult to thing in implementing it.

- Windev 12: A interesting tool, a mixture of Visual Basic, a small database and crystal reports. It enables you to develop very quickly this kind of applications, and also to deploy them in different languages (i.e. a application that runs in English & Spanish). I have installed the express version, and it seems to be a very powerful tool, and also not very expensive. This tool can work with a lot of different databases.

- Velneo: Something very special. It is a very powerful database applications development suite, that enables you to make very very quickly a complete database. It is a very different concept from Windev or the other tools. It enables you to develop a application, and the same application can be run for a couple of persons or for 100 persons at the same time. It is also a cheap tool.
The only things that I don“t like it is that it is limited to his own database format (they say that it is able to store more than 3.000.000.0000 records).
They are developing a new version (V7), that in my opinion can be a breakthrough in software development. This version has everything I need to make a multilingual application with a small database in a couple of days, with a beautiful look and very easy to use.
And also the application will be ready to evolve from 2 simultaneous users to more than 1000 simultaneous users.

After testing this tool (specially the Beta version of V7), I think that will have a space in my developer set of tools, once the V7 it is in a commercial state.