Questions tagged [sqlite]

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

Filter by
Sorted by
Tagged with
0 votes
0 answers
45 views

Mapping named parameters to indices for PreparedStatement as DSL - follow-up

In the previous question I showed you my first attempt to handle named SQL parameters with JDBC and you were right, it wasn't as intuitive as I thought. The ...
t3chb0t's user avatar
  • 44.1k
5 votes
3 answers
498 views

Mapping named parameters to indices for PreparedStatement

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.1k
1 vote
0 answers
41 views

Import large Excel files directly from XML streams into an SQLite database

I've got some pretty large Excel files with nearly 1M rows that are almost impossible to open and work with in Excel anymore that I'm migrating into a database. Desipte this these files will stick ...
t3chb0t's user avatar
  • 44.1k
1 vote
2 answers
730 views

Simple Connection Pool for SQLite in Python

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
  • 13
0 votes
0 answers
49 views

Generate INSERTs from function parameters with jinja2

I'm writing unit-tests with pytest for sqlite database and reporting functions and I need to arrange them by inserting minimal ...
t3chb0t's user avatar
  • 44.1k
4 votes
1 answer
167 views

decorator to execute sqlite statement

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
  • 95
1 vote
1 answer
200 views

Concurrently write results to SQLite database

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
  • 11
1 vote
0 answers
45 views

Fetch external API currency rates, then save the results to database

The task I'm doing is, fetch external API, then save the results to database. I'm a beginner, I really wanna improve my code, to handle error well, and remove redundant code. The code is working, but ...
hsl's user avatar
  • 11
0 votes
1 answer
127 views

Copying multiple SQLite database files between two locations

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
211 views

Configuring SQLite3 for best efficiency as a persistent cache

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
  • 299
5 votes
1 answer
60 views

Sum values in different categories by each financial asset

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
2 votes
0 answers
186 views

A thin Python wrapper about the Python sqlite3 module

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
  • 425
0 votes
1 answer
51 views

Query for sequential column permutations in SQLite

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

Why are my read speeds so bad using sqlite?

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
  • 916
1 vote
0 answers
45 views

UPDATE on Newspaper Bill Calculator CLI with Python (3 of 3, Database)

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
0 votes
0 answers
329 views

Properly implement MVVM pattern in multiwindow WPF app

I'm trying to develop a SQLite based WPF app (c#) utilizing the MVVM pattern. I'm building this on a decade old laptop with only 2 GB RAM, 20 GB of free storage in it and Windows7. So I'm using .Net 4....
Tamal Banerjee's user avatar
1 vote
0 answers
182 views

To do application using python's tkinter and sqlite3

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
3 votes
1 answer
77 views

Newspaper Bill Calculator CLI with Python (3 of 3, Database)

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
3 votes
1 answer
89 views

Acupuncture database builder

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
  • 417
0 votes
1 answer
137 views

Code cleanup for a Java project that creates a database containing members of a club

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
129 views

Searchable database with Java and SQL

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
285 views

SQLite C/ADO VBA library with reflection

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
  • 425
4 votes
1 answer
412 views

Code to scan filesystem, store every path into sqlite and update only when something has changed

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
1 vote
1 answer
3k views

Beginner CRUD Console Application

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
1 vote
0 answers
37 views

bit.ly Clone in Python powered by Flask

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
3 votes
1 answer
378 views

VBA introspection library for SQLite

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
  • 425
4 votes
3 answers
1k views

Optimizing the insertion of 400 000 records in sqlite

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
  • 143
0 votes
2 answers
817 views

Getting a username from a database and displaying it in HTML

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
  • 401
2 votes
1 answer
209 views

Adding iterators to C++ sqlite wrapper class

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,449
2 votes
1 answer
484 views

Thin C++ wrapper for sqlite3 C library

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,449
1 vote
1 answer
517 views

Speed performance of sqlite3 queries looped in python

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
  • 309
2 votes
0 answers
33 views

Covid Tracker + Notify people = Ideal for small coffee place or similar

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
1 vote
1 answer
363 views

Generate a bar chart of weekly data from SQLite.NET

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
3 votes
1 answer
1k views

C# Password Security Login System with SQLite

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
  • 183
3 votes
1 answer
46 views

Simple Safe for Loading and Retrieving Digital Images

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
0 votes
1 answer
303 views

Sqlite select and delete operation using C API in Swift

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
3 votes
0 answers
526 views

Simple Sqlite-driven WinForms app in C# 7.0 - database interaction code

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
226 views

Load data from SQLite table, modify them and save in to new SQLite table

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
417 views

Improving sqlite3 code in swift using c api

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
4 votes
1 answer
1k views

Login function with python and SQLite

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
  • 41
2 votes
0 answers
30 views

Uploading to DB from Excel with Pandas

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
0 votes
1 answer
117 views

QCombobox Case selection - Pyside2 Index via Sqlite

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
  • 103
1 vote
1 answer
2k views

SQLite and Python: commit once every 10 seconds maximum, and not after every client request

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
  • 244
3 votes
1 answer
785 views

Gold Price Tracker Web Scraper using Python

Hi I've written a web scraper for tracking gold price. Can someone please review my code and suggest improvements. It gets the price of gold from a specific url then stores the price against date in a ...
vinaysr93's user avatar
4 votes
1 answer
1k views

Interface class for SQLite databases

I am learning the basics about managing an SQLite database by using Python and, mainly for practice purposes, I have then defined an interface class in order to let operations on database as clear as ...
rudicangiotti's user avatar
4 votes
0 answers
119 views

Optimizing hundreds of millions of SQLite database inserts in Python

Some background Feel free to skip this if you're not interested. There is a very popular bioinformatics program called tabix that permits interval-based searches for genetic variants in VCF files. ...
Daniel Standage's user avatar
6 votes
3 answers
1k views

Simple Python and SQLAlchemy Text Password Manager

Out of boredom, I decided to start my personal project and I've chosen a simple Text Password Manager. Note: For anyone out there, I strongly recommend you NOT to use this for any sensitive storage ...
Grajdeanu Alex's user avatar
1 vote
1 answer
137 views

Count distinct records in a JOINed SQL query

I have two tables with a 1-many relationship, Device and TestResult. My application has a filter builder front-end that allows a user to retrieve TestResults based on whatever filters they specify. ...
Chris.B's user avatar
  • 121
3 votes
2 answers
279 views

Database Design for representing category relationships

So I am new to Databases.Recently I was asked this question in an interview where they expected me to come with a schema for storing and retrieving categories for an E-commerce website in an RDBMS. ...
Suryasis Paul's user avatar
1 vote
0 answers
98 views

Uses SeekBar to adjust the data displayed in UI from my Room database

I wrote code that takes the value of the progress bar in my Android app which influences what is displayed on the UI. If the user's progress bar value is above or below a certain number, data will be ...
Jason p's user avatar
  • 21

1
2 3 4 5