python (65.2k questions)
javascript (44.3k questions)
reactjs (22.7k questions)
java (20.8k questions)
c# (17.4k questions)
html (16.3k questions)
r (13.7k questions)
android (13k questions)
Vitess v8 PlanetScale MySQL db constraint error
Using Vitess v8 (PlanetScale DB)
Table:
CREATE TABLE `Channel` (
`id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
`guildId` INTEGER UNSIGNED NOT NULL,
`name` VARCHAR(64) NOT NULL,
`descr...
Average Capitalist
Votes: 0
Answers: 1
Vitess vtctl cannot connect to zookeeper topo server
I am trying to setup a vitess cluster on my local. I chose zookeeper as my topology server and I have used docker-compose to set it up.
version: '3.9'
services:
zoo1:
container_name: zks1
i...
Satyaki Das
Votes: 0
Answers: 0
How to select data depending on data from the same table with custom field in SELECT?
I have a query to fetch closest airports to the airport:
SELECT *,
(
6371 *
acos(cos(radians(55.966324)) *
cos(radians(latitude)) *
cos(radians(longitude) -
radians(37.416573)) +
sin(radia...

JamesJGoodwin
Votes: 0
Answers: 1
Which distributed SQL databases put data from different tables with the same tenant in the same node?
I’m designing a SQL data schema with many tables that have a compound primary key of (customer_id, id). The application will frequently need to run JOIN queries to assemble data. However, it should ne...
Calebmer
Votes: 0
Answers: 2