The Rows.Scan method takes as many parameters as there are columns in the SQL query. As the query being executed is SHOW COLUMNS FROM my_table I cannot omit any column which I don't require (or ca...

When calling the saveAll method of my JpaRepository with a long List<Entity> from the service layer, trace logging of Hibernate shows single SQL statements being issued per entity. Can I for...

I was trying to migrate from Another RDBMS to cockroachDB but I think there is no such functionality like stored procedures in Cockroach. So what is the best alternative to make a stored procedure ...

Is there any way to do local development with cloud spanner? I've taken a look through the docs and the CLI tool and there doesn't seem to be anything there. Alternatively, can someone suggest a SQ...

How can I select random rows from a SQL table using CockroachDB? For example, if I have a number of questions and I want to generate a different sequence each time a student loads them.

I have a table with 2 columns; ID (int) and EntityData (JSON). I have created a filter object in form of a Dictionary in C#. I want to fetch all rows which satisfy the key-value pair data in my fil...

I would like to accomplish 2 things: 1) Start a CockroachDB cluster with docker compose (works) 2) Execute SQL commands on the cluster (I want to create a Database) My Docker File Looks like thi...

I've set up and deployed a Kubernetes stateful set containing three CockroachDB pods, as per docs. My ultimate objective is to query the database without requiring use of kubectl. My intermediate o...

Is there a way to optimize the insertion of a lot of data into an empty CockroachDB table?

I’m building an app on CockroachDB and need to do full-text search. Does CockroachDB provide that built-in?

When I connect to CockroachDB using cockroach sql, I have to prefix all table names with the name of the database: SELECT * FROM db.table1; If I forget to specify the database, like SELECT * FR...

In MySQL, I can use AUTO INCREMENT to generate unique IDs for my application’s customers. How do I get similar functionality when using CockroachDB?

I tried using Oracle's DESCRIBE TABLE... statement in CockroachDB and got a syntax error. What’s the equivalent command?

When should I use batches and when should I use transactions? Can I embed a transaction in a batch? A batch in a transaction?