Monthly Archive
Creating Simple Ubuntu/Debian Packages
Creating static content Debian package
0 comments
Share our glory:
Occasionally there comes a time when you need to create your own Debian packages. Whether it be for deployment or needing to customize an install to your needs or whatever other reason you may have.
Personally, in my work, I deploy configurations of various sorts to hundreds of Ubuntu systems and have found that automating the creation of debian packages to be very useful. It allows me to track revisions, easily install, or remove the packages that I have made with scripting hooks that are all part of the package. In this example, we are going to construct a static debian package....
Drupal Modules You Need
Episode 1
Share our glory:
One of the best things about Drupal is the number of 3rd party modules available. Just browse over to http://drupal.org/project/Modules and you'll find literally hundreds of modules you can install right now to expand the functionality of the popular CMS. True, the core Drupal install does give you everything you need to start posting content right out of the gate, but it's this outside support that really makes Drupal worth considering.
No matter how you're using Drupal, there are a few modules you'll want to download right away. Over the next few days, we'll talk about three suc...
Drupal Tweak
Da Intro
Share our glory:
When we first decided to start enlightening the nerdlings of the world, we realized pretty quickly that Drupal was the best choice for us. For about a week, we flirted with the idea of just setting up a simple Wordpress blog, but it didn't take long before we figured out it simply didn't fit our needs.
That's not to say Wordpress isn't an outstanding product. On the contrary, I use it for my own personal blog (http://justinstanley.net) and have nothing but great things to say about it in that context. But once you get a few steps past straight-bloggin', WP doesn't cut it.
S...
Oh, Joy! More JOINs!
JOINing Tables in INSERT, UPDATE, and DELETE Queries
Share our glory:
In our last SQL post, we talked about the three basic types of JOINs enterprising young SQL junkies might use to gather data from different tables in their databases.
"Enterprising..." Oh, how I crack myself up some times. Seriously. Don't make me explain why that's funny.
Anyway, in between Star Trek-related examples, we blabbed on and on about INNER JOINs, three kinds of OUTER JOINs, and the almost completely useless CROSS JOIN. You might remember, though, that every one of those brilliant examples involved querying existing data with SELECT statements. T...
JOIN the Dark Side
Share our glory:
When you've been playing around with SQL for awhile, you start to take your knowledge of JOINs for granted. When someone asks you about JOINing data from two or more tables together, you get this stunned look on your face... You know, the same one you get when you actually hear someone mutter the words "I've never seen 'Star Wars'." You forget that you, too, once didn't know a JOIN from a Jedi, and that everyone has to start somewhere.
So let's talk about JOINs. Like the name implies, a JOIN is simply a method for connecting two tables in a database, usually through so...
Simple Mouseover Buttons With CSS
My preferred method of creating mouseover CSS buttons
Share our glory:
I've found that there are a ton of different ways to create mouseover images/navigation/buttons/whatever and every one of them seems to have some sort of limitations. Some work in FireFox but not IE, some flicker real quick when you mouseover and some rely on JavaScript.
I always try to avoid using JavaScript in my navigations since if for some reason a user on your site has JavaScript disabled they can no longer view your navigation. How are they supposed to navigate your site now!? I think I have found a good all around pure CSS mouseover method which works in ever...
Drupal Adsense Injector Module with CCK
Share our glory:
You might notice a rash of Drupal-related posts over the next couple of weeks. Last week, we decided to port the site over to that very popular CMS, mostly because we outgrew WordPress in about 3 days. Don't get me wrong, I love WordPress for straight bloggin', but it's a little limited on the pure CMS side of things. Still would recommend it to anyone who just needs a blog, though (I still use it for my personal stuff).
Anyway, today I installed the AdSense Injector module (Nerd's gotta eat, right?) after reading about it on the Drupal site. We'd previously added some AdSense bl...
Fun With GetSchemaTable
Moving Data From MS SQL 2005 Express Edition to MySQL
Share our glory:
Couple of weeks ago, I was doing some work on a personal Nerdly project on one of my laptops. That particular machine has a copy of SQL Server 2005 Express Edition already installed, and I often use that for my development needs. Has a good number of the same features that the full-blown SQL Server 2005 editions carry, but it's free to use, distribute, etc. Hard to beat that.
Anyway, using Microsoft's SQL is all well and good for most of my work projects, but this personal project is going to live on my webhost's boxes, and my cheap webhosting account doesn't include MS SQL datab...
LIMITed by MySQL?
Getting around LIMIT's percentage limitation
Share our glory:
Noticed in our logs that a pretty significant number of the people hitting this post through their favorite search engines are looking for a way to find the top XX% of results in PostgreSQL or MySQL. Like I mentioned in my other post on the subject, however, neither currently can do that natively.
If you're determined to return a % of rows in your query, you can try using a prepared statement. If I wanted to return 30% of the rows in my NERD table, for instance, I could do something like this...
SSH with no password
Logging into *nix based OS's with no password prompt
Share our glory:
If like me, you have a lot of *nix boxes that you login to from one machine, typing your password over and over can be a pain. Also, if like me, you automate jobs on remote machines, SSH can be a great way to go. However you probably don't want to hang out until 1AM when no one is around to type in the password to execute that job via SSH. It is quite simple to have SSH automatically login for you and run your job, or just log you in so you can work at the console.
I've used this on various *nix platforms and OSX with great success.
The first thing we need to do ...
- Definitely.
2 weeks 1 day ago - A Brief Word About Shared Hosting: No
2 weeks 5 days ago - It ignores them in an
2 weeks 6 days ago - Great Work Dude (:
2 weeks 6 days ago - I hear ya...
3 weeks 51 min ago - IE Specific CSS
3 weeks 13 hours ago - Thanks
4 weeks 15 hours ago - Blocks
5 weeks 1 day ago - I'm using VS 2008 and I'm
7 weeks 5 days ago - Case sensitive
8 weeks 11 hours ago