Security News
Introducing the Socket Python SDK
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
@capacitor-community/sqlite
Advanced tools
@capacitor-community/sqlite
REFACTOR π
Capacitor community plugin for Native and Electron SQLite Databases. In Native databases could be encrypted with SQLCipher
Maintainer | GitHub | Social |
---|---|---|
QuΓ©au Jean Pierre | jepiqueau |
The refactor offers now (2.9.0-beta.1
) all the features that the previous was offering. It has been a quite heavy process, hoping that the developpers will take benefit from it.
The main reasons for it:
db.open(), db.close, ...
androidx.sqlite.db.xxx
@journeyapps/sqlcipher
typeorm
or spatialite
drivers.This was discussed lengthly in issue#1 and issue#52
Refactor available for Android
, iOS
and Electron
platforms.
The test has been achieved on:
Other frameworks will be tested later
The plugin follows the guidelines from the Capacitor Team
,
meaning that it will not work in IE11 without additional JavaScript transformations, e.g. with Babel.
npm install @capacitor-community/sqlite@refactor
npm run build
npx cap sync
npx cap add android
npx cap add ios
npx cap add @capacitor-community/electron
import com.getcapacitor.community.database.sqlite.CapacitorSQLite;
public class MainActivity extends BridgeActivity {
@Override
public void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
// Initializes the Bridge
this.init(
savedInstanceState,
new ArrayList<Class<? extends Plugin>>() {
{
// Additional plugins you've installed go here
// Ex: add(TotallyAwesomePlugin.class);
add(CapacitorSQLite.class);
}
}
);
}
}
npm install --save @journeyapps/sqlcipher
npm run build
npx cap copy
npx cap copy @capacitor-community/electron
npx cap open ios
npx cap open android
npx cap open @capacitor-community/electron
No configuration required for this plugin
Name | Android | iOS | Electron | Web |
---|---|---|---|---|
createConnection | β | β | β | β |
closeConnection | β | β | β | β |
open (non-encrypted DB) | β | β | β | β |
open (encrypted DB) | β | β | β | β |
close | β | β | β | β |
execute | β | β | β | β |
executeSet | β | β | β | β |
run | β | β | β | β |
query | β | β | β | β |
deleteDatabase | β | β | β | β |
importFromJson | β | β | β | β |
exportToJson | β | β | β | β |
createSyncTable | β | β | β | β |
setSyncDate | β | β | β | β |
getSyncDate | β | β | β | β |
isJsonValid | β | β | β | β |
isDBExists | β | β | β | β |
addUpgradeStatement | β | β | β | β |
copyFromAssets | β | β | β | β |
API_Connection_Wrapper_Documentation
API_DB_Connection_Wrapper_Documentation
ImportExportJson_Documentation
UpgradeDatabaseVersion_Documentation
Ionic/Angular_Usage_Documentation
Ionic/React_Usage_Documentation
The IOS and Android codes are using SQLCipher
allowing for database encryption
The Electron code use @journeyapps/sqlcipher
allowing for database encryption
Thanks goes to these wonderful people (emoji key):
Jean Pierre QuΓ©au π» | Paul Antoine π» | Karyfars π» | Chriswep π |
This project follows the all-contributors specification. Contributions of any kind welcome!
2.9.0-beta.3 (2021-01-05) REFACTOR
FAQs
Community plugin for native & electron SQLite databases
The npm package @capacitor-community/sqlite receives a total of 11,205 weekly downloads. As such, @capacitor-community/sqlite popularity was classified as popular.
We found that @capacitor-community/sqlite demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago.Β It has 43 open source maintainers collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
The initial version of the Socket Python SDK is now on PyPI, enabling developers to more easily interact with the Socket REST API in Python projects.
Security News
Floating dependency ranges in npm can introduce instability and security risks into your project by allowing unverified or incompatible versions to be installed automatically, leading to unpredictable behavior and potential conflicts.
Security News
A new Rust RFC proposes "Trusted Publishing" for Crates.io, introducing short-lived access tokens via OIDC to improve security and reduce risks associated with long-lived API tokens.