Not-Noticeably.net

Skip navigation

All posts tagged with "CMS"

Query squishing

30th April 2008 / 19:03

No comments on "Query squishing"

Tagged: CMS, Geekiness, MySQL, Rambling

Since I wrote this here CMS thingy, I have learned quite a bit about database structure and normalisation and stuff. Therefore, I have been going through my queries and straightening them out. So far I've squished around two thirds of the queries I had, by optimising and generally refining my code. Using INDEXes and JOINs and stuff, oh yes.

...

Yes, my life really is that boring... :P
I haven't had much else to do other than organise my house move (not confirmed yet, lots going on but seemingly nothing happening) and being ill and stuff *yawn*.

"I wrote my own CMS!1!!" - part 2

You may remember my last rant about people who have written their own CMS, in which my point was pretty much that people are copying a simple blog tutorial and saying it's a CMS.

In part two of this thrilling instalment1, I revisit the topic of the custom CMS to rant about the latest craze - which is... well... writing one's own CMS. Everyone and their dog seems to want to do it. It's the thing to do to earn cool points and tell everyone how great you are. I should know, I've done it.

But what I am seeing at the moment is people who have no idea what they're doing. People who simply want to make a CMS because it's cool. When I wrote this CMS, I did it after almost 3 years of being comfortable with the language, knowing exactly what I wanted and what each function does and why. I knew the security implications involved in it, the problems I might experience, the limitations of what I had to work with, etc. I didn't even write my first script until I'd been comfortable with the language for two years. Editing, picking apart other scripts was fine, but my own script? If you ever saw PHPAskIt v1 (it's still out there, worryingly enough) you'll know I wasn't even ready then. However, I'll still admit I only wrote this CMS because I was totally jealous of Jem it was cool. :(

As you may or may not know, I have been learning Ruby on Rails for the past 6 months or so. I am fairly familiar with it at the moment but I am freely able to admit that I am not under any circumstances ready to undertake as large a project as a CMS in it. I don't know how RoR can be exploited, I don't know what sort of problems there are by using X rather than Y - I just don't know enough at the moment. I'm comfortable hacking about existing scripts and adding on little bits and pieces, but that's it.

So my point today is this: before you decide "zomg!1 I must write a CMS!1!!", ask yourself the following questions:

  1. I'm going to be using PHP and MySQL. Do I have enough knowledge in these areas to make my CMS work?
  2. Do I know what the limitations of my server/host/databases are?
  3. Will I have access to PHP4 or 5? What's the difference?
  4. Why am I writing a CMS in the first place? What do I need it to do that others out there can't?
  5. What do I know about security, particularly remote file inclusion, XSS and SQL injection? How will my CMS deal with these areas?
  6. I want my CMS to do X, Y and Z. Do I know how I can achieve this?

If you're unsure of the answers to any of these questions, my advice would be you're not ready yet. Keep looking at existing scripts and see how they're doing things. Search the internet for vulnerabilities in those scripts and how they are exploited to ensure it doesn't happen to you. Get friends to try and break your script as much as they possibly can. I can guarantee that some things normal internet users might do, you'll never think of - for example I found people were trying to go to non-existent tags on my site or page numbers that didn't exist and it caused my site to break.

However, don't think I'm discouraging you from writing a CMS (much :P ). A CMS is the perfect way to develop confidence in a programming language and to learn more about it than you ever could have otherwise. By all means start trying to write your own CMS and learning techniques to make it work the way you want to - but here's the important part: don't put it online. Install yourself a web server (I have XAMPP - very easy to install, has everything you need and installs in a single click. Mac OS X has built-in web server features but you can get XAMPP and other similar packages for it if you're not entirely sure how to use the built-in stuff, I must admit it's always confused me) and develop your up-and-coming CMS there; learn how to interact effectively with MySQL and all that in your own time without hacker types lurking everywhere and undoing all your hard work. I made the mistake of writing the first version of PHPAskIt online and ended up with all sorts of security issues. While I was writing the CMS, it stayed offline for 8 months because I didn't feel it was secure enough to go online - would my host tell me off for too many database queries? Would my PHP version and theirs clash?

Don't think you have to write a CMS just because "everyone else is doing it". You need to feel you can do it and that there is actually a point to doing it. If WordPress or similar does everything you need, is it really necessary? There is no shame whatsoever in using WP. The only reason I stopped using it is because it started to take over my site in ways I really didn't like and I'd modified it so much in the end that every time there was an upgrade I had to update each file individually to make sure it didn't mess with my changes. You also need to make sure you know what you're doing and why you're doing it. If you don't know the slightest bit about PHP, it really isn't worth it.

1 *Cough* ^

Strange search queries

I've never really received many strange search engine queries, but for some reason I've started receiving loads in the last few weeks...

  1. who wrote my way
    Um, I have no idea where I have talked about that.
  2. my shift key is permanently stuck what do i do
    Unstick it?
  3. how do i hack ask&answer
    Answer: easily
  4. "disk error" ctrl alt del for reboot
    ...CTRL ALT DEL won't solve a problem if it's a disk error...
  5. how do i write my own cms
    With difficulty
  6. why did the weasel go pop?
    Because it did?
  7. things you never knew about music
    What can you never know about music...?

There are loads more but I can't be bothered to list them all :P

Ooh yay, my CMS is a year old! Ok, so not in its current state, but a year ago around this time (I made the first entry in the database on 28th July 2006, but that was after I'd done a few days' coding) is when I started work on it. Woooo

Edit on 29th July: Wow, they keep coming! Here are a few more from today:

  1. do the keys on my laptop come off
    Well how do you think people put them on if they don't come off?
  2. phone number on net culprit
    ...what
  3. hello may i speak with the owner
    No. Go away.
  4. how to use cutenews
    How about reading the Readme file?
  5. my php scripts they are rubbish yes
    LMAO.

Older Entries