bullwinkle’s how to title titles, or, sqlite in plex for fun and panic
I’ve been going through my entire cartoon library and re-encoding stuff because I’ve done a lot of QA on what looks best for encodes (more on that in another blog… Read more »
Category: Databases
selecting the best bluray audio codec in postgres through sql order by statements
Today’s adventure in coding was to continue to moving Blu-ray support into my DVD ripper software. The next step was getting the priority audio codecs that I wanted when remuxing… Read more »
standardizing on booleans in mysql
Okay, so here’s a question I would normally pose to a mailing list, but since my email setups are so jacked up at the moment, there really isn’t a good… Read more »
mysql ordering by string with possible blank entries
I just found a workaround to something I’ve always preferred to do in SQL. I’m using MySQL 5 at work, and I had a query where I would order the… Read more »
postgres and mysql comparison paper
I’ve been job hunting, and while my dream job would be somewhere that uses PostgreSQL, I am having an extremely hard time finding anyone that uses it. So, I think… Read more »
prepared statements and stored procedures
I’m still working on cleaning up the import scripts for GPNL, and I’m going to have to start using PHP’s PDO database layer to connect to an SQLite3 database at… Read more »
nice mysql vs postgres summary
I was googling for a postgresql image I could use when I found this page, a nice short summary on the differences between MySQL and PostgreSQL with an emphasis on… Read more »
potential postgres schema for lds-scriptures 3.0
Well, that was fast. I looked at the schema last night for the MDP Scriptures project, and started cleaning it up, and it went really quickly. I’ve got a postgres… Read more »
gentoo packages that need lovin’
I mentioned not too long ago that I was working on getting portage details crammed into postgresql, and here is the end result. GPNL is meant to be a QA… Read more »
lds-scriptures postgresql update snapshot
I have not worked on my LDS Scriptures project in a very long time. In fact, annual realeases are becoming an embarrassing reality. However, I’ve been itching to update the… Read more »