1. Vladimir Esipov
  2. Valentina Studio
  3. Среда, Декабрь 06 2023, 01:01 PM
  4.  Подписаться через email
At the moment, only DBeaver allows you to work with this excellent DB from the GUI.

It turned out to connect to DuckDB via ODBC in the environment VStudio 13.6.1(x64) Windows 11(x64)
Download the nightly build of duckdb/v0.9.3-dev1100(windows_amd64) from the link
https://artifacts.duckdb.org/latest/duckdb-binaries-windows.zip

Install DuckDB ODBC driver
Create a DuckDB database file like 'E:/duckfile.db'.
Register a system DSN for this file, for example with the name 'duckfile'.
Create an ODBC connection in the Vstudio:

DSN name: duckfile
user: sa

Do not check the connection when creating. Save. Connect.
If you select this database in the 'Databases' tab, the studio will crash.
Therefore, immediately open the SQL editor and work from it.
==========================================================================
Let's check by executing queries in the SQL editor, for example:


SELECT version(); --> v0.9.3-dev1100
PRAGMA platform; --> windows_amd64

-- set the memory limit of the system to 1GB
SET memory_limit='1GB';

-- configure the system to use 2 threads
SET threads TO 2;

SELECT * FROM duckdb_settings() WHERE name = 'duckdb_api';

> name value description input_type
> duckdb_api duckdb/v0.9.3-dev1100(windows_amd64) odbc DuckDB API surface VARCHAR

SELECT * FROM duckdb_settings();

SELECT [1,2,3] as list_value, (1,2,3) as array_list;

SELECT (['a', 'b', 'c'])[3];

CREATE TABLE t1 (i INTEGER, j INTEGER);
INSERT INTO t1 SELECT 1, 2;
INSERT INTO t1 SELECT 2, 3;

SELECT * FROM t1;

PRAGMA table_info('t1');

-- Let's see which extensions are enabled by default.

SELECT * FROM duckdb_extensions();

SELECT * FROM read_csv_auto('E:/ADR.txt') LIMIT 100; --> OK

SELECT * FROM read_parquet('E:/AMK.pqz') LIMIT 100; --> OK


etc.

And all this happiness in one 24 MB DLL file, no dependencies.
Because DuckDB itself can handle a huge number of databases and data sources,
the studio will automatically acquire many features, in case of a small “finishing with a file” and the desire to do this work...

It would be great if the studio team found an opportunity to respond to my and Tyler’s proposal...
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Hi Vladimir,

Thank you very much for this post, and to Tyler.

With sure we can consider adding it, at least step by step,
more than we have done around MongoDB during the last 1.5-2 years
by adding it to Valentina Studio and Reports.

We have tasks to do, I guess up to Feb 15.

After that, we can look in this direction I guess.


FIXING the ODBC crash you mentioned, I think that should be the first step,
which will allow us to start getting acquainted with this database.
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Hi, Ruslan!
Hope you achieved all your goals by February 15th?

Regarding the topic under discussion - a new version of DuckDB 0.10 has been released.
The data storage format has been stabilized. No new features are planned between 0.10 and 1.0. The goal is to focus on stability and reliability.
Release 1.0 is planned for the first half of 2024.

So, what are your plans for DuckDB ?

DuckDB is licensed by MIT and written in C++, meaning the development environment is native to you and the code is open. Considering that there are practically no convenient IDEs for DuckDB, and there is a demand for them, this will be a good marketing step to promote VStudio.

As for full FIXING the ODBC crash, i.e. with the ability to see database objects in the Studio panels - this will still require a description of the metadata and data types of DuckDB.

Make up your mind
Комментарий
There are no comments made yet.
Lynn Fredricks Ответ принят
Hi Vladimir,

We normally target February 14 for release of our major updates, but we got a bit behind this year.

We managed to get 13.9 out the door on the 14th. We have to get Valentina 14 out the door before seriously assessing support for DuckDB. Please be patient for a bit longer. On a preliminary look, we think DuckDB support is possible, but first Valentina 14 has to get out the door. Watch for the Valentina 14 release.

Best regards,

Lynn Fredricks
Paradigma Software
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Hi Lynn.

Yes, I understand the situation. I’m not rushing you in any way, I was interested to know your principled position on DukeDB, the timing is not that important.

Thanks for the answer.
Комментарий
There are no comments made yet.
Sergio Ciordia Ответ принят
That's great news Lynn. I'm waiting for DuckDB support too, but when you can.

Thanks for listening to the users.

Wardiam
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello,

