MySQL
SQL
// Jul 19, 2006 - 21:01
Just a little tip for when designing databases in MySQL.
Do NOT name fields to "read","write" or "delete".
I'm working on a mediabank project where I wan't to set permissions to each user for every object that is being created. The permissions are, as you might figure out, read/write/delete. But MySQL return a 1064 error when executing a query like "select userId from objectaccess where read=1".
I think have to drink more coffee before I start to code the next time.... =)
Ajax
Javascript
POJ
// Jul 18, 2006 - 11:12
In these days of Ajax and Web 2.0 Dion Almaer at Ajaxian has written an article worth thinking about. The article is mainly about the how we use terms as Ajax, claiming that every little cool effect we do with is Ajax even though we doesn't use the XMLHttpRequest object.
My blog uses a fair amount of Ajax but still, most of my Javascript code do other stuff like updating sections, placing elements, handling behaviours and edit posts.
Javascript != Ajax
navigation
css
menus
// Jul 17, 2006 - 20:19
The dudes at eConsultant has put together a list of 71 links to different articles and examples of CSS-based navigation and menus.You'll find drop-down menus, tabs, lists, contextual menus and much more.
I'd say that's more than you'll ever need, period.
Zend IDE
PHP
web development
// Jul 04, 2006 - 11:15
J. Christopher over att Monday By Noon has written an article about Linux and Web Development, a quite nice intro for people being afraid of switching environment.
However, although Linux supposedly should be free and open source I would like to mention the one tool I cannot live without, Zend IDE which is first and foremost an IDE (integrated development environment) for PHP but has alot of features for plain HTML programming as well.
Auto-completion, code templates, debugger (both local and remote) and MySQL support is just some of the features.
If you are serious about web development in Linux and don´t want to learn a zillion keyboard shortcuts in Emacs, Zend IDE is a great tool.
lastRSS
// Jul 03, 2006 - 11:58
I have done some minor updates to the blog.
First a grid view for the Flickr "module" that shows 4 thumbnails at the time in a 2x2 pattern.
Now the document title updates when you navigate through archives, tags etc etc. It should also help the search engines a bit.
In the backend I switched from my own RSS reader to lastRSS simply because it's small and easy to use (and I'm also lazy). At the same time I added the description when reading the RSS feeds.
Oh yeah, did a simple logo too. I'm certainly no AD or anything like that but I think it fits quite nicely.
Detta är min alldeles högst personliga blogg där jag skriver om än det ena än det andra.
