37 questions
0
votes
0
answers
60
views
Connecting to Snowflake using TablePlus
I am using the free version of TablePlus for Windows, but I am unable to connect to Snowflake. I have successfully connected using other tools like DBeaver. Are there any specific points or ...
- 1
-2
votes
1
answer
2k
views
How can I use Laravel Herd to host a SPA with Inertia and React via npm run dev and a singular database with a second project?
I'm working on a Mac osx m2 and have been developing a Laravel SPA with React (jsx) and Inertia for what will be a client facing portal while I plan to continue to use a Laravel Blade template site ...
- 1,209
1
vote
0
answers
464
views
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:...
- 53
3
votes
0
answers
4k
views
psql: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: FATAL: database "<user>" 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 ...
- 31
0
votes
1
answer
435
views
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 ...
1
vote
2
answers
733
views
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@...
- 57
0
votes
1
answer
902
views
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&...
- 1
0
votes
1
answer
31
views
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}','${...
0
votes
0
answers
442
views
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 ...
- 29
0
votes
1
answer
34
views
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 ...
- 1,103
1
vote
1
answer
96
views
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 ...
0
votes
0
answers
29
views
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 ...
- 1
-1
votes
1
answer
1k
views
Error when using AUTO_INCREMENT in TablePlus [duplicate]
I was following a tutorial for Laravel and this course required me to use TablePlus.
I had to create a table with a given query, but it's not working and I am not completely sure as to why it's not ...
- 60
0
votes
2
answers
1k
views
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 ...
- 47
1
vote
0
answers
24
views
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 ...
- 841
1
vote
1
answer
291
views
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.
- 21
2
votes
1
answer
294
views
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
...
- 21
0
votes
1
answer
121
views
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 ...
- 1,490
0
votes
1
answer
289
views
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 ...
- 1,053
0
votes
1
answer
2k
views
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 ...
- 541
0
votes
1
answer
624
views
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 ...
- 31
0
votes
1
answer
1k
views
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!
- 43
2
votes
1
answer
5k
views
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 ...
- 45
1
vote
0
answers
693
views
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-...
- 13
1
vote
2
answers
6k
views
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","...
- 3,132
0
votes
1
answer
1k
views
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 ...
- 326
0
votes
0
answers
168
views
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 ...
- 485
2
votes
1
answer
1k
views
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 ...
- 10.8k
1
vote
2
answers
4k
views
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....
- 3,566
0
votes
1
answer
569
views
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 ...
0
votes
0
answers
233
views
PostgreSQL database should require user password to access, but does not
I created a user with a password for a database and granted SELECT/INSERT/etc. rights for that user on that db.
However, when I connect to the database with the particular user, e.g. with TablePlus, ...
- 89
0
votes
1
answer
505
views
how to create a function or a procedure in tableplus
I am trying to create a simple oracle function in table plus an I always get the following error in
"Query 1 ERROR: ORA-24344: success with compilation error"
Following is the function I am using ...
- 47
0
votes
0
answers
959
views
Laravel Forge DB Mysql Connection via Desktop Client Issue
I have an issue with connecting to my databases via desktop client. I use ssh key to connect to my server via console and I am able to connect to my live server.
But no luck for my database ...
- 371
-2
votes
2
answers
1k
views
Is there a way to get CURRENT_TIMESTAMP to only store date, hours and minutes in a database?
I'm storing data in PostgreSQL with one column set to a default CURRENT_TIMESTAMP. I'm trying to get this default to only store: date, hours and minutes. Does anyone know how I can do it?
I need to ...
- 21
0
votes
0
answers
825
views
MySQL said: There was a problem with your SQL connection - Access denied for user ''@'%' to database
I am using the wpDataTables plugin on WordPress. I am trying to connect to a MySQL database on my local machine. It asks for server, port, database name, user, and password. No matter what I try, I ...
6
votes
2
answers
19k
views
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 ...
- 1,749
0
votes
0
answers
247
views
How to disable one query in Postgres for specified (partioned) table
SELECT COUNT(*) as count FROM "public"."views";
This query executes every time by TablePlus client when I open a partitioned table with many partitions and processed too long time.
How I can disable ...
- 1,135