Which open source database is most recommendable for a solution which requires webhosting? Is there a comparison site?
Ha, this is probably one of the most asked questions on the Internet! The short answer is: Mysql is the most used and postgresql the best.
What is easier to use?
If I use the default sybase for developping my solution, may I transfer it to Postgres SQL afterwards without any trouble?
cookie:
What is easier to use?
Depends what you are used to. In my opinion Postgresql is easier to use but many mysql users will disagree with that.
cookie:
If I use the default sybase for developping my solution, may I transfer it to Postgres SQL afterwards without any trouble?
Yes unless you code custom sql that is not compatible or use datatypes that don’t transfer cross database. In short if you use standard Servoy datatypes and don’t use complex SQL statements it will go cross database with zero recoding.
Yes unless you code custom sql that is not compatible or use datatypes that don’t transfer cross database. In short if you use standard Servoy datatypes and don’t use complex SQL statements it will go cross database with zero recoding.
How is this done? Does Servoy manage all this?
Must there run a servoy instance on the webaccount by my hosting provider?
Hi Cookie,
When you use custom SQL in your methods then you have to see if this works on the database server you are migrating/deploying to.
All other queries done by Servoy self will work out of the box with any other database server that has a JDBC driver for it.
So if you use special database functions, stored procedures, etc in your custom queries that are database specific then you need to recode those queries.
MySQL is notorious for having non standard functions (reason why so many web apps are MySQL-only, or locked-in if you will), PostgreSQL is well known for being more standards compliant.
Hope this helps.
If I choose Postres SQL, what are my further steps?
From what I heard it doesn’t work with my FAT32 so I probably have to find a hosting provider for it. How do I connect my Servoy Developper E. with it?
cookie:
If I choose Postres SQL, what are my further steps?From what I heard it doesn’t work with my FAT32 so I probably have to find a hosting provider for it. How do I connect my Servoy Developper E. with it?
You can install PostgreSQL on FAT32 but it’s strongly adviced against.
Features like tablespace will not work on FAT32, and data integrity cannot be guaranteed in case of a crash.
Why are you using FAT32 instead of NTFS (assuming you use Windows).
As for connecting to external databases like at a hosting provider you simply point your database connection to their IP. They need to allow your IP to connect to the database though. This is a setting in the database server (pg_hba.conf).
Hope this helps.
Features like tablespace will not work on FAT32, and data integrity cannot be guaranteed in case of a crash.
What are Taplespaces?
Why are you using FAT32 instead of NTFS (assuming you use Windows).
Yes, Windows XP. It has been installed that way and I couldn’t change it for some reason.
As for connecting to external databases like at a hosting provider you simply point your database connection to their IP. They need to allow your IP to connect to the database though. This is a setting in the database server (pg_hba.conf).
So this probably won’t work with my ADSL connection, because the IP is changing. How can I solve this?
I don’t think you should discuss the choice of a database system on the shortcomings of your computer’s installation like FAT or NTFS (have you tried convert drive_letter: /fs:ntfs?).
As far as Tablespaces are concerned, just google or look here Tablespace - Wikipedia
So this probably won’t work with my ADSL connection, because the IP is changing. How can I solve this?
Servoy developer needs to connect to a database. If your database is hosted by some provider, it is most likely that this provider has a permanent IP. Your connection is irrelevant. Servoy only wants to know where it can reach the database and doesn’t care about your own IP.
patrick:
Servoy developer needs to connect to a database. If your database is hosted by some provider, it is most likely that this provider has a permanent IP. Your connection is irrelevant. Servoy only wants to know where it can reach the database and doesn’t care about your own IP.
Not entirely true.
Most database servers have built in security that checks what user can connect from what IP.
If your IP is not allowed to connect it won’t even accept your login and password.
So in essence it works like a firewall on the database server level.
If you have a dynamic IP then the provider has to allow the IP block of your provider to connect to the database. The only question is if they are willing to do that.
Why not just use PostgreSQL on your own machine for development and then deploy the solution to the provider that hosts Servoy and PostgreSQL.
FAT or NTFS (have you tried convert drive_letter: /fs:ntfs?).
I’m not that much a tech guy and don’t like to reinstall everything.
Why not just use PostgreSQL on your own machine for development and then deploy the solution to the provider that hosts Servoy and PostgreSQL.
Which hosting providers will also host Servoy and offer good prices?
You don’t need to be a tech guy to do this. Just open a console and type
convert C: /fs:ntfs
That’s not so much to do, is it? Anyway, I think it is easier doing that than finding a database that supports a file system from Windows 95.
Hi cookie,
I have successfull installed Servoy on a www.planetargon.com hosting account with PostgreSQL to run our internal bug database.
From a technical viewpoint it worked fine, but I decided to go down another route for the bug logging in the end. We kept running out database connections (max 10 on cheap accounts) trying to run a website as well as Servoy.
…
That’s not so much to do, is it? Anyway, I think it is easier doing that than finding a database that supports a file system from Windows 95.
Where do I have to do this? I think I have to reinstall every software or not? I won’t develop much by myself anyway. My goal is designing parts of the GUI, which isn’t possible without tables from what I’ve seen.
cookie:
That’s not so much to do, is it? Anyway, I think it is easier doing that than finding a database that supports a file system from Windows 95.
Where do I have to do this? I think I have to reinstall every software or not? I won’t develop much by myself anyway. My goal is designing parts of the GUI, which isn’t possible without tables from what I’ve seen.
I’d recommend Servoy hosting companies. Data Mosaic and DirectICT amongst others offer that (other Servoy hosting companies please post here too). With a Servoy hosting company you can simply upload your app and not worry about os, db, servoy, nothing, it just works.
But it’s expensive.
cookie:
But it’s expensive.
? I don’t understand this comment. Direct ICT offers hosting for as little as 45 Euro per month (less than US$ 60). That’s peanuts for proper hosting. That’s less than one hour of pay to any consultant!