Caleb Cushing's Blog

Some Stack Exchange site’s I’d like to see come to fruition

Unix & Linux: I think it’d be more used than Super User and ServerFault for some questions.Outer Join: A place to ask questions about databases and queriesUser Interface: because this is something we could all do better with. Please consider following/committing. esp the unix/linux one (since I don’t think Ubuntu should get to have its own, while leaving the rest of us in the cold.)– This work by Caleb Cushing is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 3. Read more →

Difference Between a Database and a Database Instance

I was prowling StackOverflow today and the question was asked when you would use 2 databases. I’m amazed at the number of answers of replication and sharding (some under the guise of some other description). The only answer I can think of to be correct is Different Applications/Services (shared hosting probably falls under those 2 in a weird way). I’m going to explain why a replicated database and/or a sharded database are not multiple databases. Read more →

PostgreSQL initial setup (authentication)

If you followed my last initial setup post on creating users and are running a default install of postgres you currently should be able to access the database on your cli. However, many distributions do not install postgres in a default manner. A great many distributions make the default authentication for sockets ident sameuser. This is technically much more secure than trust which is the default. However, you may find yourself locked out of your database on the local cli if you make the database name different. Read more →