PureBasic Forums - English

Hi and thanks for any help in advance!

I started a database app for work using sqlite which was all well and good but soon realised that it would make far more sense that the database be hosted on a domain so could be accessed from anywhere that has my front end installed!

That left me wth a couple of choices:

PostgreSQL:- Got this work under WAMP but then I have done a search and see that NO web hosting companies provide this!

MySQL:- Have not got this to work but this has two problems for me;
1) Have had trouble getting it set up!
2) The simplest connection is Via OBDC but I understand this may pose problems when other users install my front end??
3) Talking to it usinf libsmsql.dll seem very top heavy and complicated and there are no wrappers???

Any ideas anyone before I actually go insane!

Nexus100,

You might be able to stay with SQLite. I wrote an "In/Out" status board for my company using PB and SQLite.
Each employee can mark himself in/out/at lunch/sick/vacation, etc., as well as send and receive chat messages to other employees.

The database is on a server, and each employee has the PB program installed on his PC.
Each program queries the database periodically to update the status board and check for any chat messages.
Even when working from home, the database can be accessed via a VPN connection.

There are only about 11 people using the database simultaneously.
If you need many more users, SQLite might not be suitable, but it works fine for this application.

Regards,
Eric

Nexus100 wrote: NO web hosting companies provide this!

No matter which Database you use, most webhosters deny external access to the database, so you can only access these databases from their webserver. I think it could be hard to convice them to run your program on their servers

DarkPlayer

Check your settings on your webserver, it is possible that you have to register your ip for external access to your database.

Henrik.

Darkplayer is right and with good reason. Put yourself in the server admins shoes. If you got this to work under WAMP using Postgre, seems to me that you're half way there. Why not just keep going with that idea? Just run your own server and write all the exe's you want in any language you want and use any database you want.