Discussions
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.
Posted by Erik Lott 1 day ago
more unsupported functions
Looks like:
ALTER TYPE
ALTER FUNCTION
should be added to the list of unsupported functions
Posted by lynnae 3 days ago
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)
Posted by Gray JN 6 days ago
How can i spam emails
How can i spam emails for free
Posted by Kingdsix 26 days ago
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.
Posted by Joe Peruzzi about 1 month ago
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.
Posted by Brandon Govindarajoo about 1 month ago
Cannot run query or view any records.
It keeps saying "Disconnected" on the query box.
Posted by Jay Salway 2 months ago
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?
Posted by Roland 3 months ago
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
Posted by Greg 3 months ago
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.
Posted by Souvik Mitra 3 months ago