We have started a new development branch for DuckDB to support it in Valentina Studio.
Комментарий
There are no comments made yet.
Sergio Ciordia Ответ принят
Thank you very much Sergey and Lynn for letting us know. What good news. I'm sure other users will welcome this news with joy. DuckDB is very promising and together with Valentina Studio are my 2 winning horses.

Thanks again guys. Lots of encouragement with the development. ;)

Sergio
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Hello,

The first beta version with DuckDB support is available for download:
Ссылки
  1. https://valentina-db.com/download/beta/14.5b12/
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Great, faster than I expected!
DuckDB plugin version 1.0 - so far so good.
I expected you to wait for DuckDB version 1.1 (scheduled for release on 09.09.2024).

Will the stable version 14.5 be compiled with DuckDB version 1.1?
Compared to the previous version, many significant changes have been made that affect performance (especially in indexes and memory management), the ability to work with SQL variables has been added, and many bugs have been fixed.

For newly created or attached databases, the ability to specify the block size (from 16 KB to 256 KB) as a power of two (similar to the page size in VDB) has been added.
It makes sense to add this parameter to the database creation form.

And also, similar to other plugins, it makes sense to put a number of general-purpose configuration parameters in the plugin settings form (for example, number of threads, maximum allocated memory size, default collation, home directory, directory of downloaded extensions, etc.).

Also, please add the DuckDB tag to MANTIS.
Thanks again, guys.
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Or, perhaps more simply, in the connection form to the DB specify the path to the SQL-script file, which is executed at the time of opening the DB.
And then set the configuration parameters and environment parameters in the file.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
We'll be using DuckDB 1.0 in version 14.5. We plan to make frequent updates, so a new version will be integrated soon.
Is there a list of changes, or did you just review the Git repository?
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Hi Sergey!
I use the developer version, so I track the latest commits.
Wow, you support the 32-bit version too? Great!

Maybe it makes sense to mark this event with an article on HABR?
It would be useful for promoting VStudio - not many tools support DuckDB...
As far as I remember, Ruslan had an account there...
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Sergey, pay attention to the parent and child table selection lists in the form for creating links and to the relationship selection list on the child table panel in the Data Editor.

The lists does not contain table names, but some crap -> (:ling/icons/table.svg)
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Regarding the previous comment - as soon as I registered a ticket in MANTIS - within half an hour Ihor Nikitin already fixed it.
Great job, mans!
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
DuckDB added to Mantis
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Don't know if HUBR is okay for product vendor articles?
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Why not? The site is quite popular...
For example, Postgres Pro developers actively use this platform, articles are published regularly. In addition, PostgreSQL is breathing unevenly on DuckDB, integrating the engine as an OLAP solution, which is also discussed here. There are also a number of articles about DuckDB directly. About VSTUDIO as well.
If you are too lazy to give birth to an article about VStudio as a GUI for DuckDB, you can, at least, throw comments in related articles - it's still better than nothing.
However, you know better. I just made a suggestion for more aggressive advertising. It seems to me that VS, as a tool, is underestimated and little known.
Комментарий
There are no comments made yet.
Ruslan Zasukhin Ответ принят
Вот список того, чего на ресурсе делать не следует:

Рекламировать ресурсы в обход правил
Для привлечения внимания к проектам, компаниям, коммерческим продуктам, услугам, сервисам и мероприятиям предназначены корпоративные блоги и хаб «Я пиарюсь». Попытки поместить их упоминания вне указанных разделов повлекут за собой понижение прав аккаунта.
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Упс! Не знал, в Пользовательском соглашении ХАБРа я такого не видел.
Т.е., получается, тов. cleg, накатав в 2013 гду статью "Valentina Studio — бесплатная программа для работы с СУБД" в разделе Администрирование баз данных*, пожертвовал своей кармой или рейтингом?
Ведь там открытый пиар, как и в статье "Всё что нужно знать про DuckDB", да и в массе других тоже...
Ну что ж... Руслан! Не кусайся - я хороший! И исходил только из благих побуждений.
Но, как говорил один почивший в бозе товарищ:
- Хотели как лучше, а получилось - как всегда.
Комментарий
There are no comments made yet.
Vladimir Esipov Ответ принят
Don't know if HUBR is okay for product vendor articles?

There is a section "SQL Editors" in the DuckDB documentation.
At the moment, only DBeaver is presented there.
With the release of the stable branch 14.5 and the refinement of plugin_duckdb to cover the main features of DuckDB, there is a good chance to be on this list.
Probably, this is the most acceptable and not impudent way to promote VStudio.:)
Комментарий
There are no comments made yet.
  • Страница :
  • 1
  • 2


There are no replies made for this post yet.
However, you are not allowed to reply to this post.

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories