SQLite

Net Core NHibernate System.Data.SQLite could not be found

I am writing a Console App on Net Core 2.0. My App uses NHibernate Fluent to work with SQLite local db.This is how I configure NHibernate:When I try …

Databases

Kotlin / SQLite delete() in batch issue

I would like to delete mutiple items from SQLite in batch basing on their ID column.What I have is a HashMap which contains objects which one of …

Databases

SQLite connect to multiple databases with same tables

I have multiple databases with same tables in an app written in Xamarin Forms. When I login and use the first database and then close the app and …

Databases

how can i use inbuilt django authentication and admin panel with MongoDB ? How can i make a connection like regular SQL in settings.py for mongoDB

connection with this settings works for CRUD methods but is incompatible for admin panel and authenticaion.if there is some way by which i can make …

Python Programming

SQLite error 14 in ViewController

error is print SQLite error 14what is SQLite error 14?first use GRDB and first Call SqlLiteWhy raise Error?Ios 11.0 Swift 4.0 Grdb 2.10.0Build to …

Databases

[TA Deals] Start building apps with the discounted Android O Complete Developer Course!

If you want to start learning how to build Android apps, we’ve got a fully featured bundle that will get you started and teach you how to work with …

Android News

SQLite vs ArrayList in Android App

I'm currently making an Android App which needs ~4000 records (each one with 5 strings). At the moment, the app downloads and saves a CSV file, which …

Databases

Preprocessor definitions for vcpkg builds

I've installed SQLite with vcpkg and am using it successfully in a VS 2017 project. The problem is that I want to use the function …

Databases

How to refresh a table in Django, without using Ajax/jQuery for that

I want to refresh a particular table of a HTML page in Django, but I don't want to use Ajax/jQuery for that. The data in table comes from database. …

jQuery

How can I compare text in an SQLite database to some text held locally in a text file?

I have a program which <b>gets the history in Google Chrome</b> from Chrome's SQLite database. It works great, and the result is this:which uses <b>this …

Databases

When are records committed to disk with SQLite.swift?

I am struggling to see some INSERTs reflected in a SQLite database when using SQLite.swift.I debug my iOS app with breakpoints and after the …

Databases

What is the cheapest way to make a SQLite query in Android using Kotlin?

I have a table in my database, it looks something like:I want it to show bring the last date when source is inventory check. But the quantity of …

Databases

Importing SQLAlchemy DateTimeMixin raises ImportErrror

I am trying to import sqlalchemy.databases.sqlite.DateTimeMixIn. I get ImportError: No module named sqlite. SQLAlchemy 0.8.4 is installed. If I do …

Databases

How to use 'order_by' with including non-ASCII characters in django?

I use python3 and sqlite on my database. I try to order words on spesific languages. For example I wrote on my settings.py this code part:However, …

Python Programming

Which is better - execute(INSERT) or executemany(INSERT)

Situation: Need to insert quite a bit of data into a SQLite database.Problem: There are two statements we can use to insert data -Question: If …

SQLite

Not getting rows from database. SQLite, Android, Kotlin

I have a function inside DatabaseHelper.kt:But the Toast shows 0 in cursor.count.I know the table has rows because when I run the next code it brings …

Barcodes

Python Django: If you change the data type of an attribute in a model and then migrate, does the sql lite database drop data in that column?

Python Django: If you change the data type of an attribute in a model and then migrate, does the sql lite database drop data in that column?

Python Programming

Azure IMobileServiceSyncTable Parser Stack Overflow

I have an app that uses Azure Mobile offline sync. I'm trying to query a iMobileServiceSyncTable using the following:<p>If the number of items in …

Stack Overflow

SQLite Asynchronous Task and the Wait operator - will Tasks execute in correct order?

I have a SQLiteAsyncConnection Database with several tables and I want to get the Primary Key back after insert into one of them. My insert looks …

Databases

Unparseable Date in Grails Domain Class from SQLite Database

I have a sqlite db (it is the spiceworks db) and I am mapping the tables to grails domain classes. There is a table in particular that is in a …

Databases

How to use a specific test database in django

I would like to know if it is possible to execute test in django against a pre-populated database. I'm using an sqlite database and I have a copied …

Python Programming

logcat shows error my app don't show image on gridview using SQLite database

<b>Error:</b> <b>after running builder on my mobile the logcat shows looper error</b><b>Create SQLiteDatabaseHelper program</b><b>Insert Data from DataBase using Sqlite</b> …

Databases

Store fixed data in Django: dictionary or sqlite?

I'm working in a project that retrieves some data from a rest service. One of the retrieved fields is a department number that need to be searched in …

Databases

SQLITE in xamarin forms

I get some example but it's show more errorcould share a link I can to follow for to create a database registration formsSeverity Code Description …

Software Development

flex mobile - load image from bytearray - Error #2044: Unhandled securityError

In a mobile application I try to load an image from a sqlite database and want to show it in a mxml image component. The loading of the bytearray …

Web Development

Proposal: DSL for creating VIEWS in Sequelize [on hold]

I'm currently using <b>Sequelize</b> with a <b>PostgreSQL</b> database. I've been using Sequelize for about a year.I <i>can</i> create <b>VIEWS</b> using raw queries. I create them …

Dialects

Testing manual transactions inside Django unittests

How do you test code that disables autocommit and uses savepoints, inside a Django unittest?The default Django unittest class wraps all tests inside …

Python Programming

Django website with sqlite db deployment on heroku

I have been reading at many places that Heroku doesn't support sqlite database. Is there no option to use sqlite? Is there any kind of wrapper or …

Python Programming

Batch update with in clause

Is it possible to execute a batch update with a variable length in-clause against an sqlite db?This default approach causes scalikejdbc to log that …

Databases

Getting started with SQLite and Entity Framework on UWP

In this article we’ll show how to use Entity Framework Core and SQLite in a UWP app. We’ll use the code-first approach to define and generate a local …

Databases