name your tables and views in lower case

Got something cool to share with AppGini users? Feel free to post it here!
Post Reply
User avatar
onoehring
AppGini Super Hero
AppGini Super Hero
Posts: 1156
Joined: 2019-05-21 22:42
Location: Germany
Contact:

name your tables and views in lower case

Post by onoehring » 2019-09-29 13:09

Hi,

I place this here in the tips-section as it cost me quite some time and work to correct "nice" tablenames.
My testserver is a Linux system. I have exported everything and it's running on a windows server now - no problem. But when I tried the other way around, getting the "live"-system back to my test-setting I had quite a lot of problems, all of those because of case sensitivity of Linux (and thus: MySQL tablenames!)

For this I strongly suggest,
-> that you name your tables with lowercase only !
-> that you name your views in the database with lowercase only (as you might later create a pseudo-table in AppGini with that same name)!

Example: Not like this: My_Table . But like this: my_table.

Take care and hopefully do not repeat my mistake
Olaf

Post Reply