-
In my code ramblings during the developement of Code Zauker, I ended up studing a bit NoSql database.
Code zauker started using Redis, because Redis is a very bold memory-based no-sql db. Redis also support complex data type like sorted set, lists and so on, which was very userful. Anyway I needed a very fast way of doing statistics on data collected by code zauker, for inspecting data and finding out new feature I’d like to add to it. Worst, my current pocket pose a hard limit on a redis instance in terms of available RAM. So I started thinking a lot about a redis drop-in replacement for Code Zauker.
Read More -
Dapper is a single file you can drop in to your project that will extend your IDbConnection interface. [...]
A key feature of Dapper is performance. The following metrics show how long it takes to execute 500 SELECT statements against a DB and map the data returned to objects.
Read More -
At Gioorgi.com we was never a SQL fan. In 2000 we thinked SQL was boring, mostly because sql algebra could be a bit boring. Then we found this book written by one of the father of SQL. Years ago Google and then Facebook popped out with new incredible ideas, for improved and super fast scalability, which eventually turned to the “NoSQL” mantra.
But NoSQL is a mature technology, or it is only a path traced by the Social company out of there? Let’s explore together…
Read More -
If you're trying to use MySQL with phpMyAdmin, you've set up the phpMyAdmin's config.inc.php, and you're getting an error saying "Client does not support authentication protocol requested by server; consider upgrading MySQL client", you need to set the password on the mysql command line using the OLD_PASSWORD('password') routine.
For example:
Read More -
Slashdot underlines there are too much forks of MySQL on the way.
After leaving MySQL, Michael “Monty” Widenius started its own code fork, backed up with a company.
The nerds think the destiny of MySQL is unclear, but it is still too early to get a clear vision.
Read More -
-
NB: Questo è la storia super rapida dei database relazionali, e non è ancora completata. L’idea è di confrontare la storia del modello E-R con quello dello sviluppo OOP, evidenziando simmetrie e differenze
Read More -
After a bit of work, I have managed to optimize the performance of my Postgresql Server.
I have spent a saturday morning digging around postgresql, using the fantastic komodo editor, and I am happy with the final solution.
I followed some suggestion on power PostgreSQL site, and now my postgres is blazing fast. For small needs, tuning postgres is easy as working with MySql. And with postgres you get for free Transaction and PL/SQL without the need to do extra configuration or tuning or your database.
Read More