Tag: SQL

There's no shortage of CMS or "portal" building tools out there. Drupal is one I've come to trust and its feature set is hard to beat. But many require a certain amount of heavy lifting or at least tweaking to get running. Enter Geeklog-- a so-called "portal in a box," or to hear them say it, "The Ultimate Weblog System." I don't know about ultimate, but I will say the installation and ...

Like many web developers, I use MySQL constantly. Sure I can just use the command line, but it is faster to use some kind of graphical client with a decent UI. There are many out there, but my favorite for a while was MySQL's own MySQL Control Center (which has now been discontinued for a while). The replacement for Control Center is Administrator, and I am just not a big fan of it. I loved ...

I just about laughed my butt off reading this. I'll warn you by saying that you need to be a programmer to even "get" the list of language jokes on this page. Of course you will identify with several different languages than I did most likely, but it is a very funny, very enjoyable site to peruse. My non-programmer wife even enjoyed a few of them because some of them are just funny to read aloud. ...

I've never actually heard of SQLyog before (even though it claims to be the "most popular MySQL GUI for the last 4 years"), but its web site is making a big deal out of the fact that this GUI front-end for MySQL is now open source, ergo free, and I certainly won't complain about there being more free MySQL front-ends in the world. To be fair, it's the "Community Edition" that's gone ...

Since getting out of the database business a few years ago, I haven't had to sully myself with things like foreign keys or even SQL for a while. But now that it looks like I'll be building a site using MySQL and PHP, it's back to the db again. Luckily, developer Thomas Mango sent in a tip about his PGnJ app. It's written in Java, and serves as a database manager for PostgreSQL and MySQL databases. ...

Okay, time to really geek out. Declarative languages are really the way to go if you're trying to teach a computer how to solve a puzzle, and though Prolog is the king of the declarative playground, it's equally geeky to do it in SQL, and that's what Samuel Aina did. His article Solving Sudoku with SQL describes what his title suggests: finding the unique solution to a Sudoku puzzle using T-SQL in ...

Yeah, I know, there's a lot of you SQL types out there who just do it all in code. Unfortunately my brain doesn't work that way. Creating database connections from thin air was never my cup of tea, and don't get me started on inner joins. And the worst boss I ever had the pleasure of working with lived in SQLServer all day (maybe that was a personal problem)... But if you're needing a very simple ...