BuildShip Database
I’m currently working with Firestore on my project and have come across Buildship, which I find very interesting. Regarding the Buildship database, I successfully integrated Firestore and can retrieve documents from my Firestore collection nodes without any issues. However, when I switch to the database view and try to create a table with the same name as my Firestore collection, I receive an error message saying, "There is no data in the Firestore collection." Could it be that this feature is only available for PRO members, or have I misunderstood something?
Solution:Jump to solution
@osmanFirat Both BuildShip database and Firestore database are different. BuildShip DB is an inbuilt Firestore database which comes with your project. It is not the one you access with your associated email outside BuildShip. You can refer to this conversation -https://discord.com/channels/853498675484819476/1246926649686097983/1247116854930047029.
6 Replies
It sounds like you might be encountering an issue with setting up the BuildShip Tables feature. The BuildShip Tables feature is available for users on all plans, not just PRO members. Here are the steps to ensure you are setting up the table correctly:
1. Access BuildShip Table: You can access BuildShip Tables directly from the CRUD node you are using. Once you click on the table icon available on the BuildShip Database node, you'll be prompted to create a new table or select an existing table.
2. Creating Tables: There are two ways to create a BuildShip Table:
- Set up an existing collection: If you have an existing Firestore collection, you should be able to set it up as a table. Ensure that the collection name matches exactly.
- Creating a new table: You can also create a new table and then import the existing data from your Firestore collection.
3. Import Existing Data: After setting up the table, make sure to click on “Import Existing Data” to import the data into your table. Follow the step-by-step guided process to import your data and hit “Finish”.
For more detailed information, you can refer to the BuildShip Tables documentation.
If you continue to experience issues, it might be a good idea to submit your question via the in-app support button for more personalized assistance.
Solution
@osmanFirat Both BuildShip database and Firestore database are different. BuildShip DB is an inbuilt Firestore database which comes with your project. It is not the one you access with your associated email outside BuildShip. You can refer to this conversation -https://discord.com/channels/853498675484819476/1246926649686097983/1247116854930047029.
@Gaurav Chadha oh now i understand. and the "Chat with your Database" are only working with the BuildShip DB? In my app, I also want to include data for analyses and statistics that users can view, such as how many requests they have sent, etc. For this use case, I experimented with BigQuery but found it a bit complicated. Would you say that Buildship DB could also be used for such a use case, since it allows the use of SQL databases, making querying the Data to the app easier than with BigQuery? Or do you see these as two separate things? Additionally, are SQL databases in Buildship DB only available in the Pro version?
Nope, it should work with any database, you can add any node in the Assistant to chat with, example google sheets, airtable query, firestore colleciton query (use claude for firestore works best)...
All the databases can be conencted and accessed in all plan.
@Gaurav Chadha thank you! But to use an SQL BuildShip DB instead of the inbuilt NOSQL Firestore database, are only avaliable in the pro plan?
no, there is only one BuildShip db available, there is no such database made separate for pro plan.