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.
Posted by soloyolorolo123 6 months ago
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)?
Posted by Eric 6 months ago
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?
Posted by Eric 6 months ago
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?
Posted by Eric 7 months ago
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!
Posted by Ben Reedus 8 months ago
/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
Posted by murrayjarvis 8 months ago
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?
Posted by Joseph Muiruri 8 months ago
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.
Posted by Brandon Govindarajoo 8 months ago
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?
Posted by Mark Burggraf 9 months ago
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.
Posted by Brandon Govindarajoo 9 months ago