Android面试整理(5)-数据库

1、Sqlite 升级，增加字段的语句

Sqlite升级时向已有表中增加字段
https://blog.csdn.net/qq_26287435/article/details/82585597

2.数据库框架对比和源码分析

ORMLite:https://github.com/j256/ormlite-android
Afinal：https://github.com/yangfuhai/afinal
ActiviteAndroid:https://github.com/pardom-zz/ActiveAndroid
SugarORM:Android 平台专用 ORM
GreenDao:https://github.com/greenrobot/greenDAO
Realm：https://github.com/realm/realm-java

2.1、GreenDao 源码分析

数据库学习之 greenDAO 源码分析
http://blog.ralf.wang/2019/04/%E6%95%B0%E6%8D%AE%E5%BA%93%E5%AD%A6%E4%B9%A0%E4%B9%8B-greenDAO-%E6%BA%90%E7%A0%81%E5%88%86%E6%9E%90/

2.1、Room 源码分析

Android Jetpack架构组件之 Room
https://my.oschina.net/sfshine/blog/3010959

3、数据库的优化

Android性能优化-sqlite优化
https://www.jianshu.com/p/8bef9e42250c

4、数据库数据迁移问题

数据库数据迁移方法
https://blog.csdn.net/a714530833/article/details/90199162

5、Sqlite 常见异常

https://blog.csdn.net/Gaugamela/article/details/78614603

android.database.sqlite.SQLiteCantOpenDatabaseException: unable to open database file

https://blog.csdn.net/Aaren_Jiang/article/details/11781155

java.lang.IllegalStateException: attempt to re-open an already-closed object:SQLiteDatabase: /data/data/com.ant.sqlite3/databases/mydata.db

http://echo.vars.me/android/sqlite/

database is locked
attempt to re-open an already-closed object
SQLiteDatabase created and never closed
attempt to re-open an already-closed object
database disk image is malformed

https://codeday.me/bug/20180722/200952.html

Caused by: android.database.sqlite.SQLiteException: no such table: ligas_bd: , while compiling: SELECT * FROM ligas_bd

https://www.cnblogs.com/wangmars/p/4530670.html

java.lang.IllegalStateException: Cannot perform this operation because the
connection pool has been closed. java.lang.IllegalStateException: attempt to re-open
an already-closed object: SQLiteDatabase:
realm 无事务插入 1W 条 亲测 java.lang.IllegalStateException: Changing Realm
data can only be done from inside a transaction.

https://juejin.im/post/6844903553035665415

distinct