SQL



Using Laravel with an SQLite database

  • avatar
  • 2.9K Views
  • 3 Likes
  • 5 mins read
Preview post image

The fast-paced world of web development requires selecting tools that balance efficiency and scalability. The choice of a suitable database management system plays a pivotal role. SQLite, a lightweight yet powerful database engine, often remains overlooked. When integrated with Laravel, a popular PHP web application framework, SQLite offers developers a reliable solution for building efficient applications.

How to install MongoDB 6 on Ubuntu 20.04

  • avatar
  • 1.5K Views
  • 2 Likes
  • 6 mins read
Preview post image

MongoDB is a popular open source and document oriented database system. It belongs to a family of databases called NoSQL, which is different from the traditional table based SQL databases. It makes use of collections, each having multiple documents, and allows the user to store data in a non relational format. Data is stored in flexible, JSON-like documents where fields can vary from document to document. That's the reason for calling it schemaless database.

How to install MongoDB 5 on Ubuntu 20.04

  • avatar
  • 1.5K Views
  • 12 Likes
  • 6 mins read
Preview post image

MongoDB is one of the popular open source and document oriented database systems. It belongs to a family of databases called NoSQL, which is different from the traditional table based SQL databases. It makes use of collections, each having multiple documents, and allows the user to store data in a non relational format. Data is stored in flexible, JSON-like documents where fields can vary from document to document.

 Join Our Monthly Newsletter

Get the latest news and popular articles to your inbox every month

We never send SPAM nor unsolicited emails

How to install MySQL 8.0 server on Ubuntu

  • avatar
  • 1.3K Views
  • 1 Like
  • 8 mins read
Preview post image

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of My and SQL the abbreviation for Structured Query Language. A relational database organizes data into one or more data tables in which data types may be related to each other; these relations help structure the data. SQL is a language programmers use to create, modify and extract data from the relational database, as well as control user access to the database.

Allow remote access to MySQL server

  • avatar
  • 1.1K Views
  • 1 Like
  • 6 mins read
Preview post image

Many applications start their web server and database hosted on the same machine. It's simpler, cheaper and easier to manage. However, as our application grows , a setup like this can bring security issues and scalability problems. A common solution is to separate our database from the application: creating a dedicated database server and allowing applications to connect remotely. This setup is more secure, it can provide you a better analysis of the bottlenecks and definitely makes the scalability easier.