Discussions

Is bit.io intended to be used as a saas cloud database service? If so, what region(s) will the database be served from? It's critical that our app and database are in the same region. Thanks.

Looks like: ALTER TYPE ALTER FUNCTION should be added to the list of unsupported functions

When I try to run the fowwlowing code my node.js works fine for a few minutes but then randomly crashes and gives the error listed at the bottom of this page. Code: const { Client } = require('pg'); const client = new Client({ user: 'procces.env.USER', host: 'db.bit.io', database: 'procces.env.DATABASE', password: 'procces.env.PASSWORD', port: 5432, ssl: true, }); client.connect(); client.query('SELECT * FROM "HPI_AT_state" limit 10;', (err, res) => { console.table(res.rows); }); Error: node:events:491 throw er; // Unhandled 'error' event ^ Error: Connection terminated unexpectedly at Connection.<anonymous> (node_modules/pg/lib/client.js:132:73) at Object.onceWrapper (node:events:627:28) at Connection.emit (node:events:513:28) at TLSSocket.<anonymous> (node_modules/pg/lib/connection.js:107:12) at TLSSocket.emit (node:events:525:35) at endReadableNT (node:internal/streams/readable:1359:12) at process.processTicksAndRejections (node:internal/process/task_queues:82:21) Emitted 'error' event on Client instance at: at Client._handleErrorEvent (node_modules/pg/lib/client.js:319:10) at Connection.<anonymous> (node_modules/pg/lib/client.js:149:16) at Object.onceWrapper (node:events:627:28) [... lines matching original stack trace ...] at process.processTicksAndRejections (node:internal/process/task_queues:82:21)

How can i spam emails for free

I see in 1.0 that bit.io supported REST API calls to import files but now it seems that support has been removed in 2.0. Is there a hidden API somewhere that this feature was moved to? I'm having a hard time finding any actual docs on the api itself. Any help would be appreciated.

So If I have a table with 1M rows, and I do 10 select count(*) that will cost $5. Almost seems like an impossible price barrier for any level of modern analytics outside of very small tables.

It keeps saying "Disconnected" on the query box.

Hi there, it is not clear from the docs, where bit.io data is stored. I am working on an application where privacy laws may become an issue, if so, does the paid version give the opportunity to change the region or is all data stored in the US?

There was a way to manage tables through the UI. That was documented here - did that feature move? It was really nice to be able to edit tables without SQL. https://docs.bit.io/docs/schema-management

DROP TABLE IF EXISTS "alanparadise/nw"."shippers" - This is my SQL statement I am not able to find anything wrong here but it is showing as an unsupported operation. Any reason why this could be happening? I checked the help section of bit.io and the syntax seems to be the same so I'm not understanding what they exactly mean by unsupported operation here.