Discussions

Ask a Question

What are your US regions?

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.

more unsupported functions

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

Bit.io randomly terminating connecting with node.js.

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)
ANSWERED

How can i spam emails

How can i spam emails for free
ANSWERED

REST API Import File Support

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.

Pricing Model rows queried

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.
ANSWERED

Cannot run query or view any records.

It keeps saying "Disconnected" on the query box.
ANSWERED

Region for Bit.io data

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?

GUI table editing

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
ANSWERED

DROP command not working

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.