SQLite

SQLite is a relational database library designed to be embedded into software, instead of being accessed through a client/server interface. It is cross-platform and has bindings for most programming languages.

Subscribe to SQLite
Get notified when new articles on SQLite are published.
    All
  • 20 Results
    • Tutorial

      How To Read and Write CSV Files in Node.js Using Node-CSV

      In this tutorial, you will read a CSV file using Node.js streams, move data parsed from the CSV file into a SQLite database, retrieve it from the database, and write it to a CSV file.
      1 month agoBy Stanley UliliNode.jsDevelopmentSQLite
    • Tutorial

      How to Use Flask-SQLAlchemy to Interact with Databases in a Flask Application

      In web applications, you usually need a database, which is an organized collection of data. Flask is a lightweight Python web framework that provides useful tools and features for creating web applications in the Pyth...
      3 months agoBy Abdelhadi DyouriDatabasesDevelopmentFlaskPythonPython FrameworksSQLite
    • Tutorial

      SQLite vs MySQL vs PostgreSQL: A Comparison Of Relational Database Management Systems

      This article compares and contrasts three of the most widely implemented open-source RDBMSs: SQLite, MySQL, and PostgreSQL. Specifically, it explores the data types that each RDBMS uses, their advantages and disadvant...
      3 months agoBy ostezer, Mark DrakeMySQLDatabasesPostgreSQLConceptualSQLite
    • Question

      My first DO app keeps failing on deployment

      I am a code newbie, trying to deploy my first Python/flask app to DO. It uses SQLite as the db, which I know will need to be replaced with PostgreSQL or something more robust at some point, but for now, I just want a ...
      Accepted Answer: Hi there, Indeed I think that it is due to the SQLite package. App Platform apps are deployed in containers that are ephemeral. In events such as new deployments, your app crashes, or there are cluster issues and we e...
      1 answer5 months agoBy BluemontPythonDeploymentSQLite
    • Tutorial

      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. SQL...
      6 months agoBy Abdelhadi DyouriPythonPython FrameworksFlaskDevelopmentSQLiteDatabases
    • Tutorial

      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. ...
      7 months agoBy Brian BoucheronUbuntuUbuntu 20.04SQLiteApplications
    • Question

      Won't install Sqlite3 in app platform

      Hi, I’m trying to deploy an app on DO app platform through Github repo, and during the dploymnt I see that it can’t install sqlite3. I’m deploying Python worker app. [sariqdevbot] [2021-09-23 11:07:49] rm: cannot remo...
      1 answer8 months agoBy HidingCeruleanRaySQLite
    • Tutorial

      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 Etherp...
      8 months agoBy Brian BoucheronUbuntuUbuntu 20.04Node.jsApplicationsSQLite
    • Tutorial

      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. In this tutorial you will install SQLite on Ubuntu 20.04....
      11 months agoBy Gareth DwyerSQLiteData AnalysisOpen SourceUbuntu
    • Tutorial

      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 tutor...
      12 months agoBy Chimezie EnyinnayaAPINode.jsSQLite
    • Question

      Best way to deploy react/django web app on digital ocean

      I am building web application with django as a backend and reactJS as a frontend. I need to know which hosting solution works best for me ?What I am looking for: I need to store a lot of images so I need a lot of disk...
      1 answer1 year agoBy haiderabbas1982000DjangoReactDigitalOceanDeploymentPythonMachine LearningSQLiteStorage
    • Tutorial

      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 UR...
      1 year agoBy Abdelhadi DyouriProgramming ProjectFlaskPythonHTMLSQLite
    • Question

      Problem with server loading, Express JS API

      Hi, Hope you are doing well. This time I have a problem with the server, Currently I am using $15 server which has 2 cores and 2gb RAM, but the performance is poor now I don’t know what is the reason here. This is the...
      1 answer1 year agoBy Chirag ArtaniNode.jsAPIServer OptimizationDatabasesSQLite
    • Tutorial

      How and When to Use Sqlite

      Sqlite is a very simple and fast open source SQL engine. This tutorial will explain when it is optimal to use Sqlite, as opposed to a full-blown RDBMS such as Mysql or Postgres, as well as how to install it and basic ...
      1 year agoBy Gareth DwyerMySQLFAQSQLite
    • Question

      Installing/using SQLite on App platform

      I’ve got a PHP app deployed to the App platform and would like to use a SQLite3 DB with it. I’m new to SQLite (and the App platform), but familiar with MySQL. My boss suggested using a SQLite database since it’s a rea...
      2 answers1 year agoBy brockcaldwell33DigitalOcean App PlatformSQLitePHP
    • Tutorial

      How To Use Many-to-Many Database Relationships with Flask and SQLite

      In this tutorial, you’ll modify an application built using Flask and SQLite by adding a Many-to-Many relationship to it. A many-to-many database relationship is a relationship between two tables where a record in each...
      1 year agoBy Abdelhadi DyouriFlaskPythonPython FrameworksSQLite
    • Tutorial

      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 applica...
      2 years agoBy Abdelhadi DyouriFlaskPythonPython FrameworksSQLDatabasesSQLite
    • Tutorial

      How To Use 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 will use Flask with SQLite to...
      2 years agoBy Abdelhadi DyouriPython FrameworksPythonDevelopmentDatabasesFlaskSQLite
    • Tutorial

      How To Use the sqlite3 Module in Python 3

      SQLite is a self-contained, file-based SQL database. SQLite comes bundled with Python and can be used in any of your Python applications without having to install any additional software. In this tutorial, we’ll go th...
      2 years agoBy DavidMullerPythonDevelopmentDatabasesSQLite
    • Tutorial

      How To Make a Web Application Using Flask in Python 3

      Flask is a small and lightweight Python web framework that provides useful tools and features making creating web applications in Python easier. In this tutorial, you’ll build a small web blog using Flask and SQLite i...
      2 years agoBy Abdelhadi DyouriPython FrameworksProgramming ProjectDevelopmentPythonFlaskSQLite