Postgres: How Long does it take to DELETE a large amount of records and VACUUM FULL?
Sometimes there is table bloat on your postgres tables. A large amount of data that is stored that serves no […]
Database, postgres
Database
Database
How to get data from tables in mysql database into a postgres schema?
I’ve had to do a bit of learning and tinkering to figure out how to do this. I now understand […]
Database, DevOps, django
Deploying a django app with dedicated web and db servers
One of the many architectural decisions that will start to impact you when you get to a level where you […]
Database, django, MySQL
Going Live with Django, MySQL on Ubuntu and server going down
Ever got to deploy day only to have errors streaming in about the site not being able to be accesses. […]
SQL
Connecting MySQL Workbench to Server MySQL
Use: GRANT ALL ON *.* to root@’%’ IDENTIFIED BY ‘your-root-password’; Use % as host if you don’t know where user […]
SQL
PHP MySQL Query based on number of results returned
$sql = “SELECT * FROM tbl”; $result = mysql_query($sql); if (mysql_num_rows($result)==0) { //do this } else { //do that }
SQL
MySQL: How to Copy tables into seperate Schemas
To Copy a single table in a Schema into another existing Schema CREATE TABLE myschema.mytbl LIKE myschema2.mytbl; INSERT INTO myschema.mytbl […]
Database, SQL
Create a New MySQL User that only has access to a Particular Schema and Table
Create New MySQl User with Privileges GRANT ALL PRIVILEGES ON dbTest.* To ‘user’@’hostname’ IDENTIFIED BY ‘password’; So for example: Log […]
SQL
MySQL INSERT IF NOT EXISTS: Checking whether a record exists and inserting
MySQL Insert If Not Exists Why doesn’t MySQL Insert If Not exists work????? UPDATE: CHECK AT THE BOTTOM OF POST […]