How To Install and Use SQLite on Ubuntu 20.04
SQLite is a free, cross-platform database management system. It is popular for its efficiency and ability to be used with many different programming languages.
How To Install Fathom Analytics on Ubuntu 20.04
Fathom Analytics is an open-source, self-hosted web analytics application that focuses on simplicity and privacy. It is written in Go and ships as a single binary file, making installation relatively straightforward.
How To Install the Etherpad Collaborative Web Editor on Ubuntu 20.04
Etherpad is a web application that enables real-time collaborative text editing in the browser. It is written in Node.js and can use a variety of database engines to store data. In this tutorial we will install Etherpad on an Ubuntu 20.04 server, using an SQLite database. We’ll also use Nginx to reverse proxy the application, and Certbot to fetch and install Let’s Encrypt SSL certificates.
How To Make a URL Shortener with Flask and SQLite
In this tutorial, you will build a URL shortener, which is a service that takes any URL and generates a shorter, more readable version like bit.ly. You will use Flask, SQLite, and the Hashids library to build your URL shortener. Your application will allow users to enter a URL and generate a shorter version, in addition to a statistics page where users can view the number of times a URL has been clicked. You’ll use the Bootstrap toolkit to sty
Build a Flask Python Web App from Scratch
Learn how to build a Flask web application from the ground up using Python, covering routes, templates, forms, and deployment.
How To Modify Items in a One-to-Many Database Relationships with Flask and SQLite
Flask is a framework for building web applications using the Python language, and SQLite is a database engine that can be used with Python to store application data. In this tutorial, you’ll modify items in an application built using Flask and SQLite with a One-to-Many relationship.
How To Read and Write CSV Files in Node.js Using Node-CSV
Learn how to read, write, and stream CSV files in Node.js efficiently using the csv package and SQLite.
How To Set Up a GraphQL Server in Node.js with Apollo Server and Sequelize
GraphQL is a specification and therefore language agnostic. When it comes GraphQL development with Node.js, there are various options available ranging from `graphql-js`, `express-graphql`, to `apollo-server`. In this tutorial, you will get a fully featured GraphQL server up and running in Node.js with Apollo Server. We will also see how to integrate a database with a GraphQL server using Sequelize.
How To Use an SQLite Database in a Flask Application
In web applications, you usually need a database, which is an organized collection of data. SQLite is a simple and fast open source SQL engine that can be used with Python to store and manipulate application data. SQLite works well with Python because the Python standard library provides the sqlite3 module, which you can use to interact with any SQLite database. In this tutorial, you’ll build a small web application that demonstrates how to use SQLite with Flask.
Interact with Databases in Flask Using Flask-SQLAlchemy
Learn how to use Flask-SQLAlchemy to manage databases in Flask. Create models, perform CRUD operations, and build scalable Python web apps.
