GPS-tracker | Stream Processing library

do you install the CP2104 driver to your PC before use it? This board use the CP2104 at the USB to TTL. Here is the driver:https://www.silabs.com/products/development-tools/software/usb-to-uart-bridge-vcp-drivers Please try it. Hope it help for you.

The code above is not a server side scripting language as the url is still point to a .html page.

A server side scripting language is a language that runs on the server rather than on the client. example of a server side scripting language is php.

does autoincrement do this?

No, in fact coding AUTOINCREMENT, restricts the re-use of unused rowids.

SQLite creates a unqiue identifier, the rowid, for every row unless you specify WITHOUT ROWID. This identifier is known as the rowid.

If you code column_name INTEGER PRIMARY KEY then column_name is an alias for the rowid (e.g. CREATE TABLE x (_id INTEGER PRIMARY KEY, another_column TEXT) creates table x with 2 columns, column _id is an alias of the rowid)

The rowid will be a higher value (first it is 1) generally the next so normally 1,2 etc, unless the highest number has been used 9223372036854775807 in which case AUTOINCREMENT if coded or not is considered as follows :-

If AUTOINCREMENT has been coded (i.e column_name INTEGER PRIMARY KEY AUTOINCREMENT). AUTOINCREMENT guarantees a higher rowid, so once 9223372036854775807 has been reached an SQLITE_FULL exception is raised; and

• if you force an insertion using the value 9223372036854775807 for an alias of rowid where AUTOINCREMENT has been coded, then the SQLITE_FULL exception will occur if another insert is attempted.

Without AUTOINCREMENT SQLITE randomly selects an unused rowid (e.g. your deleted row).

The AUTOINCREMENT keyword thus ensures that rowid's will be larger.

• It is when WITHOUT ROWID is not coded that causes a unique generally incrementing column as the rowid.
• It is the use of column_name INTEGER PRIMARY KEY that creates an alias for the rowid.
• The rowid is not normally visible i.e. SELECT *, will not include the rowid column. However; it would include an alias of the rowid.
• You can include the rowid by specifying it as a column e.g. SELECT rowid, * (the rowid and all other columns).
• Coding the AUTOINCREMENT keyword imposes extra CPU, memory, disk space, and disk I/O overhead and should be avoided if not strictly needed. It is usually not needed.

You may wish to look at:-

• SQLite Autoincrement

• Rowid Tables

you are creating new instance of LoginViewController inside your authorization function, but what you should do it to create an instance of SettingsRepositoryImpl inside your LoginViewController like