SQL Database Connector Live vs Dev

Hi,

I create a boolean type field in my SQL database, usually called “test”.

Inside Bubble I use the “isn’t live” operator to know if the record comes from live or a development version.

Also, sometimes I add another text field in SQL where I store the name of the version/branch to know which one it comes from specifically in case it is not live.

Now it’s just a matter of filtering the data to only receive or see the data you need.

PS. I also create a querie to remove those records that are test records easily, using the same filter mentioned above.

1 Like