background preloader

HeidiSQL - MySQL made easy

HeidiSQL - MySQL made easy

25+ Alternative & Open Source Database Engines Almost every web developer has a favorite database that he/she feels comfortable working with as all the tricks & gimmicks are already experienced. It can be one of the popular databases below: or even simpler ones like XML, text, etc. It is understandable why these databases are frequently used; they are well-documented, have a community behind them, integrated with most popular CMSs', easy-to-use, offered by most of the hosting companies ,etc.. But there are also many other databases which are getting popular day-by-day & may have advantages over what you're already using. Here are 25+ open source alternative databases that you may consider using in your next project: MongoDB It is an open source, high-performance, scalable, schema-free & document-oriented (JSON-like data schemas) database. There are ready to use drivers for most popular programming languages like PHP,Python, Perl, Ruby, JavaScript, C++ + more. Hypertable Apache CouchDB Neo4j Neo4j offer a massive scalability. Riak Memcached Redis

DimitriK's (dim) Weblog : May 2010 MySQL Performance: Using Performance Schema Two weeks ago I was very lucky to meet in Paris Marc Allf (one of developers of MySQL Performance Schema) and get all details about Performance Schema directly from the source :-) I would say I'm very excited about this feature giving so enormous potential to observe any activity inside of MySQL, as well by a great flexibility of the proposed solution! :-) However, discussing with Marc and going over a day more and more in depth, I've got some remarks that I needed to group, summarize and then express (and vacation time helping here a lot ;-)) My points will not be about adding some new extensions, but rather fixing some core issues which I consider important (and, please, correct me if you're not agree, express your ideas, etc - it's one of the cases where a quantity of opinions will be easily transformed into the quality solution for sure :-)) Performance Impact Following cases were tested as a start point: Read-Only: As you can see: Read+Write:

DALMP Oracle Berkeley DB Java Edition | Gokhan Atil's Oracle Blog I was searching NoSQL databases and see that Oracle provides a NoSQL database called Berkeley DB. I examined it and wrote a blog to give quick tips to start Java Edition of Berkeley DB. This blog was published in Turkish, about 1 year ago. Berkeley DB is a high-performance embedded database originated at the University of California, Berkeley. There are three versions of Berkeley DB: Berkeley DB (the traditional database, written in C)Berkeley DB Java Edition (native Java version)Berkeley DB XML (for storing XML documents) As a hobbyist Java programmer, I prefer Berkeley DB Java Edition (JE). Berkeley DB JE provides two interfaces: Traditional Berkeley DB API (with DB data abstraction of key/value pairs)Direct Persistence Layer (DPL) which contains “Plain Old Java Objects” (POJO) Because I’m an old-school (ex)programmer, I’ll show how to use the traditional Berkeley DB API. Let’s start by downloading the Berkeley DB from Oracle website: Berkeley DB stored the datafiles in a folder.

Spoken on Google App Engine at a conference in UET Today I had delivered a workshop on Developing Java Web Applications In Google App Engine. This workshop was the part of events of 3rd International Conference on Open Source Systems and Technologies. It was organized by Al-Khawarizmi Institute of Computer Science , University of Engineering and Technology, Lahore. I have presented following slides there. Also coded a basic sample application to show how to create and deploy new Java project on GAE. Comments and feedback is welcomed on the presentation material from you guys. Web-Based Multiple MySQL Manager – AeroSQL AeroSQL is an open source web application, for managing MySQL databases. It can control databases from different servers in a single, desktop-like interface where records can be easily browsed or edited within a grid. The application displays every query executed & can run a batch of sql queries to save you time. It is possible to select the columns to be displayed while editing a table which will help reaching the data in an organized way. AeroSQL is built with PHP & uses ExtJS to provide the desktop-like functionality.

Tuning MySQL Performance with MySQLTuner Version 1.0 Author: Falko Timme <ft [at] falkotimme [dot] com> Last edited 08/28/2008 MySQLTuner is a Perl script that analyzes your MySQL performance and, based on the statistics it gathers, gives recommendations which variables you should adjust in order to increase performance. That way, you can tune your my.cnf file to tease out the last bit of performance from your MySQL server and make it work more efficiently. This document comes without warranty of any kind! 1 Using MySQLTuner You can download the MySQLTuner script as follows: wget In order to run it, we must make it executable: chmod +x mysqltuner.pl Afterwards, we can run it. . server1:~# . -------- Storage Engine Statistics ------------------------------------------- [--] Status: +Archive -BDB -Federated +InnoDB +ISAM -NDBCluster [--] Data in MyISAM tables: 301M (Tables: 2074) [--] Data in HEAP tables: 379K (Tables: 9) [!!] server1:~# 2 Links

conancat/mongoose-redis-cache Séparer lecture et écriture pour optimiser HP Labs scinde les bases en deux versions : une première analyse les informations en temps réel pour trouver des données récentes. L'autre réalise des copies de la base à intervalles réguliers pour la recherche d'archives A un moment où le nombre d'informations disponibles ne cesse de croître, les bases de données utilisées actuellement en entreprise deviennent complexes d'utilisation. Cela notamment du fait de l'incompatibilité entre recherche et mise à jour permanente. Un choix entre exhaustivité et rapidité Il peut soit effectuer une recherche exhaustive au sein de la version temps réel, qui prendra en compte même les mises à jour récentes. Une méthode plus rapide, mais inadaptée à une gestion temps réel Mais le processus de recherche prendra plus de temps.

The ServerSide Interoperability Blog » Samba Learning Guide By George Lawton Samba is open-source software that allows a wide variety of computers to act as if they were a Windows file and print server. It is not exactly the center of the universe for coverage on TheServerSide.NET, but we thought it was worth a look. Samba recently made the newscasts, as its technical stewards were among key litigants involved in Microsoft’s widely heralded European Union anti-trust case. Samba currently runs on UNIX, Linux, IBM System 390, OpenVMS, and other operating systems. Learning/Tutorial/Overview/BackgroundIntroduction to Samba (The Samba Team) Explains the basics of how the two key programs smbd and nmbd provide 1) File & print services; 2) Authentication and Authorization; 3) Name resolution and 4) Service announcement (browsing) to Windows and Unix clients and servers. The Official Samba 3.2.x HOWTO and Reference Guide (The Samba Team) Everything you ever wanted to know about setting up and managing Samba services within your network. Dr. Tips News

Instant SQL Formatter Plugin for Notepad++UltraEditeclipse1.1KShare Instant SQL Formatter (Ver4.0.2 Updated: 09-19-2014) Database Output: Enter your sql code here... Short Video 1 Short Video 2 After Before Before with space Stacked Not Stacked Align left Align right And/Or under Where Remove Linebreak before beautify Trim Quoted Char of Each Line quoted char of eachline: Compact the output of sql output Rails SQL Optimization In order to automate the optimization of SQL queries in Ruby on Rails, I wrote this script to parse the output of the logs. It finds all the unique SQL queries made by different controllers, and runs an SQL EXPLAIN for each. This is really good for finding missing indexes and large table scans. I have only tested this on Mac/MySQL, so your mileage may vary (it uses *NIX file paths). This script has saved me MUCH time. Just run this script within your Rails application root directory, and it will create a file named explained.html. Oh, and there needs to be at least 2 pageloads in your log. So here is the script. UPDATE: I came across some good tips for additional optimization here.

Related: