Draw up a Web Database

MySQL & MariaDB (SQL Database)
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)


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)
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)

(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.

Recent Posts
Why Job Sites Are Disappearing? · Apprentice, Journeyman, and Master · List of Docker Registries · Installing Debian 10 buster on virtualbox · Cross platform terminal emulators · Keep active keep happy · Tools to secure your devices · Secrets of the Face and Palm · Vim as an IDE for developers · WordPress multisite on Debian · Mongodb guide to basics · Jagged Alliance 2 some historic notes · Antivirus solutions and why its needed · A taovilla review and history · MacOS X high sierra running out of disk space · Airprint on bonjour missing scan function for all-in-one printers · Improving terminal load times · Knowing website design costs and pitfalls · Keeping secure and checking if your password is safe? · Installing Virtualbox Guest Additions for Debian Stretch · Windows XP Virtualbox on Mac OS X High Sierra · DNS settings and getting on public DNS · 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 (docker-toolbox) · Ubuntu upgrade limited boot space · Top 10 Browsers Overview · Taovilla Oracle app beta built using meteorjs · Setting up Debian on VirtualBox · The HomeBrew doctor · Afterlife Buddhist Chants · Caffeine icon for ubuntu / lubuntu · 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 · Buddhist Chants · Macbook Pro Key mapping for Lubuntu · Common Apache Nginx commands · The nothingness between Zen and Tao · Tao, Zen and Theravada · Meditation for Growth · Buddhism · Refreshing Git versioned files · Basic Environments for Jira · Coffee Shops and Feng Shui · Converting a hg mercurial to git repository · Long term domain name costs comparison · SVG Graphing · 2 ways to Php install on mac · New EBook Launched Secrets of Human Face and Palm · Introducing Samurai and Installing Meteorjs to own server · Improving the speed of Linux Mint · Ma Zu Deity in Malaysia Sabah · 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 · Gemstones · Han Xin the Hero of Han · Gathered Wisdoms · Oriental Calendar · Li Qi Feng Shui · Five Elements Feng Shui · Taoist Philosophy Overview · 25th Anniversary Singapore Taoist Philosophy Group · 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 · Tai Chi and Qi Gong · Pip error in Python with Homebrew · Setting up homebrew for OSX · Personality by Month · Life and Death in Oriental Beliefs · Windows and Linux Desktop Security · Ruan Tou Feng Shui · Life Analysis and Prediction · Cemetery Feng Shui · Taoism · Confucius · Guan Gong · Meditation · Gu Qin · TexMaker with Glossary on Mac · Quick way to OpenStack on Lubuntu · Ancient IT Dictionary · Oriental Poems · Fan Li · IChing · Dao De Jing · 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 ·

© 2024 · mirageglobe · using zenifywp theme by www.mirageglobe.com ·
  · RSS Feed