80 results found
-
1 vote
-
Enhanced Foreign Key Behavior
I am reaching out to share a suggestion regarding the current implementation of foreign key constraints in Firebase DataConnect.
Currently, it appears that the default behavior for foreign keys is automatically assigned during schema deployment, and there is no way to explicitly define ON DELETE and ON UPDATE rules (e.g., NO ACTION, CASCADE) in the GraphQL schema. This limitation has the following implications:
1. Deployment Overrides: Even if these rules are manually adjusted in the underlying PostgreSQL database, deploying an updated schema resets the rules to the platform’s defaults.
2. Lack of Customization in Schema: Adding support for directives like…7 votes -
How connect DBeaver in localhost database?
How connect DBeaver in localhost database?
I love DBeaver and i can connect in my production database but i cant connect in localhost database, always i try connect the firebase emulator give an generic error and crash.
I can use the firebase dataconnect:sql:shell but is not so good like DBeaver3 votes -
Schema Creator Tool in the Firebase Console
Support creating GraphQL schema in the Firebase console
31 votes -
Allow to connect emulator with a tier SQL client
I get that firebase dev really want to push their DataConnect api but any full featured tiers SQL client would allow us to have a wider view of what worked in our dev environment.
It would be way faster than using any official cli or any generated query to look how our data is shaped within the database.
3 votes -
Sending arrays as parameters, to allow scaling.
When building simple select queries in GraphQL (really simple ones), the underlying query is being transformed, sending the values through as parameters.
As you can use arrays as parameters, that would allow the DBs to scale as it makes this more robust. Without scaling, it will limit production applications form fully investing.
As an example you run into instances where the select for 50 columns in the schema (a standard employment record, nothing special) is transformed and we end up getting the dreaded 100 parameters error. This is a Postgres issue, but can be avoided.
The Error for the fun…
4 votes -
Rehan
Hello me Rehan
1 vote -
Support inline/embeded types stored as structured JSONB columns
Allow storing structured types in JSONB columns using an @inline (or @embed) directive on the field.
type Address {
street: String!
street2: String
city: String!
state: String!
zipcode: String!
}type User @table {
address: Address @inline # stores as JSONB
}20 votes -
1 vote
-
File Uploads
Store and retrieve large files with Data Connect through an integration with Google Cloud Storage.
25 votes -
Generated SDK types
Given a schema with a nullable type
type MyType @table() {
id: uuid!
nullableString: String
}When running a query that selects records from MyType and filters out null values for nullableString, the generated SDK still types nullableString as string | null (or string? | null). Even though the query ensures no null values are returned for that field.
It would be great if the SDK could be smarter and refine the generated type to just string when the query explicitly filters out null values for that field.
1 vote -
Extension support, i.e. postgis
One of the things that makes postgres great is it's extension support. Inability to integrate with extensions like postgis is a severe blocker.
21 votes -
Automatic GraphQL schema from existing SQL schema
When onboarding an existing postgres database, Data Connect can read the postgres schema and attempt to generate a corresponding GraphQL schema. Users with existing databases can immediately benefit from Data Connect client SDKs, query based auth, and connector connection pooling without manually writing GraphQL that matches their database schema.
2 votes -
GraphQL Federation
Support federating a Data Connect service with other GraphQL schemas using federation protocols. Stitch together existing GraphQL services with Data Connect.
18 votes -
Interfaces, Union types in GraphQL
Support for GraphQL Interfaces or Union Types through the built in GraphQL schema builder tool. This was extensively discussed in the Google Chat group.
14 votes -
Web SDK generation to also export schema types
Currently the dataconnect:sdk:generate command in firebase-tools will generate functions for queries and mutations. There are cases where having TypeScript interface reflections of the schema types would also be beneficial.
AFAIK there's no existing tooling that will conveniently do this mapping (due missing types that one can find in .dataconnect/schema/prelude.gql when the emulator is running).
3 votes -
Managed SQL Schema Migrations
Data Connect automatically queues and applies database schema migrations as you make changes to your application's schema including destructive migration detection and diff approval.
18 votes -
Connect to an existing instance of another project
Allow connections to PostgresSQL instances in other projects using Shared VPC, etc.
14 votes -
1 vote
-
Support storing unstructured json in Postgres jsonb column
Postgres support jsonb column that can store arbitrary jsonb objects, very suitable to store unstructured / semi-structured API output.
Postgres also supports index on fields within jsonb.
Can data connect support jsonb column? Mapping fields of API object to Postgres columns can be a headache
14 votes
- Don't see your idea?