Changeset: d685c30ea341 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB/rev/d685c30ea341 Removed Files: sql/ChangeLog.odbc_loader Modified Files: sql/ChangeLog.Mar2025 Branch: Mar2025 Log Message:
Added info on new proto_loader(string uri) function. Moved contents of ChangeLog.odbc_loader into ChangeLog.Mar2025 diffs (72 lines): diff --git a/sql/ChangeLog.Mar2025 b/sql/ChangeLog.Mar2025 --- a/sql/ChangeLog.Mar2025 +++ b/sql/ChangeLog.Mar2025 @@ -1,10 +1,52 @@ # ChangeLog file for sql # This file is updated with Maddlog +* Wed Mar 5 2025 Martin van Dinther <[email protected]> +- Added support for reading external data in a generic way via table + returning function: proto_loader(string uri). The uri string value + must start with the scheme name, ending with : character. + Supported schemes are: monetdb: and odbc:. + The monetdb scheme allows you to connect to a remote MonetDB server + and retrieve the data of a specific table or view in a specific schema. + The uri syntax: monetdb://[<host>[:<port>]]/<database>/<schema>/<table> + Example: SELECT * FROM proto_loader('monetdb://127.0.0.1:50000/demo_db/sys/tables'); + The odbc scheme allows you to connect to any ODBC data source via + an ODBC driver and retrieve the data of a supplied query. + The uri syntax: + odbc:{{DSN|FILEDSN}=<data source name>|DRIVER=<path_to_driver>}; + [<ODBC connection parameters>;]QUERY=<SQL query> + For ODBC you normally configure a data source first. This + is done using the ODBC administrator (on windows: odbcad32.exe, + on linux: odbcinst). Once a data source for a specific ODBC + driver has been setup using a unique name, you can reference it as: + DSN=my_bigdata; or FILE_DSN=/home/usernm/dsns/my_bigdata; + If you do not want to setup a data source, you can use DRIVER=...; + to specify the ODBC driver program to use. However this also means + you have to specify all the required connection parameters yourself, + such as UID=...;PWD=...;DATABASE=...; etc. + The QUERY=<SQL query> part is mandatory and must be specified at the + end of the uri string, after the optional ODBC connection parameters. + Examples: SELECT * FROM proto_loader( + 'odbc:DSN=Postgres;UID=claude;PWD=monet;QUERY=SELECT * FROM customers'); + SELECT * FROM proto_loader('odbc:DRIVER=/usr/lib64/libsqlite3odbc.so; + Database=/home/martin/sqlite3/chinook.db;QUERY=SELECT * FROM customers'); + Note that the 'odbc:' scheme is experimental and not enabled by default. + To enable it the MonetDB server has to be started with argument: + --loadmodule odbc_loader + * Mon Feb 10 2025 stefanos mavros <[email protected]> - Extended the constant aggregate optimizer in order to eliminate aggregates with constant arguments whenever possible. +* Wed Jan 29 2025 Joeri van Ruth <[email protected]> +- REMOTE TABLES and REPLICA TABLES now fully support the monetdb:// + and monetdbs:// URL's introduced in Aug2024. + Any mapi:monetdb:// URL's are normalized to the new style. +- Add function sa_msettings_create() to allocate an msettings object + using the arena allocator. +- Unused helper function mapiuri_database() has been removed from + rel_remote.h. + * Fri Dec 20 2024 Niels Nes <[email protected]> - Added support for aggregates which order within the group such as quantile and which potentially order within the group such as diff --git a/sql/ChangeLog.odbc_loader b/sql/ChangeLog.odbc_loader deleted file mode 100644 --- a/sql/ChangeLog.odbc_loader +++ /dev/null @@ -1,11 +0,0 @@ -# ChangeLog file for sql -# This file is updated with Maddlog - -* Wed Jan 29 2025 Joeri van Ruth <[email protected]> -- REMOTE TABLES and REPLICA TABLES now fully support the monetdb:// - and monetdbs:// URL's introduced in Aug2024. - Any mapi:monetdb:// URL's are normalized to the new style. -- Add function sa_msettings_create() to allocate an msettings object - using the arena allocator. -- Unused helper function mapiuri_database() has been removed from - rel_remote.h. _______________________________________________ checkin-list mailing list -- [email protected] To unsubscribe send an email to [email protected]
