Data dodania Pytanie
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
2017-05-19 18:05 Rails InvalidForeignKey »
I am developing a portfolio for my website, I decided to add skills to each portfolio item. class PortfolioSkill < ApplicationRecord belongs_to...
(1) odpowiedzi
2017-05-18 13:05 How to import Room Persistence Library to an Android project »
I recently saw the new feature announced on Google I/O Room Persistence Library to work with Sqlite databases on Android. I have been looking to the o...
(5) odpowiedzi
2017-04-25 03:04 Is it possible to take column names for sqlite database as input from user in an android app? »
I am creating an android app for my college faculties through which they will be able to keep and maintain the attendance of students in their lecture...
(1) odpowiedzi
2017-04-22 20:04 How to speed up SQL query with date GROUP BY? »
I have a normal SQLite database table called table1 with 7 columns and of course a rowid. The first column is an custom_id number, the second is date ...
(2) odpowiedzi
2017-04-18 14:04 Swift 2 iOS 9 and SqlLite »
I'm a new iOS programmer. I'm building a simple app with Swift. Now I want to insert a database to storage information of my app. I can't find any tu...
(3) odpowiedzi
2017-03-21 07:03 how to retrieve sqlite column values and store in to the array in objective c? »
Here is my code i am getting only the last value of the database in the array but i need the entire column values in my array... //select the values ...
(2) odpowiedzi
2017-03-18 00:03 How to display results from database in Sinatra using Sequel? »
I have an SQLite3 database called sk.db with a table called Sked that displays a schedule of sports matches with a column date. I am simply trying to ...
(1) odpowiedzi
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