Data dodania Pytanie
2017-03-07 19:03 Setting up the Database on Heroku. bundler: failed to load command: thin , LoadError: cannot load such file -- dm-postgres-adapter »
so I'm trying to do some Sinatra tutorial (JUMP START SINATRA by Darren Jones - https://www.sitepoint.com/premium/books/jump-start-sinatra) And it wo...
(0) odpowiedzi
2017-03-07 18:03 Rails: Two 'where' queries - each works individually, but not together »
I want to write something like: @meeting_requests = Meeting.where('meeting_time >= ? AND requestee_id IS ? AND...
(1) odpowiedzi
2017-02-23 21:02 SQL combine WHERE and ORDER BY in one statement »
I have a problem with my database request(I use Sinatra for Ruby). There's a database where I store some articles with their attributes like the price...
(0) odpowiedzi
2017-02-21 15:02 Why does count() return 0 when accessing a character field larger than 511 using pyodbc? »
I was trying to count the number of occurrences of a substring within a character field of a database (PostgreSQL, pyodbc, Python 3.4.4, Windows 7). B...
(1) odpowiedzi
2017-02-16 19:02 SQLite.swift. Swift Compile Error »
My Xcode project created in Xcode 8.1 with swift 2.3 runs correctly in simulator, but when I try to build and run the same project in Xcode 8.2 it sho...
(0) odpowiedzi
2017-02-13 21:02 Increase the performance of storing a JSON stream to a local database on Android »
I am developing an application that (part of its functionality) is fetching a huge list of items from a server, in JSON format, and stores it in a loc...
(1) odpowiedzi
2017-01-25 11:01 How to use DefaultDatabaseErrorHandler to handle database corruption in Android »
Some of the live users of my app are experiencing SQLite database corruption. When we have collected log from users we found below details: E/SQLiteL...
(2) odpowiedzi
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