Stack Overflow
Stack Overflow

Questions tagged [table-plus]

TablePlus is a GUI tool for managing relational databases, such as MySQL (as well as some NoSQL databases such as MongoDB). Use this tag for questions regarding the TablePlus tool.

TablePlus is a commercial GUI tool for managing relational databases including, among others, SQLite, MySQL and PostgreSQL as well as some NoSQL databases such as mongoDB and CASSANDRA. It can be used to perform nearly all database management tasks, including manipulating data, migrating databases, managing users and performing backups.

37 questions
0
votes
1 answer

Cant connect to Database in a docker container with Table plus using vscode devcontainer

Hello i need some help im using TablePlus to connect to my database but this isn't working with adding the forwardPorts devcontainer.json { "name": "Node.js & PostgreSQL", "dockerComposeFile": "docker-compose.yml", …
damlam
  • 1
0
votes
1 answer

error while inserting multiple inputs in sql

This is the query I used const dbQuery = INSERT INTO tasks (activity,type,participants,price,link,key,accessibility) VALUES ('${activity}','${type}','${participants}','${price}','${link}','${key}','${accessibility}'); This is the error I…
Sharan Poojary
  • 3
  • 1
0
votes
0 answers

connection to server at "127.0.0.1", port 5432 failed: FATAL: role "username" does not exist TablePlus

I run PostgreSQL with docker but when I tried to connect it with TablePlus I got an error connection to the server at "127.0.0.1", port 5432 failed: FATAL: role "root" does not exist but I clearly see it in my psql under the Role Name. How to…
Md Firoz Mia
  • 21
  • 7
0
votes
0 answers

TablePlus Error: add gpg key on Ubuntu 22.04

I added the below command and got an error. How can i fix this? wget -qO - https://deb.tableplus.com/apt.tableplus.com.gpg.key | gpg --dearmor | sudo tee /etc/apt/trusted.gpg.d/tableplus-archive.gpg Add TablePlus gpg key error
alisidaniel
  • 11
  • 1
  • 5
0
votes
1 answer

mysql - problem with create another table with relation

When I want in tableplus create another table with relation to table 'users', I get error: Query 1 ERROR: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near…
mxcdh
  • 805
  • 3
  • 10
  • 20
0
votes
0 answers

updating table with SELF JOIN results in "The target table ORDER_HEADER of the UPDATE" is not updatable

Basically put, In MySQL I'm attempting to update a flag on the premise that another flag is enabled for all given 'orders', and the oldest flag of said orders is greater than 7 days old. There's a couple things I'm playing around with in the where…
AniG
  • 1
0
votes
2 answers

FATAL: password authentication failed for user "root" in TablePlus

So I was following up with a udemy course on backend development using PostgresSQL, Docker, GO, Kubernetes and got stuck here in the authentication part. I created my postgresql container : docker run --name postgres12 -p 5432:5432 -e…
Midas
  • 35
  • 2
  • 7
0
votes
1 answer

How to Solve Getting Different Result of Query in MAMP MySQL Server and TablePlus MySQL Server?

I have a table and I want to run a query, first I've tried the MySQL server on MAMP and I've got this result: After that, I imported my table into the TablePlus MySQL server, and this time I'm getting a different result. Why the result of this…
Hanie Asemi
  • 1,318
  • 2
  • 9
  • 23
0
votes
1 answer

How can I securely connect to databases in GKE using GUI tools?

I'd like to connect to my databases in GKE using GUI tools but I don't want to expose the services to the world. What are some ways to accomplish this? Update: for instance, I'd like to use TablePlus to connect to a mysql pod inside the cluster.
Jason M
  • 1,013
  • 13
  • 25
0
votes
1 answer

Trying to connect to production Pgsql DB but got connection time out (0x0000274C/10060)

Note: My database works because I am able to migrate and query from within the application. So I've setup my application and database on digital ocean's new "App" feature. And now I am trying to connect to the production database but I'm getting…
Napmi
  • 521
  • 2
  • 13
  • 32
0
votes
1 answer

Year-Over-Year Change or Previous Year Values in MySQL

I have a table that looks something like this Date Number of products Department Sub-Department 01-01-2019 10 A Ax 01-01-2019 4 A Ay 02-01-2019 14 B By 02-01-2019 15 A Ay The table contain data from 2018 to current date. For each…
noob5eva
  • 31
  • 6
0
votes
1 answer

I am not able to connect my TablePlus to digital ocean postgresql database

I am getting the error Could not connect to server connection timed out. I followed This. Kindly help me. Thanks!
Kanav Raina
  • 43
  • 1
  • 9
0
votes
1 answer

How to import a CSV with Japanese (utf-8) using TablePlus?

I'm using TablePlus import tool to import CSV to my local SQL Server DB. The files are big enough to avoid using Excel spreadsheet (~70 Mb), and when opening the tool it appears to support Japanese alphabet: I set all columns to be varchar(max),…
goidelg
  • 316
  • 2
  • 16
0
votes
0 answers

Unable to connect to local Postgres via GUI

I recently ran a Postgres via Docker where in I have a Dockerfile that copies an init script to add new user, enable UUID extension, created database and grant privileges. I can login using the default user "postgres" but not the second account…
Rye
  • 445
  • 4
  • 15
0
votes
1 answer

Why does Datagrip say user/pass wrong when they work in Tableplus?

I have Tableplus and it it connects and runs queries on a SQL Server database just fine. When I replicate those connection settings exactly in Datagrip, it fails to connect and complains the username and password are incorrect. I have tried several…
Chor Hatara Hud'u Keturi
  • 581
  • 1
  • 8
  • 20
1
2
3