DB



Using Laravel with an SQLite database

  • avatar
  • 6.3K Views
  • 5 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.

Soft Deletes vs Hard Deletes: Making the right choice

  • avatar
  • 4.9K Views
  • 1 Like
  • 3 mins read
Preview post image

In the world of data management, there are often two contrasting approaches to removing information from a database: soft deletes and hard deletes. Both have their pros and cons, and the choice between them can significantly impact how your data is handled. Let's dive into this crucial decision and help you decide which option is best suited to your needs.

Repository cache in Symfony

  • avatar
  • 2.1K Views
  • 11 mins read
Preview post image

In today's data-driven world, efficient data management is paramount for any modern web application. Symfony, a popular PHP framework, provides developers with powerful tools and patterns to streamline data handling. Two key components that play a pivotal role in enhancing data management within Symfony applications are the Repository Pattern and Data Caching. In this article, we'll delve into these concepts, exploring how they work together to boost performance and simplify data access in Symfony projects.

 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 MongoDB 6 on Ubuntu 20.04

  • avatar
  • 2.2K 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.8K 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.

Database server setup: enhancing security and performance

  • avatar
  • 1.2K Views
  • 6 mins read
Preview post image

Setting up a robust database server is a critical step in ensuring the smooth functioning of applications and safeguarding sensitive data. In the realm of cybersecurity and efficient data management, employing good practices can make a significant difference. This article explores the advantages of segregating application and database servers, emphasizing the importance of allowing only authorized connections. Additionally, we'll discuss the use of SSH tunnels to enhance security and weigh the pros and cons of such a system.

Getting started with MongoDB

  • avatar
  • 1.1K Views
  • 6 Likes
  • 11 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.

Connecting to an SQLite database with PHP

  • avatar
  • 135 Views
  • 5 mins read
Preview post image

SQLite is a lightweight, self-contained database engine that doesn't require a separate server to run. It's a popular choice for smaller applications, embedded systems, and situations where simplicity and minimal setup are crucial. In PHP development, SQLite is an excellent option for managing data without needing the complexity of larger database systems. Whether you're working on a small project or need a simple solution for data storage, SQLite can be a powerful tool. This article will guide you through using SQLite with PHP, showing how to set it up, perform common operations, and use it in your applications.