Skip to Content

Free TUAW iPhone app -- try it now!
AOL Tech

sql posts

Filed under: Developer, Linux, Blogging, Freeware

Want a portal? Just add Geeklog

geeklog weblog toolThere'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 configuration process is pretty darn simple. The most cumbersome aspect will be creating a SQL database (wish I had a nickel for every time I've said that). After you've got your database mojo, it's a straight shot to unpack and install and start working.

Geeklog is no slouch in the added functions, as there are apparently a large number of plugins and add-ons. It's not all sunshine and roses, as there are limited templates and the usual quirks and gotchas. Linux.com has an excellent review, and brief guide to getting started. Geeklog might not be everything you've been looking for, but if you want something quick and dirty (and at some point, don't we all?), it might be a good fit. I should mention they're working to improve the tool by using bounties: a small sum paid to developers (courtesy of sponsor AOE media GmbH) for implementing user-requested features. So with any luck, Geeklog will flourish in the coming months.

[thank Dolores for sending this in!]

Filed under: Business, Developer, Utilities, Windows, Macintosh, Linux, Freeware

Oracle's Free SQL Developer upgrade


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 Control Center because it allowed query browsing and database management, and you'd be hard-pressed to find both features in Administrator which is why I don't like it as much. There are third-party alternatives as well, many of which are not free, which is a sticking point for me? Why, because I am cheap. I currently use (and love) SQLyog community edition (free and full-featured).

Oracle also has a SQL development client, called SQL Developer (oddly enough). They just upgraded it in fact. Now it does easy import and export data in many popular formats. Not retyping all that data, priceless. Oracle's client will manage MySQL, SQL, and Oracle databases, which is rare to find a free tool that handles all three.

I will stick to SQLyog for my database management needs however, since Oracle's java-based solution needs to be configured to work with MySQL's JDBC drivers apparently. Often I don't have the time to install third party drivers, and configure them, that is what a client should be responsible for. Ease of use, and dummy-proofing your app, even more priceless.

Filed under: Developer, Fun, Internet

How-to: Shoot yourself in the foot, programmatically

Shoot yourself in the footI 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. Don't know what I'm talking about? That's why you have to visit the site, you'll get it. A bit of well-placed programming humor, don't you think?

Filed under: Developer, Windows, Open Source

SQLyog: Open source MySQL manager for Windows

SQLyog
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 OSS--Enterprise will still cost you--but it does tout a solid feature set, including a favorites manager, a tabbed query/result set editor, SQL templates, export to CSV/XML/HTML, user management, and more. With the recent death of MySQL-Front, SQLyog is a very welcome addition to the open source family.

Filed under: Business, Developer, Macintosh, Freeware

PGnJ - PostgreSQL & MySQL Database Management Application

pgnj database managerSince 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. Even better, everything is in one unified interface, with tables, fields, and data all in one place. This is also one of the only tools I know of for this job, in OS X, that'll do it for free. Thanks Thomas!

Filed under: Developer, Fun

Solving Sudoku with SQL

Solving Sudoku in SQLOkay, 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 SQL Server 2000. While the code isn't short (compare to, e.g., Chris Neukirchen's Prolog version), it's very clear and well-commented and really shows off the power of declarative programming.

[Via Digg]

Filed under: Business, Developer, Finance, Utilities, Windows, Macintosh, Linux, Office, Commercial, Freeware

Free SQL front-end: SQL Uniform Lite 1.7

sqlliteYeah, 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 connection and table retreiver front-end you might want to check out SQL Uniform Lite. It's free, and the Pro edition is still only $69 USD.

Unlike Crystal Lite, which is for drinking, SQL Uniform Lite is really only for reading and connecting. Using Java the app can be run on Windows, Linux, Unix, Mac OS, OS2 and Solaris. Where it really shines is the fact that it can connect to more than 20 types of databases. Obviously there's the ODBC and JDBC drivers available, but it's been tested on everything from Oracle to an Excel file. Check out the Winked-flash video here. Not bad for free, and with the pro tool letting you make, query, etc. your databases the whole enchilada is pretty compelling.

Featured Time Waster

Graveyard Shift - zombie-busting Time Waster

With Halloween fast approaching, it's a great time to get in some practice defending your territory against zombies. In Graveyard Shift, you take aim at zombies and other creepy-crawlies, blasting them into splatters of cartoony green guts. It's a casual first-person shooter, and it's very easy to get the hang of - use the mouse to aim, click to fire. Graveyard Shift has at least 15 levels, and it might even have some secret stages I haven't unlocked yet. They key to getting good at Graveyard Shift is learning to use ...

View more Time Wasters

Featured Galleries

Defective by Design, London: Protest Pictures
Microsoft Security Essentials
Chromium Pre-Alpha on CrunchBang Linux
Safari 4 Beta
10 Firefox themes that don't suck
IE8 RC1
Download Squad at the Crunchies After-Party
Download Squad at the Crunchies
WordPress 2.7
Cooking Mama: Mama Kills Animals
Windows 7 Hands On
Comodo Internet Security
Android First-look: Amazon.com MP3 Store
Android First-look: Twitroid
Google Reader Android
Android Hands-On
Twine 1.0
Photoshop Express Beta
Mozilla Birthday Cake
Palm stuff
Adobe Lightroom 1.1

 


Follow us on Twitter!

Flickr Pool

www.flickr.com

More Tech Coverage

AOL Radio

Joystiq

TUAW

Daily Finance

Autoblog

Urlesque

Engadget

WoW

Switched.com

FanHouse