sorted by: recent | see : popular

Content Tagged with database + technology

Try to guess what this WHERE clause is supposed to do.

Have you heard of Drizzle? As detailed here, it's a lightweight, open source SQL database for the cloud and the web, being designed for massive concurrency on multi-CPU/core architecture. If that sounds a lot like MySQL, it should. Drizzle's code is derived from MySQL--basically a fork of the MySQL 6.0 source code.

For the last 2-3 years, Brian Aker and I have had many discussions about how to refactor MySQL. Brian has been the one driving these discussions by asking why some things in MySQL were done in a certain way and in a true "what if" manner asked what would happen if we would do things in another way.

Today Brian Aker announced a fork of MySQL, called "Drizzle". Drizzle is a slimmed-down MySQL, in a lot of ways what MySQL should have been before MySQL AB became more concerned about their deal with SAP than their core user base.

A new SQL injection hack seems to be out in the wild from verynx.cn. The SQL Injection hack uses a CHAR array to hide its payload which will insert some various html garbage along with a reference to a javascript file on the verynx.cn domain that will infect users when they visit your website. Luckily the domain with the offending javascript file now points to 127.0.0.1 which will help stop the spread of the virus. Unfortunately the botnet still seems to be spamming websites with the scripted attack leaving many entirely broken or loading extremely slow as each page might have hundreds of requests to the payload.

A new SQL injection hack seems to be out in the wild from verynx.cn. The SQL Injection hack uses a CHAR array to hide its payload which will insert some various html garbage along with a reference to a javascript file on the verynx.cn domain that will infect users when they visit your website. Luckily the domain with the offending javascript file now points to 127.0.0.1 which will help stop the spread of the virus. Unfortunately the botnet still seems to be spamming websites with the scripted attack leaving many entirely broken or loading extremely slow as each page might have hundreds of requests to the payload.

The evening plans didn’t wait for talks to be done. The IRC channel (#oscon on irc.freenode.net) was alive with talk of prospects for dinner and drinks after the conference. I myself was torn between a group going out for Lebanese and another going to Henry’s, but opted to go with my buddies from home to Henry’s.

It was worth it. If you haven’t been, Henry’s Tavern boasts 100 beers and hard ciders on tap (oddly, the beer list is the only menu *not* online - guess it changes too frequently). There are a ton of local beers that you can’t even get on the east coast just waiting for you to try, but there are also some rare treats, like the Belgian Lambic beers, which you don’t often see on tap. The food is a little pricey, but is really good, and the staff is very friendly. A couple of us were in a rush to get back by 7 for the BoF sessions, and when we asked the waittress how easy it was to catch a cab, she immediately informed us that she would have the hostess call one for us. About 2 minutes later we were in a cab on our way back (we wouldn’t have made it back in time if we had to walk back to catch the light rail).

I was not one of those rushing to a BoF, so I did a little poking around the area near the convention center. It was getting dark, and I didn’t want to stray too far, but I did find a couple of points of interest. First, there’s a bank right across the street from the convention center. I’d be willing to bet that the ATM there is less than the $3 the ATM inside the center charges.

Beyond that is a paintball place. It was closed by the time I found it, and I don’t know if they run every day, or anything else, but interested parties might find it open during the lunch breaks or something if you wanted to check it out. The paintball place is located behind a building that is directly across the street from the conv. center. If you see the bank, it’s on the other side of the side street the bank sits on.

Tonight appears to be low-key from what I can tell. There’s currently no chatter on irc, the hotel bar had a few people chatting, and I might go down to catch the rush of people as they return from dinner and BoF sessions. Stay tuned tomorrow for more!

addthis_url = 'http%3A%2F%2Fwww.protocolostomy.com%2F2008%2F07%2F21%2Foscon-evening-1-begins-and-more-portland-tips%2F'; addthis_title = 'OSCON+Evening+1+Begins%2C+and+More+Portland+Tips'; addthis_pub = 'jonesy';

You can generate simple bar charts directly from a MySQL prompt. Here is an example.

MySQL 5.1 was in RC stage for around 10 months now finally planned to be released as GA soon. As Monty Says MySQL 5.1.26 will be renamed as GA if no serious bugs are discovered.

When I teach, I frequently discuss temporal based data sets - after all, that's a big piece of what data warehousing and BI is about - Data Over Time. But when examining the database engines ability to "retrieve" specific data sets as a snapshot in time, it seems there is a problem. There appears to be no "consistent" manner in which to retrieve these layers for use by the business.

db4objects offers USD 6000 in prizes for the best patch submissions to make the object database engine "db4o" faster.

SQLite is a very interesting database engine. Its performance, simplicity and that fact it runs as a library (not a server) make it the perfect candidate for small project with few users. Today I experimented with accessing SQLite database from within groovy.

People who are used to relational databases, which is pretty much every gosh-darned web developer out there, will run into pretty much the same obstacles with the app engine datastore - one of them is How the heck do I do SUM or AVG?. This a guide how to do it.

Don't let the old object-relational impedance mismatch get the best of you or your data. Compare ORM tools Hibernate and iBATIS and the Java Persistence API itself, and find out how each one makes it easier to access your RDBMS using Java code.

This article shows how to use the LPAD/RPAD functions to pad the left-side or right-side of a string with a specific set of characters in the Oracle PL/SQL.

For the last couple of weeks I’ve been playing with Google App Engine. In case you’ve been living in a cave for the last month; App Engine is a mostly complete, sandboxed, Python 2.5 environment with a WSGI web server and a very interesting Datastore API.

Rails 2.1 introduces three annoying bugs. Let's fix them.

working with nested sets and zend framework