News Articles database

Export Query Results to CSV with MySQL Workbench

CSV files are used for everything. Since CSV’s are so common and are a friendly exchange format, everyone understands CSV’s. This is great… Continue reading on Level Up Coding » Source: Level Up Coding

10 Best Courses to learn Oracle with PL/SQL in 2022

Disclosure: This post includes affiliate links; I may receive compensation if you purchase products or services from the different links provided in this article. Hello devs, if you are learning Oracle database and want to learn PL/SQL programming language in 2022 and looking for the best resources like books, online courses, tutorials and articles then […]

🦸 Become a Super Hero by Learning SQL!

Knowing SQL frequently makes me feel like a superhero. And I wouldn’t even say I’m an expert at it. I’m intermediate perhaps. The thing is, everyone uses SQL, but most people remain at a beginner level forever! Most SQL users can do some simple SELECT and INSERT statements and that’s about it. When they need […]

Why You Should Become A Data Engineer And Not A Data Scientist

Photo by on Unsplash Data Science is a career path that many people are currently choosing based on an essay written a decade ago. Yes, it has been almost ten years since the Harvard Business Review essay was published, yet we are all still choosing Data Science as a professional path. However, if you read through […]

MySQL Cheat sheet

Creating tables 📑 CREATE TABLE BookHistory ( Auther VARCHAR(129), title VARCHAR(129), btype VARCHAR(129), year CHAR(4) ); To drop table column ALTER TABLE tableName DROP column-Name; ex. ALTER TABLE BookHistory DROP Auther; How to delete Data from a MySQL table ? // Delete Statement is used to delete data, DELETE FROM table_name WHERE column_name = VALUE […]

ORMs – Active Record & Data Mapper

¿Cuál es la diferencia entre Active Record y Data Mapper? Cuando trabajamos con datos en una aplicación, probablemente necesitemos un ORM (Object Relational Mapping). Un ORM es la capa entre la base de datos y nuestra aplicación. Al usar un ORM, la mayoría del trabajo de crear, actualizar, leer y eliminar de la base de […]

DEMO: Relational Data And Custom Codeless APIs (App Blueprint)

Backendless utilizes relational data models to improve database performance and allow users to recreate real-world relationships. The Shipping and Tracking App Blueprint showcases these capabilities in action, with the help of custom Codeless APIs. App Blueprints are more than just templates from which to build a specific type of application. We design all of our […]

Relational VS Non-Relational Databases

For storing data of application choosing the right database is very important. Sometimes choosing the relational database might seem more natural but sometimes this choice may not be successful. Here I am trying to explain the differences between relational and non-relational databases. Relational Database A relational database organizes data into one or more tables which […]

It's Prisma Time – Create Db

Hi Guys 👋 welcome back. Finally, today it’s time to create our database, so don’t waste time, and get started. How can you create your database? It’s simple! You have to run the following script: npx prisma db push This script creates in your prisma folder a SQLite database called dev.db. The database’s name is […]

Rails 7.0 released… a non-event at Doctolib

Last Wednesday came the release announcement of Rails 7.0. You may have already heard that Rails 7 eliminates the need for NodeJs and Webpack today. Just to save the time spent, during development, waiting for the transpilation of JavaScript codes, this is a huge gift. Security obsessives will retain native encryption of ActiveRecord attributes. This […]

How to use MongoDB locally with VS Code

Recently, a friend asked me if it’s possible to work with their MongoDB databases and Atlas clusters locally without the internet and my answer to that was yes. So, I decided to create a guide to show them how and any other persons who might want to test their collections and perform all kinds of […]

Reinventing the On-Prem Deployment Model

The SaaS software delivery model has completely transformed the industry and for a good reason. It offers an amazing combination of easiness and maintainability that wasn’t possible in the past with older software delivery models. It works amazingly well when we want to deliver software like CRMs, Marketing platforms, etc. Regardless of its success, there […]

It's Prisma Time – Create Table

Hello Folks 👋 and welcome back to this series, today it’s time to create your first table with prisma, are you ready? Then let’s go 💪 Before starting, let me explain which type of tables we are going to create in this series. For this series we are going to create a simple db to […]

Starting a Prisma + TypeScript Project

With such a rich selection of ORMs out there, choosing which one to use for your JavaScript-based project can be tough. Depending on your goals or stack you have a ton available: libraries like TypeORM, Sequelize, and Mongoose, and many more. In this article and throughout the rest of this series we’ll be taking a […]

Data structures in SQL: the definitive guide

Data structures designate different ways of storing data on a computer and form a vital part of any system or database design. The operations that you can perform on these data structures and the instructions you give to execute them, called algorithms, often have their essential functions tailored to the design of the data structure. […]

Cube Cloud Deep Dive: Mastering Pre-Aggregations

With datasets becoming enormous, developers need to find new ways of making data apps fast, responsive, and cost-effective. Pre-aggregations, one of the most powerful features of Cube, simplify this monumental feat significantly. Today, I want to talk about using and managing pre-aggregations with Cube, an open-source API layer for data apps, and Cube Cloud, a […]

How to compute the Betweenness Centrality against Nebula Graph

​Betweenness Centrality (BC for short) reflects the significance of vertices in the entire network. This article will introduce how to compute Betweenness Centrality against Nebula Graph. Relevant Concepts Centrality represents how central a vertex is in the entire network graph, including Degree Centrality, Closeness Centrality, and Betweenness Centrality, etc. Degree Centrality reflects the popularity of […]

How to build AdonisJS API to store your Raspberry Pi Temperature

Introduction I have a few Raspberry Pi devices at home and I wanted to be able to collect the data from their temperature sensors on a regular interval and store that data in a Postgres database. Later on, I could use that data for some analytics together with Materialize. In this tutorial we will use […]

Sitemap | Terms | Privacy | Cookies | Advertising

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.