Skip to content
← Back to Community
Database tips
Profile icon
staticvoidliam7

#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 (EDIT) the reason is that MySQL is password protected and encrypted, making it harder to access. SQLite is basically just a file holding the data base and is stored on the disk, as MySQL is a server. So in someways SQLite is secure because its not really connected to the internet. SQLite is good for starting out, but MySQL is worth the setup

any suggestions? just tell me

Voters
Profile icon
chinakit0678
Profile icon
CodeSalvageON
Profile icon
Masum203
Profile icon
wjnb
Profile icon
alondor123
Profile icon
YaqubHasan
Profile icon
JeongyongYang
Profile icon
AcodePy
Profile icon
SqueezyS
Profile icon
EPICGAMERARTIN
Comments
hotnewtop
Profile icon
teymour

Autoescape user input before running it.

Profile icon
staticvoidliam7

this is the best lol @CaptainAnon

Profile icon
AmazingMech2418

@CaptainAnon LOL! SQL injection...

Profile icon
whimperbritish

I put the style for the links INSIDE of the style for the .navigation-bar! Isn't that awesome?! It will only change the style of the links inside of that nav bar.

Say I wanted all links on the page to be white, and not underlined. But on one particular instance, I wanted to add another style. Wouldn't it be awesome if there was an easy way to do that? Think no more because I have it right here: IO Games

Profile icon
teymour

What makes you think MySQL is more secure than SQLite?

Profile icon
staticvoidliam7

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.
@CaptainAnon

Profile icon
teymour

@LiamDonohue I don't think this should be a consideration when writing code for a service, providing you use an ORM. You can start by using SQLite and if that doesn't scale well enough for your needs (because your application becomes popular) you can switch to something like Postgres. I'd argue that being a single file on the disk (rather than a server) means that there is no database server to be hacked (because of poor user configuration, etc.)

Profile icon
AdriaDonohue

LIAM in the HOT?~~~~:D

Profile icon
staticvoidliam7
Profile icon
AdriaDonohue

@LiamDonohue so girls think ur cute ay?lol XD

Profile icon
Navinor
Profile icon
AdriaDonohue
Profile icon
[deleted]

Maybe use better formatting in your posts. E.g-Don't use Headers everywhere, Embolden more important parts of text etc...

Profile icon
staticvoidliam7
Profile icon
[deleted]

@LiamDonohue Sorry if that was harsh lol

Profile icon
staticvoidliam7

no its fine, you had a point @JacksonCowie

Profile icon
MatthewDoan1

That profile GIF... it's... it's mesmerizing!

Profile icon
staticvoidliam7
Profile icon
staticvoidliam7

Join the cult lol @MatthewDoan1

Profile icon
staticvoidliam7

jon @matthewdoan1