Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Using A SQLite Database For Local Data In A Golang Application

When developing an application with the Go programming language, you might find yourself needing to save data locally. If you’ve been keeping up you’ll remember that I’ve written about storing data remotely with Golang in a Couchbase NoSQL database, but never anything locally. Probably the easiest way to store data locally is with a SQLite database as it is a solid technology that has been around for a while.

We’re going to see how to use a SQLite database in our Golang application to read and write local data.

Read More

Using SQLite In A NativeScript Angular Mobile App

Quite a bit of time ago when I first started using NativeScript, I wrote a tutorial around using a SQLite database with it. Now just to be clear, this was with vanilla NativeScript, before Angular was available. Heck, the previous article was using JavaScript and not even TypeScript.

Well, times have changed and I figured it would be a good idea to revisit this NativeScript SQLite tutorial, but this time give it some TypeScript and Angular flair.

Read More

Using SqlStorage Instead Of SQLite In An Ionic 2 App

When it comes to Ionic 2 there are many ways that you can store your data. For example you could use HTML5 local storage, Mozilla’s localForage library, or Ionic’s SQLite extension that is part of Ionic Native. With these options available, I get a lot of requests for information on Ionic’s less advertised SqlStorage option.

We’re going to take a look at using SqlStorage in an Android and iOS application rather than the SQLite alternative.

Read More

Deploy A NativeScript App With A Pre-Filled SQLite Database

Recently I wrote an article regarding how to use SQLite in a NativeScript Android and iOS mobile application. In my previous tutorial the assumption was that the database would be created fresh. However, what if you want to ship a pre-filled SQLite database with your application? Maybe you have 10,000 records that you prefer not to have to download from a remote web server, or maybe there is another reason. Having a pre-populated database is fair game.

We’re going to take a look at what it takes to ship a NativeScript application with a SQLite database that already contains data.

Read More

Use SQLite To Save Data In A Telerik NativeScript App

Not too long ago I wrote a tutorial regarding saving data in a NativeScript mobile application using the application settings module that closely resembled that of HTML5 local storage. If you’re not familiar with the application settings module, it is persisted storage using key value pairs. What if you wanted a storage option that was a bit more query friendly? Like other hybrid app platforms, NativeScript supports SQLite for persisted data as well.

Both iOS and Android supports SQLite and since Telerik NativeScript can interface directly with native APIs, it becomes possible to use SQLite. We don’t need to write all the interface logic by hand because there happens to be a nice plugin available to make our life easier.

We’re going to see how to make use of SQLite in an Android and iOS NativeScript application using the available SQLite plugin.

Read More

Use SQLite In Ionic 2 Instead Of Local Storage

Ionic 2 is becoming all the rage right now because of it using Angular. With the introduction of Angular, comes many differences in the language and framework itself. One of the most critical parts of any mobile application is its ability to save data and have it persisted when the application is launched at a later date. I demonstrated in Ionic Framework 1 how to use SQLite as a storage solution, so I figured it would be a good idea to demonstrate the same using Ionic Framework 2.

Let’s see why it might be a good idea to use SQLite in an Ionic 2 application rather than HTML5 local storage.

Read More

Create A Todo List Mobile App Using Ionic Framework

Since writing my two tutorials regarding using SQLite in Ionic Framework and shipping an app with a pre-populated database, I’ve received many requests for a tutorial for making a full blown app. I listen to my readers, so I figured what better way to show such an example, than to create a todo-list type application.

In this tutorial, I hope to accomplish the following:

  • Shipping a pre-populated / pre-filled SQLite database
  • Access the SQLite database and perform operations based on user input
  • Include a WebSQL alternative for testing via a web browser
  • Navigate between views using the AngularJS UI-Router
  • Remove todo items from your list using swipe gestures

All items that I wish to accomplish have seen their own tutorials. If you’re familiar with the Marvel comic book movies, you’ll know that every hero has their own story, then they meet up for the bigger picture in an Avengers movie. Think of this tutorial like that.

Read More