Tag Archives: sqlite

Populating A SQLite Database Using CSV

Up until now for item data I’ve been typing items directly into the SQLite database using DB Browser for SQLite. The process was a bit cumbersome because I didn’t enter the items in alphabetical order so to make sure I … Continue reading

Posted in Side Projects, Software Development | Tagged , , | Leave a comment

Saving and Deleting Items

After some thought I’ve decided to add or remove items from the SQLite database as soon as they’re added to either list or removed from the Add list (the other option I entertained was replacing the entire database contents with … Continue reading

Posted in Side Projects, Software Development | Tagged , , , , | Leave a comment

Adding a SQLite Database to Android

Implementing a SQLite database on Android went a bit quicker after the iOS work. The steps involved were: Adding the SQLite.Net NuGet package to the Android project Creating an ItemSQLite.db3 link in the Android project Coding the SQLite_Android iSQLite interface … Continue reading

Posted in Side Projects, Software Development | Tagged , , , , | Leave a comment

Adding a SQLite Database to iOS

My original thoughts about using a local SQLite database to store list data were to┬ácheck and see if a database existed on the device at app startup. If it didn’t exist, I’d create a new database and populate it from … Continue reading

Posted in Side Projects, Software Development | Tagged , , , | 1 Comment

Initial Thoughts on Persistent Storage and Cloud Services

Two items remain before I can consider Viand ready for field-testing. Persistent storage of the Buy/Add list on the device Cloud storage for a shared Buy/Add list For the first item I’m going to use SQLite. The question here is … Continue reading

Posted in Side Projects, Software Development | Tagged , , , | Leave a comment