Connector Types
Prisma supports two kinds of database connectors:
- Active connectors - manage and migrate the database schema
- Passive connectors - read and write data only
A connector supports at least one of the following GraphQL flavours:
- Relational
- Document
- Graph
- Key/Value
- Search
- Time series
- Analytical
- In Memory
Contributing
The best way to ensure that a particular connector gets build is to contribute the following two things:
- Very concrete use case description.
- Initial suggestion for syntax for SDL and the generated GrpahQL API.
When we prioritise the connectors to build, community validation plays a big role, so the more you can contribute in the relevant Github issue the better.
Scalar Types
https://github.com/graphcool/prisma/issues/1753 maps out scalar types supported by each database and attempts to map to a common set of GraphQL Scalar Types.
We need to decide if Prisma should support db specific types in addition to the generic types. The MySQL types SMALLINT and INT both map to the GraphQL type Int, but we could also allow mapping them to the GraphQL types MySQL_SMALLINT and MySQL_INT respectively for added control.
Connectors
Relational
MySQL
PostgreSQL
Ms SQL
Oracle
CockroachDB
Document
MongoDB
ArangoDB
Graph
Neo4j
Dgraph
Neptune
Analytical
Druid
Time series
Influx
Timescale
Key/Value
DynamoDB
Cassandra
Search
Elastic Search
In Memory
Redis
File Based
SQLite
sorenbs
All 12 comments
Would you consider "Apache Ignite" ?
pranasblk
on 15 Feb 2018
Any chance of a file-based db such as an sqlite connector?
nharlow89
on 17 May 2018
@nharlow89 - that's a great idea. Could you open a separate issue and describe your use case in as much detail as possible? Thanks!
sorenbs
on 20 May 2018
@sorenbs could we update the original post to have the link for the passive MySQL connector point here:
https://github.com/prismagraphql/prisma/issues/2506
(EDIT)
... and this link for the passive Postgres connector:
https://github.com/graphcool/prisma/issues/1749
... just to reflect how the related issues have since evolved?
cmcinroy
on 31 May 2018
+1 for SQLite
mnlbox
on 18 Jun 2018
Another +1 for SQLite
paul-go
on 26 Jun 2018
Any thoughts on Cosmos DB? I saw it referenced in this older issue.
kevineger
on 8 Nov 2018
This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 10 days if no further activity occurs. Thank you for your contributions.
![stale[bot] picture](https://avatars.githubusercontent.com/in/1724?v=4&s=40)
stale[bot]
on 9 Jan 2019
This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 10 days if no further activity occurs. Thank you for your contributions.
stale[bot]
on 23 Feb 2019
This issue has been automatically marked as stale because it has not had recent activity. It will be closed in 10 days if no further activity occurs. Thank you for your contributions.
stale[bot]
on 9 Apr 2019
Any news on Elastic search connector?
cmdavinder
on 9 Aug 2019
SQLite optionally stored in S3 like this.
adonig
on 14 Mar 2020
Related issues
Fi1osof
·
3Comments
marktani
·
3Comments
schickling
·
3Comments
sedubois
·
3Comments
AlessandroAnnini
·
3Comments
Most helpful comment
Any chance of a file-based db such as an
sqliteconnector?