Relative Content

Tag Archive for sqlite

What is the traditional way to maintain extensibility in a database-driven application like this?

I’m working on a simple application for a game in Java that allows a user to record whether they have collected a given item and how much experience it contains. This will work for multiple item types (weapons, armor) and each will have its own tab with a list of all items that qualify under it. Making changes as new types are added is not such a big deal (if a clothing slot is added, for instance), but new items are added to the game all the time in biweekly patches, and I’m not sure what the traditional/customary way to make sure the application is user-extensible without requiring me to would be.

Representing category splits in a personal finance database

I’m working on developing a personal finance applications (e.g. Quicken/Mint.com/etc..). I plan to store the data in a SQLite database. I’m stuck trying to determine how I want to represent splits in the database. Each transaction will be assigned a category such as “Food and Dinning” or “Rent”. However, a single transaction may be split across multiple categories. For example a transaction at a grocery store may be split between “Groceries” and “Household”.

Uploading text data to server from SQLite is faster or text files?

My application receives a lot of data every milliseconds(name,id,value,.. of a signal from a simulator device). and I should upload this data to MySQL server. First I need to save them in a database and upload them to the server via GSM network. The reason that I save data into the mobile device is that the connection is so slow and the app receives a quite large number of data at a time and cannot upload them at once, also it may encounter disconnection problem. In fact, I just need a temporary storage and I don’t want to do any data manipulation in the SQLite. Currently I am writing the data to the simple text file(CSV) and then upload every 20 lines to the server using name/value pairs in Android HttpPost, but what about SQLite? Is it faster to insert data to SQLite and then upload it? Which approach is preferable?

find revenue from olist database

— TODO: This query will return a table with the revenue by month and year. It
— will have different columns: month_no, with the month numbers going from 01
— to 12; month, with the 3 first letters of each month (e.g. Jan, Feb);
— Year2016, with the revenue per month of 2016 (0.00 if it doesn’t exist);
— Year2017, with the revenue per month of 2017 (0.00 if it doesn’t exist) and
— Year2018, with the revenue per month of 2018 (0.00 if it doesn’t exist).

Retaining MAX() functionality when splitting a BLOB field up into multiple integer fields

I have an SQLIte3 database which has a BLOB field which encodes three integer values with a total bit length of 112 bits (64+16+32). I can perform comparisons and use the MAX() to find the maximum value of this field for some parameters of the query such as grouping. However, because everything is encoded as a BLOB, I can’t index the individual integer values, and as a result if I need to search on only one of these three values a full table scan is needed, producing poor performance.