Databases

How To Create a Database Model in Laravel with Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Create a Database Model in Laravel with Eloquent

Eloquent is an object relational mapper (ORM) included by default within Laravel applications. It facilitates the task of interacting with database tables, providing an object-oriented approach to inserting, updating, and deleting database records, while also providing a streamlined interface for executing SQL queries. In this guide, which is part of a larger Laravel series, you’ll see how to create an Eloquent model for a links landing application.

Read more
How To Insert New Database Records in Laravel Eloquent — step-by-step Programming tutorial on Progressive Robot

How To Insert New Database Records in Laravel Eloquent

In the second part of our Practical Introduction to Laravel Eloquent Series, you’ll learn how to insert records in the database using Eloquent models. One of the biggest advantages of using an ORM system is the ability to manipulate rows in a database table as objects within your codebase. With Eloquent, as with other ORMs, the object itself provides methods that can be used to persist it to the database, saving you the work of writing SQL statements.

Read more
How To Install and Use ClickHouse on Debian 9 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use ClickHouse on Debian 9

ClickHouse is an open-source, column-oriented analytics database created by [Yandex](https://yandex.com) for OLAP and big data use cases. In this tutorial, you’ll install the ClickHouse database server and client on your machine. You’ll use the DBMS for typical tasks and optionally enable remote access from another server so that you’ll be able to connect to the database from another machine.

Read more
How To Install and Use TimescaleDB on Ubuntu 20.04 — step-by-step Linux tutorial on Progressive Robot

How To Install and Use TimescaleDB on Ubuntu 20.04

TimescaleDB is an open-source database optimized for storing time-series data. It is implemented as an extension of PostgreSQL and combines the ease-of-use of relational databases and the speed of NoSQL databases. By following this tutorial, you’ll set up TimescaleDB on Ubuntu 20.04, configure it, and learn how to work with it. You’ll run through creating time-series databases and making simple queries. Finally, you’ll see how to compress data and get rid of unnecessary data.

Read more
CHAT