Posted on

Building an E-Commerce API Using Nestjs, SQLite, and TypeORM

Introduction

Nestjs is a cutting-edge Node.js framework for developing server-side applications that are efficient, dependable, and scalable. It is simple to integrate with NoSQL and SQL databases such as MongoDB, Yugabyte, SQLite, Postgres, MySQL, and others. It supports popular object-relational mappers such as TypeORM Sequelize and Mongoose.

In this tutorial, we'll create an e-commerce application with SQLite and TypeORM. We'll also look at Arctype, a powerful SQL client and database management tool.

Posted on

Building a REST API With Feathers.js and SQLite

Looking for a way to build a web application with features like authentication, database setup, and authorization without writing a ton of code and configurations? Ever wanted to create a production-ready app in a matter of days?

Believe it or not, it's possible! This tutorial will show you how to use Feathers.js to create a REST API in minutes. We'll learn about Feathers.js, implement an example API, and share some thoughts and considerations. Let's begin.

Posted on

Building an Application With Go and SQLite

Today we're going to learn how to use SQLite with Go. By the time you finish this tutorial, you can easily build CRUD (Create Read Update Delete) applications with Go.

Go is one of the hottest languages in development right now, known for its simple structure and blazing performance. SQLite has been trending among developers for its ability to host small data very quickly, safely, and contained in a single file.

Posted on

Building Offline-First Apps With Node.js and SQLite

"Offline first" is an application development paradigm in which developers ensure that an app's functionality is unaffected by a temporary loss of network connectivity. Progressive web applications, which feel like native applications but run like web applications, are often built on this paradigm.

This tutorial will teach you how to build an offline-first application with Node.js and a SQLite database. Let's start with an introduction to progressive web apps.

Introduction to PWA

Progressive Web Apps (PWAs) are web apps that use service workers, manifests, and other web-platform features and progressive enhancement to provide users with an experience comparable to native apps.

Posted on

Analyzing iMessage With SQL

SQLite is an often overlooked flavor of SQL engines. Some have suggested it is the most prolific SQL engine in existence due to its highly flexible nature and ability to run on almost any platform with limited resources. Unlike other SQL engines like MySQL, PostgreSQL, MSSQL, or Oracle, SQLite runs without a server. SQLite does not rely on a data directory or a constantly running daemon: a database is encapsulated in a single file.

SQLite and iMessage

iMessage is one of the most popular messaging platforms today, largely because it is built into iOS and Mac devices. Since its release, it has evolved significantly. But, at its core, it is simply an instant messaging platform. iMessage uses SQLite in the background to store relational data about messages, conversations, and their participants.

Posted on

Querying Pull Request Data from GitHub

To make sure that bugs do not reach the end-user of your product, you need to do code reviews. In code review, metrics of pull requests matter a lot because they provide data on how well you are shipping. Software developers can use pull requests metrics to understand the team dynamics and act appropriately to correct behaviors before things get out of hand.

What Is Code Review?

Code review is when a peer or a senior developer examines a developer's code or a pull request. Code reviews help developers discover common bugs faster and reduce the work required to optimize code later.

Posted on

How To Persist and Query Data With SQLite in Flutter App Development

Persisting and querying a large amount of data on the local device is important to make a highly performant Flutter application. This data must remain intact in each app session. Hence, you need to have an advanced database management system to locally store your more complex and interdependent data. SQLite should be your pick in this scenario as it emphasizes concurrency, scalability, reliability, centralization, simplicity, and control.

When it comes to Flutter app development, you can use the SQLite database the right way via the sqflite package available on pub.dev. You can have complete control over your queries, database, relationships, or everything you desire to improve the performance of your Flutter apps. 

Posted on

Tackling Gender Bias Using Analytics

Introduction

Chances are when you hear "0.77 cents on the dollar," an increasingly contentious subject — the gender pay gap — comes to mind.  Today, we will explore a US Bureau of Labor Statistics dataset containing information about America's workforce (as of Jan. 2015) to answer the following questions:

  • Which industries are most and least affected?
  • Is the gender wage gap the same across all industries?
  • How much does an average American salary vary by gender?

