Database tips
LiamDonohue (168)

#1 Backup weekly

Why? Because something might get corrupted, and you wont lose all your data because guess what? you were smart and backed up you data

#2 Store Your Database on a separate server

I know this may seem difficult, but its actually pretty easy. All you need is a computer running Windows 2000 or later (it actually runs better on an Linux computer, but i could not find any spec requirements for that) and an Apache 2.4 Server

#3 Call any tables containing sensitive data

something random, like Funkybannanasplit

#4 Use MySQL opposed to SQLite

Why? Because MySQL is more secure

any suggestions? just tell me

You are viewing a single comment. View All
LiamDonohue (168)

Both the SQLite and MYSQL have certain advantages. SQLite is file-based — the database consists of a single file on the disk, which makes it extremely portable and reliable. ... MySQL is secured, which makes it highly advanced, too. It can even handle a good amount of data and hence can be used at-scale.