sign in
This article contains information about the Five OpenSource Database Applications.
Title
- What is MySQL?
- What is PostgreSQL?
- What is SQLite?
- What is Oracle?
- What is Firebird?
Introduction
A database or database can be defined as a collection of data that is computerized, organized and stored in one way that facilitates retrieval, so that data can be accessed easily and quickly. The main purpose in data processing on the database itself is so that you can re-determine data (data sought) easily and quickly.
In addition, data utilization for data processing also has a specific purpose. For those of you who are interested in learning computer programmer, of course the selection of database usage or choose what type of database will be used is very important, so @ shareprogramming will try to review five choices of the best open source database application program. which is often used
What is MySQL?
MySQL is an application that can be used to create a database that is open or open source, other than that this application can run on all platforms both Linux and Windows. MySQL itself is a highly accessible database network program that can be used for Multi User application (can be used by many users), MySQL is the most popular application among developers of PHP programming language and widely used for web sites, web applications and other online and services.
What is PostgreSQL?
Another best database application is PostgreSQL, PostgreSQL is a database system application that you can spread and use by all computer users freely under BSD license agreements. This application is one of the most widely used database applications today, in addition to competing with MySQL and Oracle. The PostgreSQL application itself offers a variety of useful features and menus for a creation database. Superior features provided and offered PostgreSQL include DB Mirror, PGPool, Slony, PGCluster and others.
PostgreSQL database system is a database system that is strong enough in terms of data security, this open source database application has experience and application development for more than 15 years and has been proven with all database architecture has got a strong reputation, reliable, data integrity good, and the accuracy of the data is good. PostgreSQL is available for a variety of platforms such as Mac, Windows, Solaris and Linux.
What is SQLite?
SQLite becomes a standalone database that can run on a variety of platforms and hardware, from start up to Apple Macbook. The advantages and advantages of using SQLite is the ability and portability is very minimal inclusion of library files, this application is quite diverse API from SQLite itself and wrapper for each language.
The SQLite application is an embedded SQL database application, which unlike other SQL database applications that require servers for database purposes, SQLite will read and also write files directly on disks complete with tables, triggers, views, and indeces.
The way to create a database in a SQLite application is to use Command Line (CMD) or with GUI (Graphical User Interface) with the help of the Application Management tool, at this time quite a lot of SQLite Management Tools that you can use for free or paid. Here is the SQLite Management Tool in question:
SQLite Manager for Firefox
This application is an Add-ons app for firefox, using Add ons firefox SQLite Manager You can set and also SQLite database database, with simple and easy in making database, table, and also record enough install add on it at following link restart firfox then click Tool then SQLite ManagerSQLite Database Browser
SQLite Database Browser is an open source tool and quite easy to use, besides this application also supports SQL QuerySQLite Administrator
This tool is very powerful with the interface that can be understood by all users so it will be easy in its use.SQLite Studio
This tool has features that are quite reliable, supports sqlite2 and sqlite3SQLite Expert Personal Edition
Tool with an interesting view and very powerful, more details about the features please visit the website
What is Oracle?
This application was developed by Oracle, Berkeley DB provides basic storage services for the applications you create. The Berkeley DB API is available in almost all programming languages including ANSI-C, C ++, Java, C #, Perl, Python, Ruby and Erlang.
A program that accesses free databases to determine how data is stored in records. Berkeley DB does not include note data. The recording and the key can last up to four gigabytes. Note that Berkeley DB is not a full DBMS.
A program that has been created will be able to access the database freely to predict the data will be stored in the record (record). This application can store data and also reports on the database as much as 4 GB
What is Firebird?
Firebird is one of the more complete database applications than features in MySQL, unlike PostgreSQL which can always be run and works well on Windows and Linux and other operating systems like the Nix variant. Firebird provides many features available in commercial databases, including stored procedures, triggers, hot backup (temporary database backup). The Firebird database comes in two variations, classic server and super server.
Some of the capabilities of this open source DBMS include:
Firebird can support transactions similar to other paid database application usage. In a transaction processing Firebird application can be committed or rolled easily. Even Firebird already supports savepoint features on a transaction and you can rollback back to the savepoint you specified earlier (this is similar to the facilities in the Oracle application).
Firebird uses standard syntax to create a foreign key.
Firebird supports line level locks, by default Firebird uses what is called a multi-version concurrency system. This means that all sessions in the database will see the old data to the new data being committed into the database. Alternatives to the locking process can also be used. Select, for, update, with, and lock.
Firebird supports stored procedures as well as triggers with a language that is easy to understand because it is not suitable for those of you who want to learn. Triggers on firebirds like Triggers on Oracle are using before or after insert, update or delete.
Firebird can perform replication process, replication techniques whose purpose is like trigger concept that always monitor the existence of insert operation, update or delete to database.
Firebird support with multiple data files, this will be very useful for DBA (Database Administrator) to administer a database or multiple.
Library connections on Firebird applications already have drivers for ODBC, JDBC and even .NET database providers.
Thus Paseban review on the choice of various best database applications, which may be used as a reference you who want to do the process of making database to build a desktop or web application.
Posted on Utopian.io - Rewarding Open Source Contributors