This page is a little unusual for me; it’s basically a terse summary of what I know about Android. I created it because I tend to (a) work with Android for a few weeks or months, and then (b) get away from it for several months, so this page helps me reload everything into my brain.
SQLite FAQ: How do I list the tables in a SQLite database?
To generate a SQLite tables list, just log into your SQLite database with the sqlite3 command, and then issue the "tables" dot command:
SQLite FAQ - How do I create an autoincrement field in SQLite?
You define a SQLite autoincrement field (also known as a serial, identity, or primary key field) with this syntax:
Android/SQLite FAQ: How do I show a list of SQLite database tables from the Android command line (adb shell)?
You can show a list of SQLite tables by starting the Android adb shell (command line tool), and then properly invoking the sqlite3 command. Here's an example of how this works, with comments shown before each command:
As a quick example of how to use a Thread with a basic Handler in an Android application, the following code creates a view where the text in the TextView is updated to show the current date and time when the Button is tapped.
First, here’s the Java source code for a file class named ThreadHandlerActivity:
Android/macOS Solution: This article shows a solution to the Android File Transfer app “not working on Mac” problem, where you get the Android error message, “Can’t access storage device.” (This solution may also work on Microsoft Windows systems, though I don’t have a Windows system to test with to know for sure.)
Last night I was trying to use the Android File Transfer program on my MacOS system to transfer music to my Google Nexus 9, which now runs Android 6 Android 7. After I connected my Nexus 9 tablet to the Mac with its USB cable and then started the Android File Transfer app, I saw this error message on my Mac:
Can’t access device storage. If your device’s screen is locked, disconnect its USB cable, unlock your screen, and then reconnect the USB cable.
This is what the Mac error message dialog looks like:
Unfortunately that’s a misleading and unhelpful error message, as the problem has nothing to do with the Android device screen being locked.
The solution to the problem on Android 7, Android 6 (and maybe Android 5) is to unlock your Android device (if it isn’t unlocked already), pull down the list of notifications, then tap the “USB for charging” notification:
Tapping that notification brings up the following dialog:
On this dialog you want to tap the “Transfer files (MTP)” option, as indicated by that large red arrow.
Note that this option has changed names at least once. As of March, 2017, it is now labeled “Transfer files,” with the subtitle, “Transfer files to another device.”
When you do this, the Android File Transfer app will either automatically start (which it does on my Mac), or you can go ahead and start it manually, at which point you’ll see the Android File Transfer main window:
Once you see this window you can go ahead and start dragging files from your Mac (or Windows) computer to this Android File Transfer window.
As Gert notes in the comments below, before you tap MTP on the phone, make sure you click “OK” on your Mac so that error message goes away.
Note that if you’re transferring music files to your Android device, you’ll want to transfer them to the Music folder. To do this, double-click that folder to open it, then drag and drop music files from your PC into that folder. On a Mac you do this by opening a Finder window, navigating to the folder where your music files are located — such as /Users/Al/Music/iTunes/iTunes Music — and then dragging and dropping the files from the Mac Finder window to the Android File Transfer window. Then start the “Play Music” app on your Android device and you should see your files under the “Recent activity” area on the home page of that app.
In summary, if you get the “Can’t access device storage” error when using the Android File Transfer app when trying to transfer files from your Mac or Windows system to your Android phone or tablet, I hope this solution is helpful.
SQLite foreign keys FAQ: Can you show me how to define foreign keys in a SQLite database table design?
The SQLite database does support foreign keys, and its foreign key syntax is similar to other databases. Here’s a quick SQLite foreign key example.
Filed under “What I learned about Android today,” it turns out that you can display an HTML string in an Android TextView. However, this approach has major limitations, and you’ll probably want to display your HTML in a WebView instead.
Skipping past that issue for a few moments ... if you want to try to display an HTML string in a TextView, you need to use the Android Html.fromHtml() method, as shown in this code:
SQLite FAQ: How do I default a SQLite datetime field to the current date and time? (i.e., how do I default it to now?)
Just use the SQLite current_timestamp function to default a field to the current date and time, like this:
SQLite script FAQ: How do I read/execute a CREATE TABLES script from the SQLite command line? (How do I read or execute commands in a file from the sqlite3 command line?)
SQLite FAQ: How do I create comments in SQLite?
SQLite lets you create comments using two different constructs, either two hyphens in sequence ("--"), or the "/.../" C-style comments. Here are examples of each approach, with the SQLite comments preceding the two database table definitions:
SQLite database FAQ: How do I create a SQLite database?
Creating a new database in SQLite is so easy, it's amazing. Once you have SQLite installed and your PATH set up properly, from your Unix or DOS shell, just issue a SQLite command like this:
SQLite schema FAQ: How do I list the schema for SQLite database table?
To view the schema for a SQLite database table, just use the SQLite schema command, like this:
SQLite dump/backup FAQ: How do I backup (dump) a SQLite database (or database table)?
"How to make a backup of a SQLite database?" is a really interesting question. Because a SQLite database is really just a file, if you truly want to make a backup of that database, it can be as simple as copying that file to a backup location.
But there is more to the story ...
SQLite CSV FAQ: How do I import a CSV file into a SQLite database table?
If you’re not using an autoincrement (primary key) field in your database table, importing CSV file data into a SQLite database is straightforward, though you may have to do some work to clean up your data first. Let’s take a look at how this works.
As a first example, assume that I have a SQLite database table defined like this:
SQLite autoincrement FAQ: How do I get the autoincrement value from my last SQLite INSERT command?
You can get the integer value of the primary key field from the last insert into an autoincrement field using a SQLite function named last_insert_rowid(), as shown in the example below.
SQLite database FAQ: Can you show me an example of the SQLite CREATE TABLE syntax?
Sure, here's a small collection of SQLite CREATE TABLE examples I recently created for my other SQLite tutorials:
This is a collection of notes about what I learned today, February 23, 2015. Most of it is about Android.
When (a) adding, editing, or deleting items in a ListView and (b) using a CursorAdapter, I need to update my cursor object before calling notifyDataSetChanged.
I created this method, which I call from my fragment’s onResume method:
SQLite FAQ: Can you show me how the SQLite ALTER TABLE syntax works?
At the time of this writing you can use the SQLite ALTER TABLE syntax for two purposes:
For other changes you'll have to follow some workaround procedures (discussed below).
