Data dodania Pytanie
2017-12-08 19:12 Django: Moving data from SQLite to PostgreSQL »
I've recently inherited a production codebase for a webapp written using Django. Up until now, the database the project has been using has been the d...
(2) odpowiedzi
2017-11-18 22:11 ORDER BY with zero values ordered differently »
I want to add a temporary column call RowNum (I have succeed in getting it). But my problem is that I want my data to be ordered > or < with zero v...
(1) odpowiedzi
2017-11-14 19:11 Testing ASP Net Core Application with SQLite throws unknown function: newid() »
I am testing my service layer which contains some calls to repositories by using the SQLite database provider. My test class has been written accordin...
(1) odpowiedzi
2017-11-11 23:11 Rails 5 uuid issue with sqlite »
I'm converting my rails 5.1 app to start using UUID instead of incremental ids as the default active_record. I've changed my migration files to use i...
(1) odpowiedzi
2017-11-09 09:11 Laravel PHPUnit failing on ALTER TABLE using SQLite »
I have a migration which I made at the beginning of my project, basically adding a TEXT column called 'description' which is set to NOT NULL. Now sev...
(1) odpowiedzi
2017-11-07 03:11 What is the best way to increment an integer at a certain rate over time using a Django powered site and SQLite? »
I am trying to display a number that will increment over time that is called from a very, very simple Django database. It will be called using jinja2 ...
(3) odpowiedzi
2017-11-01 15:11 Android Studio flagging error in SQLite pragma command, <pragma value> expected, got 'ON' »
I think this is a new error since switching to Android Studio 3.0. I am receiving a lint syntax error: <pragma value> expected, got 'ON' ...
(1) odpowiedzi
2017-11-01 11:11 Why does Sequelize pauze after 3120 records? »
I've got a system written in Nodejs which first has to import records from very big csv files into a database. Using Sequelize as my ORM I created a s...
(1) odpowiedzi
2017-10-24 10:10 How to force SQLite to have not only lower case fields? »
We have a huge PHP (HHVM) application. The production database is postgresql, and have many fields like: userId, accountId. In pgsql the fields are ca...
(3) odpowiedzi
2017-10-23 11:10 SQlite returns 0 »
Let me start of by explaining how I insert and return data from SQLite. First I create the table like this: private static final String CREATE_TABLE...
(2) odpowiedzi
2017-10-13 13:10 Speeding up SQL query in R for time-series data »
I have a database which contains historic river levels and rainfall data. There is a 'Levels' table which has attributes including the date at which a...
(0) odpowiedzi
2017-10-06 13:10 Why is Rails returning a different float value when using a different database? »
I have an app running Rails 4.2 with this migration create_table "nutrient_amounts", force: :cascade do |t| t.integer "nutrient_id", limit: 4 t.i...
(1) odpowiedzi
2017-10-04 10:10 'This is the 'bait'. You probably need to add one of the SQLitePCLRaw.bundle_* nuget packages »
I am using Entity Framework Core 2 in my application using SQLite as my database provider. I have added references to the following in my project: ...
(1) odpowiedzi
2017-09-28 17:09 Rails' ActiveRecord doesn't see tables in SQLite3 database after migration »
I did rake db:drop rake db:create and rake db:migrate. When I run sqlite console, I get the following: sqlite> .tables ar_internal_metadata grou...
(0) odpowiedzi
2017-09-28 15:09 errors replacing development.sqlite3 with another development.sqlite3 on rails »
I am trying out an example from a book head first rails, i get to chapter 2 and i have issues following the instructions maybe because they used an ol...
(0) odpowiedzi
2017-09-28 12:09 SQLITE order by numeric and not alphabetic »
When I order my database SQLITE by Classement I have this : Classement | Nom 1 | clem 10 | caro 11 | flo 12 | raph 2...
(2) odpowiedzi
2017-09-17 14:09 Select the row number X in SQLITE when order by desc »
I'm using SQLITE (so no row_number) Here is my database call : tableau ID | Nom | Score ---|------|------ 1 | Clem | 50 2 | Caro | 60 3 | Flo |...
(1) odpowiedzi
2017-09-10 23:09 Error when running cmd <rake db:migrate> - "No connection pool with 'primary' found" »
I'm trying to set up a SQLite Db for my sinatra app and am running into an error I can't figure out. I've looked up related questions but none of them...
(0) odpowiedzi
2017-09-07 19:09 SQL Combining Multiple SELECT Statements »
I am trying to build an SQLite query that will collect statistics from a single table. The table holds a log, of sorts, with several entries per day....
(3) odpowiedzi
2017-08-20 06:08 Update values of a specific column of a specific row. Android SQLite »
I have a recyclerview cardholder that inflates using the values of 'NAME' from the table 'ORDERTABLE'. The cardholder also have an EditText which disp...
(2) odpowiedzi
2017-08-18 19:08 Working with Scotty and Sqlite and having some trouble with the Monads »
Hi I a pretty new to Haskell and I have been working on a small web application with Scotty and Sqlite. I am having trouble performing Sqlite operati...
(1) odpowiedzi
2017-08-15 20:08 Does it matter in SQL whether conditions are grouped in case of a join? »
I do join 2 tables via SQL and add where clauses. The join is done by a condition in the where clause. I wonder if it makes a difference whether the w...
(3) odpowiedzi
2017-08-05 05:08 Saving to Core Data "The left hand side for an ALL or ANY operator must be either an NSArray or an NSSet »
When I try to save a relationship to core data it throws the above error in the title. I'm basically creating a messaging app and data model is attach...
(1) odpowiedzi
2017-08-05 01:08 SQLite Data Adapter not displaying data »
I'm trying to fill a data grid view in my windows form application but nothing is being returned from the database when I execute the select query. I'...
(2) odpowiedzi
2017-07-01 18:07 How to connect rails development.sqlite3 database for the single ruby file? »
I have a main.rb for Telegram bot. For creating Admin panel of the bot I have used the Rails. So now I want to connect from main.rb file to the datab...
(2) odpowiedzi
2017-06-24 13:06 Context Related Problems inside MVP presenter »
I am new to android MVP pattern and working on my project i have some basic problem related to Android Context in the presenter. Although there are ma...
(1) odpowiedzi
2017-06-17 11:06 Generating PHP Passwords for a database without PHP »
PHP includes a pair of functions to generate and validate passwords, using, I believe, BCrypt. This makes it easy to use password hashes stored in a d...
(2) odpowiedzi
2017-06-14 15:06 SQLite - Get records which is not start with alphabet - IOS - Objective C »
IOS - Objective C - SQLite Query. I want records from user table which is name start with a special character or digit or else (Not start with alphab...
(1) odpowiedzi
2017-06-10 22:06 Spatialite SQL query to find the nearest node for the given lat/lon »
I want to find the nearest node to a given coordinate. I checked this https://gis.stackexchange.com/questions/186783/how-to-get-the-long-lat-informati...
(1) odpowiedzi
2017-06-04 20:06 Android Java SQLite database: The database does not take 2 String inputs »
I am learing to code and made a stopwatch that saves the laptimes in a String and gets the date as a String as well. I want to put those in a SQLite d...
(2) odpowiedzi
2017-06-04 04:06 Is performing .ToList() more than once is a bad idea? »
I've written the below function to query the SQLite DB in my Xamarin forms app. But, since I have to call .ToList() twice, I'm not very confident abou...
(2) odpowiedzi
2017-06-03 21:06 Overwriting SQLlite Database on IOS »
So, i have a database.sqlite file, i used NSlog to know where is the file located, hopefully i got the location and the question is , i want to ove...
(2) odpowiedzi
2017-06-03 17:06 How to properly add custom database support to Laravel 5? »
Suppose you want to add custom database support in Laravel 5. Whether it is MongoDB, Oracle or sqlite mod (SQLCipher). How would you go about it? Wha...
(0) odpowiedzi
2017-06-01 13:06 How to change Rails database sqlite to mongodb »
Just started to make simple Rails apps. The default database is SQLite3 now, but I would like to switch to mongodb. Is there any simple way to expor...
(2) odpowiedzi
2017-05-26 07:05 Android 6.0 and above not clearing sqlite data from the phone after uninstalling the application »
In android 6.0 and above when you uninstall the application and install again the same application(same package) then it showing the old sqlite data, ...
(3) odpowiedzi