1. Sqlite

  • 1.1. SQLite tutorial
    SQLite is a software library that implements a self-sufficient, serverless, zero-configuration, tra...
    2025-10-25 12:31:17 UTC
  • 1.2. Introduction to SQLite
    This tutorial helps you understand what SQLite is, how it differs from SQL, why it is needed, and how its application ...
    2025-10-25 12:31:13 UTC
  • 1.3. SQLite installation
    An important feature of SQLite is zero configuration, which means that there is no need for complex installation or ma...
    2025-10-25 12:31:10 UTC
  • 1.4. SQLite command
    This chapter will show you the simple but useful commands used by SQLite programmers. These commands are called SQLite...
    2025-10-25 12:31:15 UTC
  • 1.5. SQLite syntax
    SQLite follows a unique set of rules and guidelines called grammar. This tutorial lists all the basic SQLite syntax an...
    2025-10-25 12:31:11 UTC
  • 1.6. SQLite data type
    The SQLite data type is a property that specifies the data type of any object. Every column, variable, and expression ...
    2025-10-25 12:31:09 UTC
  • 1.7. SQLite creates a database
    SQLite’s sqlite3 Command is used to create a new SQLite database. You do not need any special permissio...
    2025-10-25 12:31:14 UTC
  • 1.8. SQLite attached database
    Suppose that when multiple databases are available at the same time, you want to use any of them. SQLite’s ATT...
    2025-10-25 12:31:10 UTC
  • 1.9. SQLite detach database
    SQLite’s DETACH DATABASE Statement is used to separate and detach a named database from a database conn...
    2025-10-25 12:31:18 UTC
  • 1.10. SQLite create table
    SQLite’s CREATE TABLE Statement is used to create a new table in any given database. Creating a basic t...
    2025-10-25 12:31:16 UTC
  • 1.11. SQLite delete table
    SQLite’s DROP TABLE Statement is used to delete the table definition and all related data, indexes, tri...
    2025-10-25 12:31:15 UTC
  • 1.12. SQLite Insert statement
    SQLite’s INSERT INTO Statement is used to add a new data row to a table in the database. ...
    2025-10-25 12:23:15 UTC
  • 1.13. SQLite Select statement
    SQLite’s SELECT Statement is used to get data from an SQLite database table and return it as a result t...
    2025-10-25 12:31:13 UTC
  • 1.14. SQLite operator
    1.14.1. What is the SQLite operator? ¶ Operator is a reserved word or c...
    2025-10-25 12:31:16 UTC
  • 1.15. SQLite expression
    Expressions are those of one or more values, operators, and calculated values SQL A combinat...
    2025-10-25 12:23:21 UTC
  • 1.16. SQLite Where clause
    SQLite’s WHERE Clause is used to specify the conditions for getting data from one or more tables. ...
    2025-10-25 12:31:13 UTC
  • 1.17. SQLite AND/OR operator
    SQLite Of AND And OR Operator is used to compile multiple conditi...
    2025-10-25 12:31:16 UTC
  • 1.18. SQLite Update statement
    SQLite Of UPDATE The query is used to modify existing records in the table. You ...
    2025-10-25 12:31:12 UTC
  • 1.19. SQLite Delete statement
    SQLite Of DELETE The query is used to delete existing records in the table. You ...
    2025-10-25 12:31:14 UTC
  • 1.20. SQLite Like clause
    SQLite Of LIKE Operator is a text value that matches the pattern specified by a ...
    2025-10-25 12:31:16 UTC
  • 1.21. SQLite Glob clause
    SQLite’s GLOB Operator is a text value that matches the pattern specified by a wildcard. If the search ...
    2025-10-25 12:31:11 UTC
  • 1.22. SQLite Limit clause
    SQLite’s LIMIT Clause is used to restrict the value of the SELECT The amount ...
    2024-01-11 23:00:02 UTC
  • 1.23. SQLite Order By
    SQLite’s ORDER BY Clause is used to sort data in ascending or descending order based on one or more col...
    2025-10-25 12:31:15 UTC
  • 1.24. SQLite Group By
    SQLite’s GROUP BY Clause is used with SELECT Statement to group the same data...
    2025-10-25 12:31:13 UTC
  • 1.25. SQLite Having clause
    HAVING Clause allows you to specify conditions to filter the grouped results that will appear i...
    2025-10-25 12:31:14 UTC
  • 1.26. SQLite Distinct keyword
    SQLite’s DISTINCT Keywords vs. SELECT Statement to eliminate all duplicate re...
    2025-10-25 12:31:17 UTC
  • 1.27. SQLite PRAGMA
    SQLite’s PRAGMA The command is a special command that can be used to control various environment variab...
    2025-10-25 12:31:13 UTC
  • 1.28. SQLite constraint
    Constraints are rules that are enforced on the data columns of a table. These are used to limit the types of data that...
    2025-10-25 12:31:18 UTC
  • 1.29. SQLite Join
    SQLite’s Join Clause is used to combine records of tables in two or more databases. JOIN ...
    2025-10-25 12:31:11 UTC
  • 1.30. SQLite Unions clause
    SQLite’s UNION Clause / operator is used to merge two or more SELECT Statemen...
    2025-10-25 12:31:17 UTC
  • 1.31. SQLite NULL value
    SQLite’s NULL Is an item used to represent a missing value. One of the tables NULL ...
    2025-10-25 12:31:11 UTC
  • 1.32. SQLite alias
    You can temporarily rename the table or column to another name, which is called 别名 . The use of a table...
    2025-10-25 12:31:15 UTC
  • 1.33. SQLite trigger (Trigger)
    SQLite 触发器（Trigger） Is a callback function for the database that is automatically executed / called whe...
    2025-10-25 12:31:14 UTC
  • 1.34. SQLite transaction (Transaction)
    A Transaction is a unit of work that performs work on a database. A Transaction is a unit or sequence of work that is ...
    2025-10-25 12:31:12 UTC
  • 1.35. SQLite Index (Index)
    Index is a special look-up table, which is used by database search engine to speed up data retrieval. Simply put, an i...
    2025-10-25 12:31:10 UTC
  • 1.36. SQLite Indexed By
    The “INDEXED BY index-name” clause states that a named index is required to find the values in the previous table. ...
    2025-10-25 12:31:15 UTC
  • 1.37. SQLite Alter command
    SQLite’s ALTER TABLE The command does not modify an existing table by performing a complete dump and re...
    2025-10-25 12:31:15 UTC
  • 1.38. SQLite Truncate Table
    In SQLite, there is no TRUNCATE TABLE Command, but you can use the ...
    2025-10-25 12:31:12 UTC
  • 1.39. SQLite View (View)
    A View is nothing more than a SQLite statement stored in the database by the associated name. A View is actually a com...
    2025-10-25 12:31:10 UTC
  • 1.40. SQLite subquery
    Subqueries, or internal queries, or nested queries, refer to the SQLite In the query ...
    2025-10-25 12:31:16 UTC

Principles and Applications of WebGIS  37

IT Tools  337

Web Frameworks  49

Principles, Technologies, and Methods of Geographic Information Systems  102

In recent years, Geographic Information Systems (GIS) have undergone rapid development in both theoretical and practical dimensions. GIS has been widely applied for modeling and decision-making support across various fields such as urban management, regional planning, and environmental remediation, establishing geographic information as a vital component of the information era. The introduction of the “Digital Earth” concept has further accelerated the advancement of GIS, which serves as its technical foundation. Concurrently, scholars have been dedicated to theoretical research in areas like spatial cognition, spatial data uncertainty, and the formalization of spatial relationships. This reflects the dual nature of GIS as both an applied technology and an academic discipline, with the two aspects forming a mutually reinforcing cycle of progress.

WEB Technology  258

Systems  232

Programming Language  353