Community
Join our growing community around the world, for ideas, discussions and help regarding ArcadeDB.
-
Chat live with us on Discord: https://discord.gg/w2Npx2B7hZ
-
Follow us on Twitter: https://twitter.com/arcade_db
-
or on Bluesky: https://bsky.app/profile/arcadedb.bsky.social
-
Connect with us on LinkedIn: https://www.linkedin.com/products/arcadedb
-
or on Facebook: https://www.facebook.com/arcadedb
-
Questions tagged
#arcadedbon Stack Overflow: https://stackoverflow.com/questions/tagged/arcadedb -
View our official Blog: https://blog.arcadedb.com/
Frequently Asked Questions
-
What is ArcadeDB’s release cycle?
-
There are typically monthly releases with occasional bi-monthly releases.
-
-
How do I build or contribute to ArcadeDB?
-
See the contributing guide in the ArcadeDB github repository: CONTRIBUTING.md
-
-
What is a good introductory book about NoSQL or Graph databases?
-
Try SQL and NoSQL Databases. It teaches basics on relational (SQL), document (Mongo), and graph (Cypher) databases.
-
-
How do I protect prepared statements against SQL injection?
-
A good starting point is the OWASP SQL Injection Prevention Cheat Sheet. To use escaping as defense, the characters
\,",', need to be escaped with\\,\",\'respectively. Furthermore, the strings;and--need to be replaced, for example with similar unicode characters like;(greek question mark,\u037E) and–(en dash,\u2013). Please note, that this escaping and replacing is merely a minimal protection, and generally not sufficient.
-
-
How are duplicate keys handled in map properties or inserted content?
-
As in the ECMAScript Specification (Note 2), duplicate keys in JSON objects are resolved by keeping the last one read and discarding previous ones.
-
-
How can strictly ascending unique identifiers be data modeled with ArcadeDB?
-
One can use a unique index together with transactions of
next_id = max(id) + 1. See https://www.cybertec-postgresql.com/en/postgresql-sequences-vs-invoice-numbers/ for more details.
-
-
How can "prepared statements" be formed for ArcadeDB?
-
Prepared statements can be directly used via the Postgres driver and the JDBC driver. Furthermore, the Java API and the HTTP/JSON API provide parameterized queries and commands which can manually be extended to prepared statements by wrapping the respective method or request calls in a function and forwarding the function arguments to the parameterized query or command.
-
-
How can database schema be maintained?
-
One can use
.sqlfiles listing the SQL commands creating the schema. To keep this script idempotent the DDL commands have to have the suffixIF NOT EXISTS. Such a SQL script can then be parsed using theLOADcommand of the console, which can also run commands passed as command-line arguments.
-