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

Category: Database

The database is a warehouse that organizes, stores and manages data according to the data structure. It was created more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management is no longer just It is to store and manage data, and transform it into various data management methods required by users. There are many types of databases, from the simplest tables that store various data to large-scale database systems that can store massive amounts of data. They have been widely used in all aspects.

ListActivity and Adapter and SQLite

Summary ListActivity, AdapterView, adapter, multiple activities, SQLite, GUI style, menu resources and MenuInflater.

All resource files use the tag, and style elements use the tag . All att

September 22, 2021By Simo Sqlite Adapter, and SQLite, ListActivity, useLeave a Comment

Can I use anything other than BIGINT as a primary key data type in SQLite?

I am very excited about the possibility of using SQLite as a database solution during development, so I can focus on writing code first and use NHibernate’s ShemaExport feature to dynamically gener

September 22, 2021By Simo SqliteLeave a Comment

PowerDesigner15.1 Skills

PowerDesigner 15.1 tips What can PD do The most commonly used pdm (physical data model) The more commonly used cdm, ldm (conceptual data model, logical data model) Object-Oriented Model You

September 22, 2021By Simo Power Designer PowerDesigner, PowerDesigner15.1, skills, useLeave a Comment

Switch DELETE and LIKE in the SQLite statement

I tried to merge the two into a single statement, and I would even be satisfied with two separate statements… I know it must be possible, but how?

This is what I tried:

DELETE FROM my

September 22, 2021By Simo Sqlite delete, medley, SQLITE, statementLeave a Comment

Sqlite, exclusive or. How do I clear the flag?

Set the flag I write SET status=status|? How do I clear the flag? Usually I write SET status=status&( – 1 ^?) but ^ is illegal in sqlite. How can I clear the flag or use an exclusive OR? sqlite

September 22, 2021By Simo SqliteLeave a Comment

PowerDesigner generated Oracle built-in script to remove the quotation number of lowercase objects

This time I used pd to design the database. I didn’t pay attention at first. All table names and field names are in lowercase letters. As a result, all the objects in the generated script were quot

September 22, 2021By Simo Power Designer built, generated, lowercase, object, Oracle, PowerDesigner, quotation mark, remove, Script, tableLeave a Comment

SQLITE3 cannot be imported in Python 3

sqlite works fine with python 2.7, but when I try to import it in python 3, it will give an error

> Traceback (most recent call last): File “dbConnection.py”, line 1,
> in
> import sqlite3 F

September 22, 2021By Simo Sqlite China, python, SQLITE, SQLITE3, UnableLeave a Comment

Problem processing using PowerDesigner16 anti-compiling Oracle database

Recently, when using powerdesigner to decompile Oracle, I encountered a failure to connect to Oracle using odbc. After many tests, it was found that the problem was caused by the use of 64-bit odbc, which was replaced with 32-bit, and the problem disappeared.

September 22, 2021By Simo Power Designer Anti-, compile, database, Oracle, PowerDesigner, PowerDesigner16, problem, Processing, UsingLeave a Comment

What is the difference between SQLITE3 and Python 2.5, Pysqlite and APSW?

I want to know the difference between python2.5, pysqlite and apsw sqlite3?
When I try to install pysqlite on windows vista using python2.5, I have a bumpy run, please refer to the following:

<

September 22, 2021By Simo Sqlite APSW, Difference, Pysqlite, python, Python 2.5, SQLITE, SQLITE3, whatLeave a Comment

How to automatically generate CODE according to the first letter according to the entered Name when the PowerDesigner creates a table

Introduce how to automatically generate a table based on the entered Name when PowerDesigner creates a table Code method, which is also the most commonly used in practical applications. According t

September 22, 2021By Simo Power Designer creation, how to generate, input, PowerDesigner, table, timeLeave a Comment

Posts navigation

Page 1 … Page 22 Page 23 Page 24 … Page 47
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