Hodentek Mobile

Visual Studio is a great piece of software. It's higher end versions are quite expensive but Microsoft has a lower end free version, Microsoft Visual Studio 2015 Community which is free. It is well suited for mobile applications on tablets and smart phones. Do not think for a moment this is just for Windows Phone, you can develop cross-platform apps with it. If you want a app with a database backend, you have two options, SQLite and Indexed DB, one in relational and the other is non-relational. It is very easy to have SQLite on Visual Studio 2015 Community. SQLite is also free. In order to work with this post or other Visual Studio related posts you look no further than my blogs. SQLite is a relational database well suited for mobile applications. SQLite was described in a previous post here. As the Internet of Things is the trending area on the Internet, SQLite with its no administration feature is well suited. It is also the relational database for smart devices, cell p...

After describing options for database integration for mobile apps, this post describes a test that you can use to see if your browser supports IndexedDB. Database for Mobile Apps: When it comes to integrating mobile apps with databases there are two popular options, SQLite database or IndexedDB Database. While the former is a relational database, the latter is not-it is a storage for key/value pairs. This post here (http://hodentekmsss.blogspot.com/2016/09/sqlite-using-visual-studio-community.html) describes some details about SQLite database and the process of installing it on your computer. According to Mozilla Developer Network, " IndexedDB is a Web API for storing large data structures within browsers and indexing them for high-performance searching. Like an SQL-based RDBMS, IndexedDB is a transactional database system. However, it uses JavaScript objects rather than fixed columns tables to store data ." Complete details of this API are here ( https://developer...

SQlite is a serverless SQL Database that does not require a separate server process. You do not need a configuration (Zero configuration) and it does not need any administration. The whole database is stored in a single cross-platorm disk (or on your mobile device). It is very popular and widely used with mobile applications as the database is stored in the device and can be used without network connection. No external dependencies. SQLite as opposed to client/server relational database engines is serverless and it's use is indicated where efficency, reliability, independence and simplicity are required and it does not look for a shared repository. SQLite trasactions are fully ACID-compliant. SQLite supports most query languages that are SQL92 compliant and it is written in ANSI-C which provides simple APIs. SQLite is available on Linux, Mac OS-x, Android, iOS and Windows 32, WinCE and WinRT platforms. SQLite download from here: http://sqlite.org/download.html Read more her...