Ask a Question

Attempting Query Via Axios From React App, Receiving Cors Error

I am somewhat familiar with the error, Access-Control-Allow-Origin must be set on the server side to allow a particular domain to send requests to the API. However, I have not seen anything regarding Cors in the guides or settings thus far. ( Assuming the feature doesn't exist due to security reasons, but I'm unsure ) I'm guessing I'll be required to set up a middleware like .Net, but I'm wondering if I can avoid that. All that being said, big thanks to the team behind bit for putting all this together.

How Extract SQL Query to CSV on a Schedule?

I planned to put some commands into a file (PSQL loggin, Copy Select to CSV) and schedule it to run. However, when connecting with PSQL it could not find the tables in my repo. Is there a better and easier way to do this (scheduled query and csv extract)?

How Connect PGAdmin to Bit.IO?

Using PGAdmin program I went create a database connection, put in a variety of values and settings, but nothing works to connect. Please can someone advise on the settings/values needed to connect in PGAdmin?

Can I Create View Only Users?

How can I enable specific users to access my database for view and download only (no write)? I'm thinking I can download the table, then upload it to another repo, and give out the token of that other repo to the user, but this is an inefficient way. Any suggestions?

Unable to upload new tables from CSVs

Background: I needed to re-add an existing table to my repo because I'd truncated a timestamp column and now need the full date for further analysis. I use your site to do contract data analysis. Problem: I keep getting an error whenever I try to upload any csv file to create a table. >>> "If you recently created the table the import job may have failed -- please check your email to see if you received an update from us. (error ID: d32a1592-5e9d-4da0-a1b4-7aab0ebb9921)" If I reload the page, the newly "added" table disappears. Please help!

/import/json/ api endpoint shows success but "failed to upload" message

Trying to import using this endpoint (in R with httr). I get a 200 status code and message "Uploaded file username_d6ffedf7-6245-4c15-9630-6b28f64d6da2.json saved successfully from sender [email protected] and an ingestion job has been created with the status RECEIVED" and then a red banner on the bitio page saying username_d6ffedf7-6245-4c15-9630-6b28f64d6da2.json upload failed. Please advise..? thanks

petl ETL library insert data

Hi i am trying to load data into my database using petl module but it doesn't work unfortunately. petl.io.todb(data, conn, '\"xxxx/xxx\".\"xx\"') psycopg2.DatabaseError: LOG: Error occurred when processing query: relation "".""xxxx/xxx"."xx"" does not exist (error ID: ab375ee7-621d-456c-b8d7-096f6d3a5a9e) can we use this library or we have to stick to bitdotio library?

Is this really postgres or a NoSql database that trys to process postgres sql

I am not sure what the underlying database structure is. Will help to know for architecture reasons.

User isolation to prevent resource hogging

Does bit.io isolate users in any way so that one user can't run a huge CPU intensive query that slows down processing for all the other users? If so, how is this done?

Number of Live Connections

How many live persistent connections am I allowed to have. Or am I supposed to open and then close connections after each transaction.