-
Recent Posts
Tags
app engines attributes cgi database DBI Debian frameworks full screen terminal GWT hacks hardware hobbit howto html inheritance javascript jQuery libraries Linux mac oracle OSX parallels Perl photoshop pixels PostgreSQL programming qa regression testing screen size Software Development style template toolkit term Theory translation type cast User Interface virtual machine virtual machines visual studio vmware web design web programming
Tag Archives: database
using explain to inteligently create indecies in PostgreSQL
I often write these blog posts as much so I will remember a technique as to tell the world about it. I can’t take any credit for this one, had to have it explained (no pun intended) to me. So… let’s say you have a query: select foo from table1 where bar = 'some value' [...]
Simple Postgres Type Cast
I recently did a select similar to the following, where a subquery grabs some ids, and then a main query uses them: select * from attributes where id in ( select id from documents where owner = 'sam' ); But I got the following error: ERROR: operator does not exist: integer = text HINT: No [...]
Preventing Hair Loss w/ Database Transactions
Warning, this is fairly rudimentary, but useful all the same. Have you ever sat down at a database prompt to update 1 value, typed the query, hit enter, and gotten back “4000 Entries Updated”. It’s fun, a good way to shorten your life, and loose all your hair. What you can do, at least in [...]
Authentication and Postgres
For a given web app, the database and web server may reside on the same machine. Apache runs as webserver-user (or similar) and connects on a local socket to postgres. Postgres on my machine, is not configured to listen on any ports, rather it is configured to authenticate by ‘ident sameuser’ on local sockets. Therefore, [...]
Setting up Oracle Express On A Mac Using Debian and VMWare Fusion