#sqlite

[ follow ]
Realpython
1 month ago
Python

Episode #200: Avoiding Error Culture and Getting Help Inside Python - The Real Python Podcast

Error culture includes false positives, hero culture, and alert fatigue; remedies suggested. Real Python's alert system configuration discussed. [ more ]
Realpython
1 month ago
Python

SQLite and SQLAlchemy in Python: Move Your Data Beyond Flat Files - Real Python

Python, SQLite, and SQLAlchemy provide database functionality for storing data in a single file without a database server.
Flat files in formats like CSV, JSON, XML can also be used for storing data in a structured way. [ more ]
CodeProject
1 month ago
JavaScript

How Much Can Sqlite Handle? Multiple Threads Concurrently Inserting Into Sqlite

SQLite is suitable for low to medium traffic websites, handling up to 100K hits/day.
The SQLite website itself manages 400K to 500K HTTP requests per day with dynamic content using 200 SQL statements per webpage. [ more ]
Medium
2 months ago
Web development

BUILDING A REST API WITH GO AND SQLITE(PART 2)

Implementing CRUD operations in Go with SQLite
Introducing error handling and validation for API functionality [ more ]
Alvinalexander
2 months ago
Scala

How to create a SQLite database

Creating a SQLite database is as simple as using the command 'sqlite3 my-database-name'.
Once the database is created, you can issue SQLite commands like CREATE TABLE to set up tables. [ more ]
Medium
2 months ago
Data science

BUILDING A REST API WITH GO AND SQLITE(PART 2)

Implementing CRUD operations for a Blog API with Go and SQLite.
Introducing error handling and validation to ensure API functionality. [ more ]
[ Load more ]