So this is mainly aimed at anyone who's owned a server and knew what they were doing. I'm working on mine, and I don't know which way to go. For now it'll be a locally hosted server, and hopefully running 18 hours of the day. I have over 30 plugins I'm looking at, including database intensive ones like towny, iconomy, and hawkeye. So can someone give me a brief explanation of mysql/sqlite/flatfile (i only know the most basic of the basics), and then maybe suggest which I should go with?
On shadecrest, we use MySQL for everything. Mainly because its a centralised place to store the data that can be accessed and modified from anywhere easily. MySQL is relatively efficient, flatfiles can become very slow the larger they become. SQLite is probably the most efficient, but I havent had much dealings with it. My recommendation would be to use MySQL.
Even if I'm just running it on my pc? Like I'm pretty sure it creates a server that then runs the databases. Would that be the best way to set it up?