Draw up a Web Database

MySQL & MariaDB (SQL Database)

https://mariadb.org

mariadb

MySQL and MariaDB are the two most widely installed relational databases. As we know, when running or building an application, you will need to have some sort of storage. Be it games or software, there will need be data to be stored. The common large scale database is MySQL. Personally I do not prefer it, but there are so much applications using this database, its not a bad idea just to get an idea of how to use it. MariaDB is the exact clone of MySQL, but on a more open and permissive license.

In Linux terminal, typing the following command will install mysql.

> sudo apt-get install mysql-server

or to install mariaDB instead

> sudo apt-get install mariadb

follow instructions and enter new password for mysql admin. A good front to access your MySQL installation is phpmyadmin. However before you do that, you will need to install a web server and php support.

Notes: PhpMyAdmin for MySQL

To administer MySQL painlessly, its ideal to install a webfront for MySQL. The most widely used is phpmyadmin. To install make sure you have a http server such as apache, nginex, lighttpd or cherokee. Again in Linux terminal run the following command.

> sudo apt-get install phpmyadmin

 

SQLite (SQL Database)

http://www.sqlite.org/

SQLite a favourite for small Apps and Websites. Now, databases need not be large DBs. There are cloud DBs and NoSQL DB. SQLite I recommend here is based on traditional SQL based commands. The only difference is that its an embedded DB. It doesnt need a server like MySQL.

So what is SQLite? Many languages have it already built in. To get an idea, you can install Mozilla Firefox and download the manager SQLiteManager. All you have to do after you have installed it, is to create a local file. YES, just a local file and that is your database. You can access it via python, java and php.

 

MongoDB (NoSQL Database)

http://www.mongodb.org

mongo

MongoDB (coming from humongus) is a mature and one of the most widely used NoSQL Database. It is also one of my favourites. NoSQL represents Not Only SQL. MongoDB is based on the philosophy of document based databases. This means that the records do not have to be in columns or have connecting IDs (if you compare this to relational databases)

 

CouchDB (NoSQL Database)

http://couchdb.apache.org

(Not only SQL) WebDbs on CouchDB. Apache CouchDB is based on JSON which is a document format data. Meaning this is human readable and easily passed around. CouchDB boasts non-locking or non-blocking architecture which allows concurrency in DB.

 



Top Home mirageglobe




Leave a Reply


Recent Posts
Extracting OVF from VMware ESXI 6.0 · Installing LMDE 2 Betsy · SSL Certificates and Encryption · Machine Learning with Spark · Installing Lubuntu in Virtualbox · Getting started with Docker · Ubuntu upgrade limited boot space · Top 10 Browsers Overview · Taovilla Oracle app beta built using meteorjs · Setting up Debian on VirtualBox · The HomeBrew doctor · Caffeine icon for ubuntu / lubuntu · Updating wordpress without FTP · Updating wordpress without FTP · Preinstalled Languages on mainstream OS · Reminisce of Xcom · Java install on Ubuntu · Display image as ASCII art · VirtualBox Resizing Lubuntu Guest Linux · Introducing Samurai · Macbook Pro Key mapping for Lubuntu · Common Apache Nginx commands · Refreshing Git versioned files · Basic Environments for Jira · Converting a hg mercurial to git repository · Long term domain name costs comparison · SVG Graphing · 2 ways to Php install on mac · Introducing Samurai and Installing Meteorjs to own server · Improving the speed of Linux Mint · SVG graphics with Javascript · FTP Clients for Mac OS X · Windows Apps on Mac · Programming Languages Compared · Hackers Natural Cure · Publishing on Ebooks · Editors such as SublimeText2 · Good Coding Practice · LMDE Linux Mint Debian Edition · Heroku Webapp · Hadoop Single node 32bit on 12.10 Mint XFCE · Tracing User Behaviour FRUBO · Installing Nginx on MacOSX · Installing Ruby on MacOS X · Turn off annoying compress outlook message · HTML5 Apps on Cordova PhoneGap with MacOSX · Choosing and using Latex · Reviewing Javascript World · Draw up an Ubuntu Server Environment · Draw up a Lightweight Mail Server · Draw up a Web Database · Php CMS and Frameworks · Drawing up a Web Service · Draw up a Virtual Cloud Server · Unlocking and Flashing your ZTE Blade · Pip error in Python with Homebrew · HomeBrew for OSX · Windows and Linux Desktop Security · TexMaker with Glossary on Mac · Quick way to OpenStack on Lubuntu · Ancient IT Dictionary · TeaTime for Basic Python · CVs and Jobhunting · Chinese Input on Linux Ubuntu · Research in Computer Science · Reviewing Applications on My Mac · Reviewing Applications on My Windows · Installing Windows XP · Installing wireless on Linux Ubuntu or Mint · Restoring an Amazon EC2 Backup · Mac Update PASV problem · Reviewing Green Computing · Consuming the Cloud Storage Space · Using Cherokee and WordPress Whine · Disabling Lubuntu Screensaver · Installing Lubuntu from USB drive · Searching for a Micro Mini CMS · ReStructuredText in Python · Rackspacecloud Vs Amazon · Hacking your old PSP · Attending Atlanta 55th MMM Conference · Smart devices for everyday use · Creative Programmers · Linux Settings · Embarking on Further Education · Machine Learning · Mac Tips – Viewing hidden files on desktop · Creating PDF files for free · Online Media for All · C# ASP Settings · SVN Git and Mercurial Versioning · Getting the last inserted id using datasets · Think Lucky and be Happy · AngieGallery Design · AceTravel Design · Letter to Mum · Prison Vs Work · Irish Daughter · Are you a carrot, an egg or a coffee bean? · Home Media Entertainment Setup · Collection of Interesting sites · Studying in London · Great Oriental eats in London · CMS Joomla, WordPress, Drupal compared ·

© 2017 · MirageGlobe · using zenifywordpress theme by www.dracoturtur.com ·
  · RSS Feed