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
5
votes
2 answers

Connecting to my local docker Database Instance from Table Plus

I have created a local docker wordpress instance and I am trying to connect to the database with a SQL Client (in my case TablePlus) but I am having trouble. I created the docker containers from a docker-compose.yml file shown here: version:…
David Jarrin
  • 1,635
  • 4
  • 19
  • 40
2
votes
1 answer

Replace with update in cassandra

I wanto update string to another string with method replace. I have been update success with MYSQL, but cassandra, I have a error. Thank for all! This is commandline with MySQL: update table_1 set field_1 = replace(field_1, 'hello',…
Liam Nguyen
  • 21
  • 2
2
votes
1 answer

How to upgrade the pg_restore in docker postgres image 10.3 to 10.5

I use tableplus for my general admin. Currently using the docker postgres image at 10.3 for both production and localhost development. Because tableplus upgraded their postgres 10 drivers to 10.5, I can no longer use pg_restore to restore the backup…
Kim Stacks
  • 10,202
  • 35
  • 151
  • 282
1
vote
0 answers

Can't connect to DB with Tableplus/Laravel forge - wrong username or password

I have a Laravel project that I manage with Laravel forge. The website is provisioned, the database is correctely working. I can even fully access the DB trough commands on Git bash by doing ssh forge@ and mysql -u root -p…
Marco Rifo
  • 55
  • 6
1
vote
1 answer

MySQL 5.7 using JSON variable as counter to rank rows in Laravel 5.4

I am using MySQL 5.7 and trying to emulate rank(which is not available in 5.7) using JSON variable. The problem is that in Laravel DB or PDO query below doesn't work correctly but works fine in TablePlus. The idea of a query to count rows by groups…
Nikita Volchok
  • 11
  • 4
1
vote
0 answers

How to make condition in a UNION result?

How to make condition in a UNION result? EXPLANATION: I'm doing a UNION search, it's working correctly. The problem is to make a new filter on the last WHERE. It is not being applied as can be seen in the image. CODE: SELECT * FROM ( …
Tiago
  • 797
  • 1
  • 10
  • 23
1
vote
1 answer

I got error while installation (TablePlus database management) in Linux

Add TablePlus gpg key wget -qO - http://deb.tableplus.com/apt.tableplus.com.gpg.key | sudo apt-key add - got error: gpg: no valid OpenPGP data found.
Restored
  • 21
  • 3
1
vote
1 answer

Just installed Laravel Sail. How to connect to database?

I am trying to connect and create schema using TablePlus (or PhpStorm) in my database since May of 6. Please understand me what I should to do? I will discribe what did I do step by step. $ laravel new app. I have got /app/ folder with my new…
stas12go
  • 33
  • 1
  • 6
1
vote
0 answers

Why I get "FATAL: password authentication failed for user postgres

I set up docker image for and a timescaledb postgres database. The tutorial states to run "docker run -d --name timescaledb -p 5432:5432 -e POSTGRES_PASSWORD=password timescale/timescaledb:2.0.0-pg12" for initial local setup. I am trying to connect…
Sandcobra
  • 13
  • 2
1
vote
2 answers

PostgreSQL import from CSV NULL values are text - Need null

I had exported a bunch of tables (>30) as CSV files from MySQL database using phpMyAdmin. These CSV file contains NULL values like: "id","sourceType","name","website","location" "1","non-commercial","John Doe",NULL,"California" I imported many such…
Coola
  • 2,934
  • 2
  • 19
  • 43
1
vote
2 answers

cannot connect to PostgreSQL DB running on EC2 instance

I have a simple PostgreSQL DB running on an EC2 instance. ubuntu@ip-172-31-38-xx:~$ service postgresql status ● postgresql.service - PostgreSQL RDBMS Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled) …
Fisher Coder
  • 3,278
  • 12
  • 49
  • 84
0
votes
0 answers

FATAL: password authentication failed for user "root" postgresql even with correct password

I'm following a tutorial and it had some docker involved. I started a postgres instance by using docker run --name postgres12 -p 5432:5432 -e POSTGRES_USER=root -e POSTGRES_PASSWORD=secret -d postgres:12-alpine This command run successfully but…
Khánh Duyên
  • 3
  • 3
0
votes
0 answers

psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: database "" does not exist

I tried running a postgres server to viewing my databases with TablePlus after not doing so for a while. Running the server: brew services start postgresql Warning: Formula postgresql was renamed to postgresql@14. Bootstrap failed: 5: Input/output…
Eliott
  • 1
  • 2
0
votes
1 answer

Unsure why psql says table is empty but tableplus returns rows

What am I missing? I've connected on console to a DB I have populated with data, using a socket connection. I've validated that the table in question has the rows I expect. When I try and run a SELECT statement in psql the response comes back with…
machina.ex.canon
  • 15
  • 5
0
votes
0 answers

Tableplus - multiple line comment doesn't work

In the manual for Table plus it's written that to comment/uncomment multiple lines you shall use shortcut ⌘ + /. But it doesn't work, instead the menu 'Help' is expanded. I'm certain that it have worked before, maybe not on this machine and with…
mathsson
  • 1
1
2 3