SQLite case 1: using SQLiteDatabase to operate database and table
1, Operation effect
2, Implementation steps
1. Create an Android Application SQLiteDatabaseDemo
2. Prepare the background picture background.jpg and copy it to the mipmap directory under res
3. Main layout resource file activity main.xml
Posted on Tue, 05 May 2020 04:59:05 -0400 by maff20
Preparing the Nginx + PHP environment
Install Nginx using yum:
yum -y install nginx
Modify the /etc/nginx/nginx.conf file as follows:
Posted on Mon, 04 May 2020 02:16:38 -0400 by aaronhall
1, Create database
Create the database needed by the project in advance through the command line tool
Note: remote login permission is required for database
#1. Log in to the database:
mysql -uusername -p
#2. Create a new login user:
create user newname identified by 'password';
#3. Remote login authorizati ...
Posted on Fri, 01 May 2020 06:46:12 -0400 by lucasmontan
I recently used this SQLite local database in my project, so I wrote a blog to summarize it, hoping it can also help Xiaobai
When to use SQLite
SharedPreferences is a lightweight data storage method. When saving data, it actually stores key value pairs, similar to Map. Storage location: / data/data / application package name / shared_prefs ...
Posted on Thu, 30 Apr 2020 15:18:46 -0400 by thesmartone
1, TXT file operation
import numpy as np
import pandas as pd
txt_filename = './files/python_wiki.txt'
# Open file
file_obj = open(txt_filename,'r')
# Read the entire file
all_content = file_obj.read()
# Close file
Python is a widely used high-level, general-purpose, interpreted, dynamic progra ...
Posted on Wed, 15 Apr 2020 10:04:20 -0400 by kslagdive
Decryption algorithm of wechat database on pc and Android
There is an article about the password generation algorithm of Android wechat database, which is not mentioned here
The password production algorithm on the pc side is encrypted in memory. Interested friends can see how the password is generated
Posted on Sun, 05 Apr 2020 18:02:35 -0400 by swissmissflash
Learn how to use SQLite
(1) What is SQLite?
① A lightweight database;
② It takes up only a few hundred kilos of memory;
③ It can be used without user name and password, which is insecure.
(2) How to use SQLite?
1. Create database and data table
New class inherits SQLiteOpenHelper
Posted on Sun, 05 Apr 2020 12:57:15 -0400 by ChrisMayhew
Use pyqt5+sqlite3+hashlib module to realize the encrypted login interface with database, and separate the logic and interface.
Generate a sqlite database. The reason for using sqlite here is that it is simple and does not need to be deployed. You can replace the database and corresponding modules accordin ...
Posted on Thu, 02 Apr 2020 03:57:49 -0400 by Spud_Nic
Reprinted from: https://blog.csdn.net/rpf2014/article/details/53116906
The last article introduced the operation of installation, addition, deletion, modification and query of FMDB
This article is mainly about data query screening and common database statistical functions, which is convenient for later query and learni ...
Posted on Tue, 31 Mar 2020 08:28:31 -0400 by wayz1229
Apache Kafka is a fast, scalable, high-throughput, fault-tolerant distributed "publish subscribe" message system, written in Scala and Java language, which can deliver messages from one endpoint to another.
Compared with traditional message middleware (such as ActiveMQ, RabbitMQ), Kafka has the characteristics of high throug ...
Posted on Fri, 20 Mar 2020 04:04:07 -0400 by jeev