tsg Comments - Answer Overflow

tsg

•Created by brownfox.dev on 11/7/2024 in #general

Hey, I got xata working with kysely on

I think you shouldn't need it, it goes over HTTP so the connection is not a concern. @SferaDev correct me if I'm wrong please

3 replies

XXata

•Created by Kaligraphy on 11/5/2024 in #general

Good day everyone, there is a little UI

thanks for th report! I've forwarded it

1 replies

XXata

•Created by JustSomeDev on 10/18/2024 in #help

Xata dedicated instance version string

awesome, thanks so much!

6 replies

XXata

•Created by JustSomeDev on 10/18/2024 in #help

Xata dedicated instance version string

thanks for updating!

6 replies

XXata

•Created by JustSomeDev on 10/18/2024 in #help

Xata dedicated instance version string

hey, here it is: PostgreSQL 16.4 on aarch64-unknown-linux-gnu, compiled by aarch64-unknown-linux-gnu-gcc (GCC) 9.5.0, 64-bit

6 replies

XXata

•Created by Diego Nelson on 10/16/2024 in #help

File-Type Columns no work

3 replies

XXata

•Created by _4kb on 10/9/2024 in #help

Unable to get query using dynamic table

@SferaDev is the expert here

10 replies

XXata

•Created by _4kb on 10/9/2024 in #help

Unable to get query using dynamic table

I'm thinking that the issue for you might be that userId is of type string

10 replies

XXata

•Created by _4kb on 10/9/2024 in #help

Unable to get query using dynamic table

10 replies

XXata

•Created by _4kb on 10/9/2024 in #help

Unable to get query using dynamic table

can you try it by running in the Queries (Typescript) with a snippet like this:

// Generated with CLI
import { getXataClient } from "./xata";
const xata = getXataClient();

const table = "test";
const userId = "hi";
const result = await xata.db[table].filter({ userId: { $is: userId } }).getFirst();
console.log(result);

// Generated with CLI
import { getXataClient } from "./xata";
const xata = getXataClient();

const table = "test";
const userId = "hi";
const result = await xata.db[table].filter({ userId: { $is: userId } }).getFirst();
console.log(result);

10 replies

XXata

•Created by qwame on 10/9/2024 in #help

Sql over http unused parameters.

otherwise, what are the types for name and date, and can you try running in the Queries playground like the above?

7 replies

XXata

•Created by qwame on 10/9/2024 in #help

Sql over http unused parameters.

is the table literarly named "table"? If yes, it requires quoting as "table"

7 replies

XXata

•Created by qwame on 10/9/2024 in #help

Sql over http unused parameters.

7 replies

XXata

•Created by Storm on 9/17/2024 in #help

identityName.startsWith is not a function

amazing

9 replies

XXata

•Created by atan2 on 10/6/2024 in #general

is that a prank ?

hi, the reason is that if you have data above the free tier, or dedicated clusters started, we need to clarify what happens to them. A quick email there with your workspace ID and we'll downgrade it and also consider a refund in case it makes sense

2 replies

XXata

•Created by Black Panther on 10/5/2024 in #help

unable to execute start operation: pq: syntax error at or near ")"

so something like:

[
    {
        "create_table": {
            "name": "org",
            "columns": [
                {
                    "name": "id",
                    "type": "integer",
                    "pk": true
                },
                {
                    "name": "clerk_id",
                    "type": "integer",
                    "unique": true,
                    "nullable": false
                },
                {
                    "name": "slug",
                    "type": "varchar(255)",
                    "unique": true,
                    "nullable": false
                },
                {
                    "name": "name",
                    "type": "varchar(255)",
                    "unique": false,
                    "nullable": false,
                    "default": "''"
                }
            ]
        }
    }
]

[
    {
        "create_table": {
            "name": "org",
            "columns": [
                {
                    "name": "id",
                    "type": "integer",
                    "pk": true
                },
                {
                    "name": "clerk_id",
                    "type": "integer",
                    "unique": true,
                    "nullable": false
                },
                {
                    "name": "slug",
                    "type": "varchar(255)",
                    "unique": true,
                    "nullable": false
                },
                {
                    "name": "name",
                    "type": "varchar(255)",
                    "unique": false,
                    "nullable": false,
                    "default": "''"
                }
            ]
        }
    }
]

3 replies

XXata

•Created by Black Panther on 10/5/2024 in #help

unable to execute start operation: pq: syntax error at or near ")"

hi, I think the issue is not with varchar(255) but with the default value for the name column. Try passing it like this: "default": "''"

3 replies

XXata

•Created by atan2 on 10/2/2024 in #help

Do i need to create a cluster to have an autoscaling DB ?

you'd typically want to use a connection pool in your application. What language / framework do you use?

10 replies

Gaming

Programming