You may or may not know this, but I use Sendy to send out my monthly newsletters because it is incredibly cheap in comparison to competitors like Mailchimp. Anyone who has done list building before knows that over time you’re going to end up with a lot of stale subscribers that need to be cleaned in an effort to save space and keep things organized.
My email lists require a secondary opt-in to prevent SPAM subscriptions. The problem with this is I still get a lot of SPAM subscriptions even if they are never included in my newsletters. These subscriptions have no business being in my list, so it is best to remove them after so long.
We’re going to see how to use SQL to remove unconfirmed email subscribers in Sendy after so many days.Read More
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
I recently wrote about how to use a SQLite database within a NativeScript Android and iOS application that was built with Angular. This was more or less a revisit to the vanilla NativeScript tutorial on the same subject I had written earlier in the year. What happens when you have a massive amount of data that you’d like to save your user from needing to download before using your application? Can a SQLite database be pre-populated and included within an application?
To keep the flow going, I figured it would be a good idea to demonstrate how to ship a NativeScript Angular application with a pre-filled SQLite database rather than populating it on-the-fly.Read More
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
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
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
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