To answer these questions, we'll be importing the dataset mentioned above (available on Kaggle) into an Arctype SQLite database, where we'll use queries and dashboards to manipulate and interpret the data.

Posted on

Does Product-Led Growth Produce Better Companies?

After serving two years in the Peace Corps, I knew I wanted to join a startup, but I immediately faced a dilemma — there are too many startups from which to choose. Some early teams, like Arctype, do distinguish themselves through their overwhelming focus on product experience, which is why today, I'm going to use SQL to analyze the performance of public SaaS companies that have historically shared this focus. Through this analysis, I hope to answer the following question: are these so-called 'product-led growth' companies truly better? Did I make the right long-term financial decision in joining Arctype?

According to product adoption platform Pendo, product-led growth (PLG) relies upon the product itself — its features, performance, and virality — to do much of the 'selling.' At Arctype, we are following this strategy by focusing on the speed and developer experience of both our query editor and SQL IDE to convert users.

Posted on

SQLiteOpenHelper and Database Inspector in Android

What Is SQLite?

SQLite is an open-source relational database, similar to MySQL. Android includes a SQLite library in its standard library that implements a serverless, zero-configuration, and transactional SQL database engine. SQLite does not run on a database server, but stores all its data in simple files. A complete SQLite database with many tables, triggers, indices, and views is contained in a single disk file. SQLite is built into all mobile phones and most computers and comes bundled inside. It carries lightweight data and does not require any administration or setup procedure of the database. 

The package android.database.sqlite.SQLiteDatabase consists of all the APIs to perform CRUD operations from our android application. 

Posted on

How Milvus Realizes the Delete Function

This article deals with how Milvus implements the delete function. As a much-anticipated feature for many users, the delete function was introduced to Milvus v0.7.0. We did not call remove_ids in FAISS directly, instead, we came up with a brand new design to make deletion more efficient and support more index types.

In FAISS, deleting an ID and its corresponding vector requires going through the whole dataset to determine which vectors to remove (facebookresearch/faiss). Thus, frequently calling remove_ids greatly worsens system performance and makes deleting and searching at the same time impossible. Furthermore, to delete the data that is flushed to the disk, you need to load it to the memory before flushing it back to the disk. This is prohibitively pricy in terms of system consumption and is obviously not viable for a production environment. Besides, FAISS only supports deletion for FLAT, IVF_FLAT, and IDMAP. Our goal for Milvus is to support deletion for not only all CPU and GPU indexes in FAISS, but also other ANNS libraries going forward. Therefore, we must design a new delete function for Milvus.

Posted on

How Database B-Tree Indexing Works

When we think about the performance of a database, indexing is the first thing that comes to the mind. Here, we are going to look into how database indexing works on a database. Please note that here, architectural details are described referenced to SQLite 2.x database architecture. You can find out the backend implementation of SQLite 2.5.0 with tests, which is relevant to this post from https://github.com/madushadhanushka/simple-sqlite.

Read how overall SQLite database architecture composed in this DZone article.

Posted on

Register and Login Using SQLite in Xamarin.Forms

Introduction

This article demonstrates how to register, login, and update the user data in SQLite. We perform CRUD operations with SQLite DB in Xamarin.Forms and can easily store and retrieve objects from the local database.

Output:

Image title

Posted on

Internal Architecture of the SQLite Database

In a computer program, the database is the heart of handling data and provides a fast and efficient way of storing and retrieving data. Learning the database's internal architecture and looking into a fully featured database at the code level is not so easy because of the database's complexity. But SQLite is a nice little compact database that is used in millions of devices and operating systems. An interesting fact about the SQLite database is that its code base is highly readable. Most of the code is well commented, and the overall software architecture is highly layered. My previous article describes the backend implementation of the SQLite Database, while this article looks into how the SQLite compiler and the VM work at a high level.

As I mentioned earlier, SQLite has a highly layered architecture that can be separated into seven layers. We will go through each of the layers one-by-one.