sqlite

sqlite copied to clipboard

Best Practices to implement

2

Hello guys, I'm struggling to find out how is the best way to implement `addUpgradeStatement ` I'm developing an Ionic APP using ``` "@capacitor-community/barcode-scanner": "^2.0.1", "@capacitor-community/electron": "^4.1.0", "@capacitor-community/keep-awake": "^2.1.0", "@capacitor/android":...

gvcambraia

Compatibility with Capacitor v4

3

Is there a plan to create a version of this plugin that is compatible with Capacitor v4? If so, is there any projected timeline for this?

jeremyburton

importFromJson not importing all values

6

**Describe the bug** When using the function `importFromJson()` only part of the data contained in the JSON is imported. A simple illustrated example: I have a service called `SyncService`. Upon...

marnec

After adding the plugin Android compilation fails

3

**Describe the bug** There seems to be a duplicate file between this plugin and probably another one (not sure which) that when I add this plugin I get a compilation...

HarelM

Android: Support binary data for insert/update and query

8

**Is your feature request related to a problem? Please describe.** We are trying to insert binary data into the SQLite database. It's not best practice, but we'd like to have...

richardliebmann

Problems with DELETE FROM

7

**Describe the bug** When attempting to call a delete statement using multiline strings, e.g. ``` let query = ` DELETE FROM sample_table WHERE col_1 = ? AND col_2 = ?...

s3vdev

Using read-only connection for querying data while a long running transaction is executed

17

Thank you for your work on this. We have a long-running SQL query that imports gigabytes of data and requires the use of the database connection with transaction enabled. Is...

SkoricIT

feat: Database incremental upgrade

4

> **Warning** > This is a large and breaking changes pull request. Please read full description to fully understand. ## Goal - Transform database upgrade proccess into an incremental process,...

dragermrb

Can someone point me to a guide on best practices for SQLite usage in Vue? Particularly with regard to connection management. Or just answer here. I'm writing an app and...

moksamedia

**Describe the bug** This isn't really a bug, but it's not a feature request either. I've created preliminary support for using @capacitor-community/sqlite with http://knexjs.org/ The typing isn't great because knex...

jrobeson