Category Archives: SQLite database

2,942 views

Best of free database browser and editor sqlite download link

Sqliteman What’s Sqliteman? The best developer’s and/or admin’s GUI tool for Sqlite3 in the world. You can create database, table, query very fast and intuitively. You can learn sql query. If make some error you get explication. http://sqliteman.com/

Posted in SQLite database | Tagged | Comments Off on Best of free database browser and editor sqlite download link
5,870 views

sqlite database get path Android

Context context = getApplicationContext(); String DB_PATH = "/data/data/" + context.getPackageName() + "/databases/";

Posted in Android Examples Code, SQLite database | Tagged , | Comments Off on sqlite database get path Android
7,959 views

Do not hardcode /data/ use Context.getFilesDir().getPath()

// warning private static String DB_PATH = "/data/data/cz.okhelp.german_czech_phrases/databases/";   // OK public DataBaseHelper(Context context) { super(context, DB_NAME, null, 1); this.myContext = context; // OK DB_PATH = context.getFilesDir().getParentFile().getPath() + "/databases/"; }

Posted in Android Examples Code, Bugs, warnings, errors, SQLite database | Tagged , , | Comments Off on Do not hardcode /data/ use Context.getFilesDir().getPath()
4,669 views

How to Delete Sqlite Database Android Code

http://www.stevenmcmillan.co.uk/blog/2012/java-sqlite-database-helper-class-for-android/ public class DBHelper extends SQLiteOpenHelper {   //The Android’s default system path of your application database. private static String DB_PATH = "/data/data/my.site.mypackage/databases/"; private static String DB_NAME = "mesta"; private static Context myContext; public DBHelper(Context context) { super(context, DB_NAME, null, … Continue reading

Posted in SQLite database | Tagged | Comments Off on How to Delete Sqlite Database Android Code
7,553 views

Copy sqlite database from apk package to device folder Android example

Put your sglite database to Android Eclipse project folder named Assets. On device will copy database file to application folder as this example:   public void createDatabase(Context myContext) throws IOException { String sPackName = myContext.getPackageName(); InputStream assetsDB = myContext.getAssets().open("myDatabase"); OutputStream … Continue reading

Posted in SQLite database | Tagged , , , , , , | Comments Off on Copy sqlite database from apk package to device folder Android example
4,536 views

Sqlite create database and table with BAT file for Android

Sqlite3 create database and table with load.bat file and fill data to table example. Create folder for your project: my_sqlite_project Open folder and create file load.bat and paste to load.bat this text and save to project folder:   sqlite3 my_database.s3db … Continue reading

Posted in SQLite database | Tagged , , , , , | Comments Off on Sqlite create database and table with BAT file for Android
2,592 views

SQLite explorer download

Best of SQLite explorer and admin download for SQLite 2.x and SQLite 3.x in separated folders. Download Explorers SQLite 2.x and SQLite 3.x in separated folders

Posted in SQLite database | Tagged , , | Comments Off on SQLite explorer download