background preloader

25+ Alternative & Open Source Database Engines

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

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. chive: A Promising MySQL Manager chive is an open source & web-based MySQL management application that is built with PHP. It can achieve the most common tasks like creating, editing & executing: databasestablesindices, keys, triggers, views, routinesprivileges managementimport/export The application has a built-in editor with syntax-highlighting which is nice when running complex queries & an easy-to-use interface that makes browsing fast. chive has one major fallback (which may pr may not effect you): it only supports MySQL 5+.

Free Geographical Database Of All Countries (Over 8 Million Places): GeoNames GeoNames is a set of free and downloadable geographical databases of all countries which includes over 8 million place names. The data comes in tab-delimited + utf-8 formatted text files and can be downloaded as a whole or per country. Besides the locations of the places/cities/countries, databases include supplementary data like capitals, statistics, timezones and more. GeoNames data can also be reached from their free webservice which can return results in XML and JSON. HeidiSQL - MySQL made easy Fully Ajaxed MySQL Admin – MonoQL MonoQL is a PHP-powered, open source and Ajaxed web application for managing MySQL databases. It has a desktop-like interface -thanks to Ext JS- and can accomplish almost every task you can ask for like database/table design, data browsing/editing, advanced querying & more. The application has support for controlling advanced MySQL features like triggers, stored procedures and views. MonoQL can connect to any number of databases, both local or remote. Also, with the help of a context menu, it display options on every level like running queries, importing data from a CSV file or truncating/deleting a table.

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 Download Query Express Query Express is a simple Query Analyzer look-alike, but being small and free it can be run where the SQL Server client tools are not installed or licensed. This makes it especially useful as a query tool for MSDE and SQL Express. It also connects to Oracle and other OLE-DB compliant databases. Query Express requires no installation and is packaged as a single 100KB executable. Query Express is ideal for those not yet ready for LINQPad. Query Express has a fully permissive free license with no conditions attached. Current version 3.9: last updated November 2007. Download Executable [Right-click, Save As...] Thanks to Klaus Evers for the OLE-DB object browser. Query ExPlus is a branch maintained on SourceForge, with some additional new features. Message: Enter a message Your e-mail address (optional): Invalid e-mail address You must type YES into this box: Type YES here

Data Access Component for SQL Server in C# The attached source code a data access component for SQL Server that contains methods to get a DataSet. Purpose To access SQL SERVER database and execute Stored Procedures. If you need Dataset, you can use GetDataSet method or if you need DataReader use GetDataReader method and so on. How to Use Copy the code below and compile it as DataAccess.csAdd reference of DataAccess.dll from Bin directory to your project.Instantiate DataAccess Class and use its functionality. string SPName= "SP_Search '" + FirstName + " '";string strConnect = "Data Source=ServerName;InitialCatalog=databaseName; UID=yourUserid;PWD=yourPassword" ;DataAccess objdb = new DataAccess(); if you want to bind to the DataGrid with DataReader in ASP.net DataGrid1.DataSource = objdb.GetDataReader(strConn,SPName);DataGrid1.DataBind(); if you want dataset with two dataTables Warning: Be careful creating SPName string. Source Code

Related: