Thorazine 10mg Online

Posts in the "Databases" Category

  • mysqlind_qc: Client Side Caching for MySQL extensions for PHP

    Here’s something in the making, a PHP extension which caches MySQL queries irrespective of the extension being used. It’s a plugin for mysqlind, the native MySQL driver for PHP called mysqlind_qc. This currently requires PHP 5.3.3-dev which is still in development.

    Read More...
  • I’ve always wanted to know how the various opensource search engines performed when running head to head with each other. I’ve personally not had the time nor patience to setup such a benchmark. Luckily Vik Singh has done just that and blogged the results of the benchmark. He’s benchmarked the latest versions of Lucene, sqlite, […]

    Read More...
  • Generate data for Database testing

    Image by lilit via Flickr How often have you tested your application on your local machine and had it run properly, but when you deploy it and the database starts getting filled up, you start noticing performance problems? Here’s something you can use to test out your application with databases which are not empty – […]

    Read More...
  • An interesting article I came across today by Johannes Schlüter, who works in the one of the MySQL teams in Sun. He’s done some interesting work writing a MySQL Storage Engine using PHP. His article shows how to do some basic using this. MySQL 5.1 has a plugin interface to easily add storage engines. PHP […]

    Read More...
  • Scrawlr – Scanner for SQL Injection

    Scrawlr is short for SQL Injector and Crawler, a tool developed by the HP Web Security Research Group in coordination with the Microsoft Security Response Center in response to the widespread SQL injection attacks on the web. “Scrawlr will crawl a website while simultaneously analyzing the parameters of each individual web page for SQL Injection […]

    Read More...
  • MySQL Error: 1062 Duplicate entry ’0′ for key 1

    Here’s a problem we had come across today. Whenever we tried inserting data into a certain table, MySQL kept throwing up the following error: mySQL error: 1062 Duplicate entry ’0′ for key 1 After scratching our heads over this one, we tried to alter the table to set the autoincrement field to the next number […]

    Read More...
  • MySQL Tip – Ordering by Date stored in a varchar field

    How do you sort a varchar field which has the dates stored in it? If you try the usual order by on the varchar fields you’ll have trouble with the sort order, since MySQL will order this field like a varchar and you will surely have problems with dates being sorted this way. Take the […]

    Read More...
  • Stumbled across this interesting article at Leo Büttiker’s blog which tells why pagination on a web app is a database killer: On the view of your database the worst thing you can do in your web app is paging. Paging is horrible in the view of performance. To explain let me take a little example: […]

    Read More...
  • Last week I’d finally decided to move off from Windows on my work laptop. After the default installation off the 64 bit CD, here were some of the problems I found: The default Wireless drivers didn’t seem to work at all. The 64 bit version of the OS seemed to lack some of the softwares […]

    Read More...
  • Amazon’s S3 service seems to be getting into everything ‘online’ these days. Here’s an announcement by Mark Atwood of a S3 storage engine for MySQL 5. It allows one to view and manipulate Amazon’s S3 storage service as tables and items by MySQL. You can keep your blobs or large varchars or truely huge datasets […]

    Read More...