Skip to main content
Code Review

Questions tagged [sqlite]

Ask Question

SQLite is a software library that implements a self-contained, serverless, zero-configuration, transactional SQL database engine.

227 questions
Newest Active Bountied Unanswered
Filter by
Sorted by
Tagged with
9 votes
3 answers
1k views

This repository class is supposed to be used for saving information extracted from RAR, SFV archives or files that contain the hash sum in their filenames. The abstract parent class can be found here)....
viuser's user avatar
  • 629
4 votes
2 answers
102 views

I am pretty new to SQL databases and in particular to the better-SQLite3 database. I have managed to insert, update, and delete data in a way I desire. All of it running in the background of a self-...
godfatherjohn's user avatar
  • 143
1 vote
1 answer
137 views

I created these database tables with the inspiration in NjDevPro github repository. The design uses Closure Table for implementation of hierarchical tagging system in ...
xralf's user avatar
  • 37
2 votes
1 answer
81 views

As a side project, I'm developing a desktop app for project management, especially for students, self-employed, freelancers, etc. as a general purpose productivity tool, not from any business or ...
Prahlad Yeri's user avatar
  • 517
1 vote
2 answers
65 views

I’m working on QGIS with a SpatialLite DB (SQLite). I have four layers, and the fourth one (table: "ESPECES_HABITATS_POLY") is populated with the contents of two other layers (table: "...
Giene's user avatar
  • 169
2 votes
0 answers
106 views

So few days ago, I had created another review request for sqlite database schema for a comment hosting system. Now that the app development is complete, I have pushed the initial version on github. As ...
Prahlad Yeri's user avatar
  • 517
5 votes
2 answers
817 views

I'm working on a small and simple comment hosting platform in PHP (SQLITE database) to host comments for my static blog https://prahladyeri.github.io/. No login, sign-ups or third party OAuth, just ...
Prahlad Yeri's user avatar
  • 517
3 votes
2 answers
186 views

Motivated by the first commentor's suggestion on my MSAccess question: Python SQL insert to MSAccess with VBScript I am moving to use SQLite databases for a python application and I created this query ...
spaghetticode's user avatar
  • 123
3 votes
3 answers
157 views

I'm new to SQL, but I've always heard that it's a very efficient way of searching databases. For the same task, in VBA I get a result in a few seconds for 1000 queries. In SQL it takes several minutes....
Giene's user avatar
  • 169
1 vote
1 answer
133 views

I am currently in the process of writing a system application that will be operated by multiple users. This will require individual users to access the application while limiting access to those that ...
Michael's user avatar
  • 303
1 vote
1 answer
153 views

I developed this application for the company I work for. It became increasingly challenging to locate drawings within the myriad of folders, especially when searching for the most up-to-date versions. ...
shiblabi's user avatar
  • 13
1 vote
1 answer
132 views

I built an image upload API with Python Django. There are a fixed number of 6 slots, which can either be null or filled with something. There are two entities, Profile, which contains the six photos, ...
code writer 3000's user avatar
  • 507
5 votes
3 answers
731 views

I needed something to map named SQL parameters into indices for JDBC queries so I wrote the ParameterMap class that takes an SQL query, searchers for parameters ...
t3chb0t's user avatar
  • 44.7k
1 vote
2 answers
4k views

When I talk to people regarding connection pooling in SQLite most of them always laugh and say "You don't know about SQLite", "It is not a client server DB, and only overhead in ...
Swastik's user avatar
  • 113
5 votes
1 answer
282 views

I'd like to wrap all my sqlite statement functions with a decorator which collects the statement and the lists of values I will inject in place of placeholders in my statement (to avoid sql injection)....
FTG's user avatar
  • 195
2 votes
1 answer
1k views

The goal is to run a function compute in parallel on many inputs (10**6 in total, say) and store the results. Each call to ...
ga325's user avatar
  • 21
0 votes
1 answer
306 views

Is this fastest and most reliable way to copy multiple database files (SQLite) from one location to other and overwrite them if they already exists, safely ? Currently I'm using the below approach : <...
Bumba's user avatar
  • 101
0 votes
2 answers
633 views

I'm using SQLite3, via php's extension module, to create a persistent object cache for WordPress. It's intended for use on modestly sized sites that don't have access to redis or memcached. Why use ...
O. Jones's user avatar
  • 329
5 votes
1 answer
78 views

My SQLite database: CREATE TABLE Movimentacao ( mydate DATE , dividend_type VARCHAR(200) , dividends DECIMAL(19, 2) , ticker VARCHAR(300) ); Inserting some data: <...
Felipe Dourado's user avatar
  • 183
2 votes
0 answers
341 views

This wrapper incorporates the logging feature and provides a few convenience methods, including a scalar values fetcher, a generator for paged row sets, a wrapper retrieving a row set via a JSON ...
PChemGuy's user avatar
  • 415
1 vote
1 answer
107 views

For dummy's sake, let's say that I have a database with columns text, ind and sentid. You ...
Bram Vanroy's user avatar
  • 525
3 votes
1 answer
463 views

I know very little about databases and even less about how to optimize them, but I have a problem which calls for a database so here I am... I created a sqlite3 database using the following script: <...
erip's user avatar
  • 926
1 vote
0 answers
70 views

Code is posted after explanation. Due to the size of the project, this is being posted in three separate posts. This also ensures each post is more focused. Post 1 of 3, Core: UPDATE 1 on Newspaper ...
eccentricOrange's user avatar
  • 400
1 vote
0 answers
358 views

I program python as a hobby and wanted to learn how to apply databases in a functional program, while at the same time make something useful. so I made a to do application with some basic ...
liteversion's user avatar
  • 65
3 votes
1 answer
118 views

Code is posted after explanation. Due to the size of the project, this is being posted in three separate posts. This also ensures each post is more focused. Post 1 of 3, Core: Newspaper Bill ...
eccentricOrange's user avatar
  • 400
3 votes
1 answer
125 views

The following code builds a rudimentary acupuncture database by collecting data from the web. I would like to hear suggestions about improvements to the database structure, code organization, web-...
Sati's user avatar
  • 427
0 votes
1 answer
171 views

This question is related to my first post on this forum. Since the rules are not to make the questions too broad, I thought I'd create a new question. I'm not experiencing any issues with this piece ...
Adler's user avatar
  • 1
0 votes
2 answers
177 views

What does the code do? Albeit unfinished (it does work, it's just not complete yet), the code creates a database (members.db) where telephone numbers, IDs, and ...
telometto's user avatar
  • 119
2 votes
0 answers
433 views

SQLite C/ADO VBA library with reflection The SQLiteCAdo library is a VBA middleware facilitating access to SQLite databases. Its two subpackages provide alternative connectivity options: via ADODB/...
PChemGuy's user avatar
  • 415
4 votes
1 answer
652 views

I have made a program that does what the title explains. It also hashes the file to check for changes. I will be doing this for a project to keep track of files that has been changed when doing ...
Adrian Kydland Skaftun's user avatar
  • 41
1 vote
1 answer
5k views

I wrote this basic CRUD app + simple report so I could practice talking to a db directly. I purposefully avoided repository pattern and Entity Framework and only used a library to show the coming data ...
Pablo Aguirre de Souza's user avatar
  • 229
1 vote
0 answers
53 views

Recently, I was studying flask and my friend sent me a bit.ly link. Then the idea of a bit.ly clone struck my mind. This project uses Python - 3.10.0 flask - version 2.0.2 Bootstrap CSS. (I am very ...
Random_Pythoneer59's user avatar
  • 650
3 votes
1 answer
581 views

SQLiteDB VBA Library is a set of VBA helper functions for the SQLite engine. The primary motivation behind this project is to provide convenient access to extended introspection features. Because of ...
PChemGuy's user avatar
  • 415
4 votes
3 answers
2k views

I have the python script that creates a sqlite database and fills it with data (originally coming from a json file). At the time I execute the code below, my word ...
Pux's user avatar
  • 155
1 vote
2 answers
1k views

I'm using Flask on Python and I'm displaying the username at the top of the site (and it's working) as follows: ...
ARNON's user avatar
  • 441
2 votes
1 answer
266 views

I recently put up my C++ class to wrap the sqlite3 c library here: Thin C++ wrapper for sqlite3 C library One of the suggestions was rather than to specify a vector for arguments to functions instead ...
arcomber's user avatar
  • 2,531
2 votes
1 answer
741 views

I originally wrote a rough C++ wrapper of the sqlite3 c library which did not use prepared statements. This code is my attempt at using prepared statements. I have attempted to make the wrapper as ...
arcomber's user avatar
  • 2,531
1 vote
1 answer
886 views

I have a table data stored in a database ships.db, the data are informations of tracked ships hourly. The table data looks like ...
Khaled's user avatar
  • 349
3 votes
1 answer
74 views

This is my second project since I started with Python. This time I learned a little bit of SQL that is so useful and beautifully simple. Starting idea: Generate a program that will store information ...
Alejandro Trinchero's user avatar
  • 153
1 vote
1 answer
435 views

I am using Xamarin.Forms, Microcharts and SQLite.NET to create a mobile app. The SQLite.NET database stores details about books (book ID and entry date - the date it was entered in the system). The ...
TrackedCode's user avatar
  • 13
3 votes
1 answer
2k views

I want to start by just mentioning I'm a semi-beginner at C# and cyber security so any feedback is appreciated :) What I think I need reviewing is the SQLite queries and maybe the hashing functions I'...
Evorage's user avatar
  • 213
3 votes
1 answer
80 views

I wrote this little utility program that saves and load digital images such as videos, pictures among others in a database. I used click module for it's interface. ...
theProgrammer's user avatar
  • 1,938
1 vote
1 answer
363 views

I've following sqlite code using C api within Swift having a read and a delete operation for review. For those not familiar with Swift, defer will execute after the ...
AppDeveloper's user avatar
  • 145
3 votes
0 answers
771 views

Description This is a simple "demo" app designed to help gain familiarity with interacting with an Sqlite database from C#, particularly storing images as blobs. The database has a single ...
Al2110's user avatar
  • 404
1 vote
1 answer
310 views

My goal was to create a script that would: Pull certain data from an existing SQLite table Apply a simple mathematical formula Save the new values to another SQLite table I’m just starting to learn ...
user avatar
1 vote
1 answer
571 views

Trying to come up with a pattern where the code to open db, writing queries is elegant and clean while handling all possible error conditions. Following code ...
AppDeveloper's user avatar
  • 145
5 votes
3 answers
1k views

I'm a new programmer who is currently working on a personal project. It is supposed to be a login program which stores user data in a SQLite database. I was wondering if anyone could look at my code ...
Louie's user avatar
  • 51
2 votes
0 answers
48 views

I have this python script that uses pandas read an excel sheet then to update a sqlite db it works perfectly just wondering if I can speed it up as I am at about 70k lines ...
Pittsie's user avatar
  • 21
1 vote
1 answer
161 views

I have a very simple file where I have a Qcombobox Filter. When you select the filter, I run through a case on the index and output results. So, on selection I trigger: ...
Sam's user avatar
  • 113
1 vote
1 answer
3k views

In a Python Bottle server using SQLite, I noticed that doing a DB commit after each INSERT is not efficient: it can use 100ms after each client request. Thus I wanted to improve this in How to commit ...
Basj's user avatar
  • 264

1
2 3 4 5