1. Introduction to the basics of redis
2. Advanced redis applications
1. Concepts
Redis is an open source key-value, which is both a cache and a storage. It supports Persistence, with the hel
Tag: database
35 application scenarios in the NOSQL database
【Sumeng is committed to becoming the most outstanding data science community, focusing on big data, analysis and mining, and data visualization Field, business scope: offline activities, online cou
Database – SQLite: Multi-column primary key with automatic incremental column
I basically want to use the following scheme to convert tables from mysql to sqlite:
create table items (
id integer auto_increment,
version integer default 0,
primary key (id, version)
); Es
.NET – Want to encapsulate the database in the business object?
I usually like to create a database connection myself, and use `using {}’ to manually control its life cycle. For example:
SqlConnection sqlConnection = new SqlConnection( connectionString );
.NET – How to quickly save a lot of XML data into my database?
I used .NET to parse an XML file of about 20 million rows (1.56 GB), build a LINQ object from the data, and then insert it into a SQL database. This took a long time Time.
In order to improve
Database – SQLite – Table Constraints Unique and Column Constraints Unique Differences between UniQue?
Questions about SQLite.
In CREATE TABLE SQL, we can add UNIQUE constraints in any way: column-constraint or table-constraint. My question is simple. Do they work differently?
The only d
Database – Preventing errors from input
Is it a good practice to fully delegate data validation to database engine constraints?
Validating data from an application does not prevent invalid insertion from another software (maybe wri
Database – When do we need to return a value from a trigger program?
The documentation on the trigger procedure (https://www.postgresql.org/docs/9.6/static/plpgsql-trigger.html) says: “The trigger function must return NULL or Record/row”.
example
CREATE
42.QT-QSQLQUERY class Operation SQLite database (creation, query, delete, modification)
Qt provides the QtSql module to provide platform-independent SQL-based database operations. What we mean by “platform
independent” includes not only operating system platforms, but also various da
Core-Data – migrate ordinary SQLITE3 database to core data?
I have a normal pre-populated database. I want to migrate it to the core data of my application. What is the best way to achieve this? By the way, I did these things and copied recipes.sqlite datab