SQLite in Android 1 What is a database? • relational database: A method of structuring data as tables associated to each other by shared attributes. • a table row corresponds to a unit of data called MySQL,andPHP) –Wikipedia is run on PHP and MySQL • 5 Android includes SQLite SQLite is a library, runs in the app’s process 6 Android Media Manager (Media Content Provider) • The Media provider Media: files http://androidxref.com/4.4.3_r1.1/xref/packages/providers/ MediaProvider/src/com/android/providers/media/ MediaProvider.java#1335 A single table to represent all types of media files:


surprisingly powerful) implementation of a SQL database. SQLite is the standard database software for iOS, Android, and Windows RT. It is installed on over a billion mobile devices. But like any other computer, my version of SQLite? Zumero requires SQLite 3.7.11 or later, which is preinstalled with iOS 6, Android Jelly Bean, and Windows RT. For older releases of these mobile operating systems, you should build

embedded database in the world Well-known users: http://www.sqlite.org/famous.html
 iPhone (iOS), Android, Chrome (browsers), Mac, etc. Self-contained: one file contains data + schema Serverless: database

Kit 备份恢复 dump 尝试恢复最新数据 遇到错误，填补缺漏 前面都无法恢复，最后尝试 ◊ WeChat Database ◊ 加密数据库组件 ◊ 包含全部三种恢复方案 ◊ Android / iOS ◊ 其他特性与优化 WCDB 组件 WCDB 组件 今天开源！ 关注我们的公众号 https://github.com/tencent/wcdb 欢迎 Fork / Stars

http://www.sqlite.org/ •一种单用户单文件的关系数据库 •占用资源少，适合于嵌入式产品 •无需安装，可以直接嵌入到应用程序中， Java应用只需引用一个jar包即可 •Android操作系统内置对SQLite的直接支持 SQLite概述 官网： http://www.sqlite.org/download.html 访问官网，可以直接下载相 关平台的SQLite开发工具

generate the table listed .tables List names of tables This is used as part of the Udacity Android Basics Nanodegree by Google. Code samples and descriptions are licensed under the ​Apache 2

file (easy to add into existing programs) ○ Capable SQL support ○ Robust and proven (used inside Android, Firefox, etc.) ○ Command-line SQL console (with CSV export support) ○ wealth of GUI tools ○ Great

Supported Platforms SQLite supports all major platforms. If you are using Windows, a Mac, Linux, an Android phone, an iPhone, and some other operating systems, you can use SQLite. For the sake of brevity

ANSI-C and provides simple and easy-to-use API.  SQLite is available on UNIX (Linux, Mac OS-X, Android, iOS) and Windows (Win32, WinCE, WinRT). CHAPTER 1 TUTORIALS POINT Simply Easy Learning