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

Tag: SQLITE

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

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

August 22, 2021By Simo Sqlite 42.QT, class, create, database, deletion, detailed, modification, operation, QSqlQuery, QT, query, SQLITELeave a Comment

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

August 22, 2021By Simo Sqlite Core, data, database, General, Migration, SQLITE, SQLITE3Leave a Comment

Posts navigation

Page 1 … Page 8 Page 9
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