Briggs Softworks

This is a really critical feature, inclusion of say an option to have a sql database at a different site would allow multiple servers to run on the same information, adding scalability. An external db would be more secure and faster, as the current pmaven's textfile-based system is only as secure as the folder its in and limited by read/write speed of the server it's on. Which do you think is faster and more secure? A windows dedicated server or amazon's specialized RDS? Also why torture developers and yourself with having to deal with a txt-based system? There's a library for sql in practically every language.

torba wrote:This is a really critical feature, inclusion of say an option to have a sql database at a different site would allow multiple servers to run on the same information, adding scalability. An external db would be more secure and faster, as the current pmaven's textfile-based system is only as secure as the folder its in and limited by read/write speed of the server it's on. Which do you think is faster and more secure? A windows dedicated server or amazon's specialized RDS? Also why torture developers and yourself with having to deal with a txt-based system? There's a library for sql in practically every language.

I do have plans to go with SQL, but it will be more for reporting purposes, not for performance. Multi-server scaling is complicated, though. The current single-server system is doing everything in memory and thus is already about as fast as it can be. The data files are only read once at startup and only written to as live data changes, after the fact.