Stack Overflow
Stack Overflow

Questions tagged [valentina-studio]

valentina-studio is c++/QT cross-platfrom graphical database management and development software produced by Paradigma Software, Inc. for MySQL, MariaDB, SQLite, PostgreSQL and Microsoft SQL Server. Exists totally free edition. PRO edition adds more productivity features and Report Editor for Valentina Reports.

13 questions
12
votes
2 answers

How can I kill an unresponsive query in Valentina Studio (for PostgreSQL)?

Is there a way to kill a slow or unresponsive query in Valentina Studio as there is in MySQL Workbench?
jarkub
  • 141
  • 4
8
votes
1 answer

How do you make a primary key with Valentina Studio?

Creating a table with fields in Valentina Studio with a primary key 'id'. How do you set a primary key with Valentina? I know how to in the terminal.
Mark A
  • 1,995
  • 4
  • 18
  • 26
6
votes
1 answer

Valentina Studio inset a millions of rows

I have txt file with insert statements with few millions of rows. I want to insert them inside database, but I can't copy and paste in Valentina because it is too much for SQL window. How do I insert in batch from a file?
Marko Zadravec
  • 8,298
  • 10
  • 55
  • 97
5
votes
1 answer

Create table error in Valentina Studio

I am unable to create a table in Valentina Studio in my sqlite database. Using another application called Datum, I am able to open the sqlite database 'data.db' and run the query 'CREATE TABLE a(b INT, c INT)' successfully. When I open Valentina…
user3367130
  • 163
  • 8
2
votes
0 answers

How can I do you make a primary key with Valentina Studio?

Creating a table with fields in Valentina Studio with a primary key 'id'. How do you set a primary key with Valentina? I know how to in the terminal.
oleg_miheev
  • 29
  • 2
2
votes
0 answers

Connection to MySQL Server via MySQL Workbench errors

So I am trying to connect to a MySQL server using MySQL workbench. Now I have successfully connected using Valentina Studio. Keep in mind I am using MacOS Sierra. I get the error: Error opening SSH connection to server…
Micheal
  • 309
  • 4
  • 16
2
votes
1 answer

How do you share diagrams in Valentina Studio (DB)

I'm just getting familiar with Valentina Studio. It seems like a very useful tool--with easy drag/drop diagrams that stay in sync with actual schemas. In my particular case, I'm using it with postgres. What's not clear to me is, where are diagrams…
Ryan
  • 1,171
  • 1
  • 10
  • 23
1
vote
0 answers

Valentina Studio and postgres configuration

I am trying to set up postgressql with valentina studio. My postgres access doesn't require password but my Vstudio requires a password and its not letting me connect to my postgres databases. Does anyone know what can be done here? I am using…
redd
  • 79
  • 1
  • 6
1
vote
1 answer

Psql - 'database does not exists' while it does and was created in Valentina Studio

I have started to learn about SQL and installed Valentina Studio & PSQL on my Ubuntu. I have defined a password via sudo -u postgres psql postgres and then \password postgres. Then I have entered Valentina Studio and connected to this server with…
NoobCoder
  • 513
  • 3
  • 18
1
vote
1 answer

Postgresql between dates

i am learning SQL at the moment and i was wondering if somebody could help me. I´m working with postgresql and my task ist to write a query which shows all the, in this case, employees having their 25th anniversary, lets say tomorrow or in a…
skimmy
  • 11
  • 4
1
vote
2 answers

obtaining the current timestamp in mysql in Valetina studio

I am learnig laravel from Laracast videos and using Valentina Studio as GUI to have a look at the database and connect using mysql . I have composer and mariadb installed on linux. so, when I was creating a new field in an empty table which has…
Nitz
  • 45
  • 9
0
votes
0 answers

How can I upload a JSONL file to write queries on in Valentina Studio?

How can I upload a JSONL file to Valentina Studio to write SQL queries on? I tried to load dump to a database, but it is not working.
Elif
  • 1
0
votes
1 answer

How to assign variables in postgres sql

DECLARE eno integer := 0; emp string ; select into eno emp_no from "public"."salaries" GROUP BY emp_no ORDER BY max(salary) DESC LIMIT 1; -- gives the emp_no of the employee with maximim salary select INTO emp CONCAT(first_name, ' ' , last_name)…
Aaron Rock
  • 1
  • 1