Discussions

Ask a Question

Branching on the roadmap?

Do you have any plans to add support for branching? E.g. how PlanetScale added for MySQL. Thanks!
ANSWERED

How could I change the font size in the editor?

How could I change the font size in the editor?

DataGrip fails to introspect [99999] Unable to parse URL.

DataGrip connects to Bit.io database properly but cannot introspect the database saying `[99999] Unable to parse URL.`. Also not available to run any queries from query console.
ANSWERED

Microsoft Access connection

Maybe requires a paid tier. I believe it requires a dedicated persistent connection that can be faked maybe. I think this would be a beneficial addition.
ANSWERED

Backups and availability

Hi, I'm currently on the Free tier. A few questions: - Are backups/snapshots automatically taken and managed? If yes, can I download/access these snapshots? If not, how careful do I have to be? - Have there been any outages or downtime? Does it affect everyone equally or do Free plans get affected more?
ANSWERED

Prisma Connection Not Working

Prisma connections to my database have recently stopped working, throwing PrismaClientInitializationError due to timeout or failed connection. When connecting to `[postgres connection string]/username.validdatabase` I get a 'Can't reach database server`. If I change this to `[postgres connection string]/username.randomstring` I get an authentication error as expected. Accessing manually through psql CLI works fine, so I think it could be an issue with how your system is handling the '/' -> '.' replacement in connection strings? (as instructed in https://docs.bit.io/docs/connecting-via-prisma)
ANSWERED

pricing schema

Hi I am not sure I fully understand the pricing, could you help me? For example if I query "select * from table limit 100" I will "pay" for 100 rows read. If I alter a table, let's say I add a column, how many rows i would read? The entire table? And if i write a new row? I would use 0 rows read, right?
ANSWERED

ERROR:root:(psycopg2.OperationalError) SSL connection has been closed unexpectedly

I can't ever do any writes. I keep getting this error. What am I doing wrong?
ANSWERED

COPY FROM DOCUMENTATION

In the documentation, the only info re: COPY FROM in psql is: ``` Through a Client Once you connect a database client to bit.io, you can upload data by making a SQL "INSERT INTO" or "COPY FROM" query. ``` I've tried multiple attempts always with the same error: command: `COPY table_name FROM '/path-to-csv/file.csv';` error: ``` ERROR: COPY to/from a filename is not supported DETAIL: Visit docs.bit.io for more detail how to COPY HINT: Use STDIN or STDOUT instead ``` Please could you tell me what I'm doing wrong and/or add more details to the documentation. Thanks
ANSWERED

Overwrite table option when importing

Hi there, Firstly, love the simplicity of bit.io, great UX for getting started. One thing that would be nice is to have an overwrite option when uploading data. I.e. it runs DELETE FROM <Table name> before importing the data.