Skip to navigation Skip to content
Simon Technology Blog
  • Architecture
  • Cloud
  • Database
  • Develop
  • Hardware
  • Industry
  • Language
  • Mobile
  • Opensource
  • OS
  • Web
Main Navigation

Category: Sqlite

SQLite, a lightweight database, is a relational database management system that complies with ACID. It is contained in a relatively small C library. It is a public domain project established by D. Richard Hipp. Its design goal is embedded, and it has been used in many embedded products. It occupies very low resources. In embedded devices, only a few hundred K of memory may be enough. It can support mainstream operating systems such as Windows/Linux/Unix, and can be combined with many programming languages, such as Tcl, C#, PHP, Java, etc., as well as ODBC interfaces. It is also compared with the two open source Mysql and PostgreSQL In terms of world-famous database management systems, its processing speed is faster than them.

SQLITE3 date and interval function

I want to know whether sqlite3 supports the interval function. PostgreSQL accepts the following statement, but sqlite3 cannot parse it;

select< br /> …
from
orders
where
…
and o_order

September 22, 2021By Simo Sqlite Date, function, Interval, SQLITE, SQLITE3Leave a Comment

How to delete all empty tables in SQLITE?

I want to delete all tables without rows.

How to delete all empty tables in SQLite?

Edit
I need to do this on my mobile phone (without casing). On a Windows Mobile phone.

1) Get a

September 22, 2021By Simo Sqlite How to delete, in space, SQLITE, tableLeave a Comment

SQLAlChemy SQLite multi-threaded settings

from sqlalchemy.ext.declarative import declarative_base
from sqlalchemy import create_engine
from sqlalchemy import Column, String, Integer
from sqlalchemy.pool import SingletonThreadPool < p>

<

September 22, 2021By Simo Sqlite multi-thread, setting, SQLALCHEMY, SQLITELeave a Comment

SQLITE3: Need Cartesi Dating

I have a table which is a list of games played in the sqlite3 database. The field “datetime” is the date and time when the game ends. The field “duration” is the number of seconds the game lasts .

September 22, 2021By Simo Sqlite Dating, Descartes, need, SQLITE, SQLITE3Leave a Comment

Monotouch’s mono.data.sqlite: How to get the value of the auto increment field after inserting a line?

Well, this may be very basic stuff, but it took me a long time to figure it out. I think there are more .NET programmers like me, Monotouch and SQLite Newbies don’t know this.

I use Ado.NET (

September 22, 2021By Simo Sqlite automatic, data, Field, Get, How, Increment, inserted, line, mono, mono.data.sqlite, Monotouch, SQLITE, valueLeave a Comment

SQLite in multithreaded Java applications

I wrote a Java application that occasionally logs events to a SQLite database from multiple threads. I noticed that I can trigger SQLite’s “database lock” error relatively easily by generating a sm

September 22, 2021By Simo Sqlite application, Java, multi-thread, program, SQLITELeave a Comment

Can SQLITE support multiple users?

I am trying to develop a Windows-based application where multiple users access the same database at the same time. Can SQLite support multiple accesses at once? Is SQLite stable in this regard? Wha

September 22, 2021By Simo Sqlite multiple, SQLITE, support, user, YesLeave a Comment

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

August 22, 2021By Simo Sqlite Auto, Column, database, Increment, key, Main, Multi-Lord, SQLITELeave a Comment

Detailed steps in EntityFramework integrated SQLite

1. Build a solution (framework4.0 is used in this illustration) as shown in the figure:

2, add System.Data.SQLite reference as shown:

3. Make sqlite database files

uses navcat to

August 22, 2021By Simo Sqlite detailed, EntityFramework, integrated, SQLITE, stepsLeave a Comment

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

August 22, 2021By Simo Sqlite Any, Column, Constraint, database, Difference, SQLITE, table, UniqueLeave a Comment

Posts navigation

Page 1 … Page 8 Page 9 Page 10
Recent Posts
  • Sencha-Touch-2 – Sencha Touch 2, Nested XML Analysis NodeValue
  • Add a separation line and format XML content
  • Is there a norm of simplified XML subsets?
  • Look at it when you write React
  • ReactJS – Present React Redux React-Router App to add the server to the Firebase hosted by the Firebase
Categories
  • Android
  • Apache
  • Apache Kafka
  • Asp
  • Auto-Test
  • Automated Build
  • Aws
  • Bitcoin
  • Browser
  • C & C++
  • C#
  • Centos
  • Cgi
  • Character
  • Cloud Service
  • Cocos2dx
  • Cordova
  • CSS
  • Data Structure
  • Delphi
  • Design Pattern
  • Dojo
  • Dubbo
  • ELK
  • Flex
  • football
  • Game
  • Hadoop
  • Hibernate
  • HTML
  • Hybrid
  • Intel
  • IOS
  • Ipad
  • iPhone
  • Java
  • Javascript
  • Jetty
  • JQuery
  • Jsp
  • Linux
  • Load Balance
  • Lua
  • Macbook
  • Macos
  • Mathematics
  • Micro Services
  • Monitoring
  • Motherboard
  • Mysql
  • Network Hardware
  • Network Marketing
  • Nginx
  • NodeJs
  • Nosql
  • Oracle
  • Os Theory
  • Performance
  • PHP
  • Postgresql
  • Power Designer
  • React
  • Redis
  • Regexp
  • Rom
  • Rss
  • Ruby
  • Search Engines
  • Shell Script
  • Silicon Valley
  • Silverlight
  • Software Design
  • Spring
  • Sql
  • Sqlite
  • Sqlserver
  • Storage
  • Storm
  • Surface
  • SVN
  • Swift
  • System Architecture
  • Tablet
  • Uncategorized
  • Unix
  • Visual Basic
  • Visual Studio
  • Web Crawler
  • WebService
  • Windows
  • Wireless
  • XML
  • ZooKeeper
Archives
  • October 2021
  • September 2021
  • August 2021
  • May 2021
  • April 2021
  • September 2020
  • September 2019
  • August 2019
  • June 2019
  • May 2019
  • April 2019
  • March 2019
© Simon Technology Blog 2025 • ThemeCountry Powered by WordPress