Data dodania Pytanie
2017-01-15 16:01 How to update the Expandable listview when new item is added to it »
I have created an expandable listview which loads data from sqlite when the listview reaches bottom.It again loads another set of data from sqlite usi...
(0) odpowiedzi
2017-01-13 11:01 Freeze database time in unittests (django & sqlite) »
I have a query which generates a score based on the age of a view. As you can see I am doing the age calculation in the SQL. The query looks something...
(1) odpowiedzi
2017-01-08 02:01 SQLite insertions slow to a crawl over time »
I'm using the program below to insert values from very large .csv files (~2.5 million lines) into an SQLite DB. It starts very fast, but begins to slo...
(1) odpowiedzi
2017-01-07 09:01 java.lang.IllegalStateException: Couldn't read row 0, col 0 from CursorWindow »
I need to fetch all data from a table,I used the following code to do the same in sqlite dbhelper class: public Cursor getData() { SQLiteData...
(1) odpowiedzi
2017-01-04 18:01 Sorting in Rails: SQLite vs PostgreSQL »
When I order by a column (id type INT) in Rails 5 with sqlite as the development db, it sorts as expected (1,2,3,4...) but the same thing on my produc...
(1) odpowiedzi
2017-01-01 18:01 Android getting data out of listview »
I'm at the moment programming an APP with an listview which is filled with data from an SQLite Table like this: public void printDatabase(){ Curs...
(3) odpowiedzi
2016-12-25 22:12 Sending an SMS to each group based on form selection(s) »
So I have an SMS app working perfectly with a Django form. I have an sqlite table "Employees" and each employee has one relationship of either "dcare...
(1) odpowiedzi
2016-12-24 01:12 Laravel - A show can have multiple providers »
So I am trying to figure a solution to this but not sure exactly how to do this. I have a table that stores all the shows that happen. In a given show...
(1) odpowiedzi
2016-12-19 08:12 sqlite/php - order by 'input order' - with imploded query »
Dollar. $qtwo = str_split_unicode($q); $arrlength = count($qtwo); and then I got: $where = array(); foreach ( $qtwo as $word ) { $where[] = "CHS ...
(1) odpowiedzi
2016-12-12 01:12 AR with sqlite3: Does setting limits on columns have any effect on db size? »
Im a bit new to AR and Sqlite. I'm working with a big dataset and struggle to figure out what's good practice for optimizing db speed and size. Eg. ...
(1) odpowiedzi
2016-12-10 19:12 Is it possible to search SQLite database that has base64-encoded some text strings? »
I know you can query a dataBase like so NSString *strSelectQuery = [NSString stringWithFormat: @"SELECT * FROM Songs WHERE songname LIKE '%%%@%%'", ...
(1) odpowiedzi
2016-12-05 00:12 SQLite Database vs. File based Data storage from Battery Performance Impact perspective »
I have an app runs in a background service all the time (only when screen is on), and on a regular intervals (1-10 minutes) records a how long the int...
(2) odpowiedzi
2016-12-04 17:12 django app keeps migrating without taking effect [heroku] »
I have been trying to fix this for the past three days and I keep failing. So, I have a simple app, that just has models.py and admin.py for now. Whe...
(2) odpowiedzi
2016-11-25 01:11 Re-create database when using Content Providers »
My Android App has a SQLite Database and a Content Provider. This Content Provider is registered in the app's AndroidManifest.xml. It is not exported,...
(1) odpowiedzi
2016-11-23 08:11 DbFunctions.TruncateTime LINQ equivalent in ASP .NET CORE »
I have the following functioning LINQ in my .net app public ActionResult Index() { Dictionary<DateTime?, List<Event>> re...
(3) odpowiedzi
2016-11-18 14:11 SQLite ORDER BY timestamp does not give expected results »
I have small difficulties by sorting a timestamp in SQLite and I tried everything and I am still not able to get correct result. I have a timestamp a...
(1) odpowiedzi
2016-11-14 11:11 Catch Specific Failed Records in bulk_create Django »
I'm using bulk_create to insert thousand of users once: new_users_bulk_list.append(User(user_id=user_id, date_of_birth=dob)) if len(new_users_bul...
(1) odpowiedzi
2016-11-04 10:11 My all data are not getting stored in Coredata »
I'm fetching values from Server and storing them to Coredata.The issue is coming that when i fetch data from server and store them in coredata, it sho...
(1) odpowiedzi
2016-11-01 06:11 django doesn't check CharField length on objects.create »
i'm using django 1.10 and try to make some models which including some simple choices, this is my models.py @python_2_unicode_compatible class Person...
(2) odpowiedzi
2016-10-28 01:10 Rails not porting SQLITE localhost to Heroku PGSQL »
Following a tutorial on rails and I get this error when attempting a method: :delete action. ActiveRecord::StatementInvalid (PG::DatatypeMismatch: ER...
(2) odpowiedzi
2016-10-24 19:10 Passing value from a dropdown box in sinatra & ruby »
It looks like for whatever reason sinatra will not recognize the "code" I use is my get "/library" do I tried putting it into a string but to no avail...
(1) odpowiedzi
2016-10-15 20:10 What are the equivalents of date() for month and hour? »
I'm using Ruby on rails 4.2, and SQLite. I know that I can use the following code to group the records by the day created_at, Then sum the totals of ...
(1) odpowiedzi
2016-10-05 12:10 Exception Invalid Limit Clauses - Android »
I am trying to put json object in sqlite database private void addList(String info){ try { JSONObject reader=new JSONObject(info)...
(1) odpowiedzi
2016-10-05 09:10 How to delete rows from recyclerView and sqlite database both? »
I'm creating an app with recycler view and SQLite database. When user enters some data, it is displayed in recycler view and also added to my database...
(2) odpowiedzi
2016-10-01 15:10 Accessing a certain downloaded .sqlite database in external storage from an android app »
I am trying to implement an offline map feature in an android WebView-based app: Using DownloadManager, I download an sqlite database file (of a stru...
(1) odpowiedzi
2016-10-01 08:10 Service hitting in loop using AFNetworking in iOS »
I am working with AFNetworking and it is working fine . Its working fine. But I stuck in one condition when hitting my service in while loop. I have a...
(0) odpowiedzi
2016-09-21 09:09 Can't save my data into sqlite database »
I am trying to implement a Parking Permit application page using ROR. I couldn't get my data saved into the database. The permit database is associate...
(3) odpowiedzi
2016-09-21 08:09 nodejs + sqlite: query execution order »
With Sqlite with nodejs you can't take the call execution order equals to the real db execution order of a query. For example in this pseuso-code you ...
(1) odpowiedzi
2016-09-10 22:09 Kotlin Closable and SQLiteDatabase on Android »
I use such code in my project fun getAllData(): List<Data> = writableDatabase.use { db -> db.query(...) } It executes successfully on ...
(1) odpowiedzi
2016-08-29 14:08 Rails/Sqlite 3 - Displaying table data on page »
I'm very very very new to Rails, and I've got a fast approaching deadline to code my first rail app as part of a challenge. I've so far created the b...
(1) odpowiedzi
2016-08-22 10:08 Insert and read nsdata in swift to make http post »
I'm making an app that connects to a server that manages information in php. Through the app I upload images to the server , which then treatment in ...
(0) odpowiedzi
2016-08-22 10:08 Permission denied @ dir_s_mkdir Error - EDITED »
EDIT #2 I have managed to route the uploaded file to the correct directory, although am getting another routing error: No route matches [GET] "/User...
(0) odpowiedzi
2016-08-15 19:08 How can I import data from a REST call, json feed into a SQLite database on a MAC? »
I have data that's on my server in a SQL Server database. I can access that with a REST call into a C# ASP.Net Web.API that I have control over and it...
(1) odpowiedzi
2016-08-11 11:08 Database is locked while updating data in background »
I'm working on an application where I've to use sqlite and there are lots of data. I want to load data from "residents_status" column of a table named...
(0) odpowiedzi
2016-08-04 09:08 Cannot create entry »
Django version 1.10, python version 3.4 I type and execute this code in manage.py shell: from tweet.models import Tweet tweet = Tweet("Parse JSON li...
(2) odpowiedzi