tds_fdw | PostgreSQL foreign data wrapper to connect to TDS databases | SQL Database library

by tds-fdw C Version: v2.0.3 License: Non-SPDX

X-Ray Key Features Code Snippets Community Discussions(2)Vulnerabilities Install Support

kandi X-RAY | tds_fdw Summary

tds_fdw is a C library typically used in Database, SQL Database, PostgresSQL applications. tds_fdw has no vulnerabilities and it has low support. However tds_fdw has 1 bugs and it has a Non-SPDX License. You can download it from GitHub.

This is a PostgreSQL foreign data wrapper that can connect to databases that use the Tabular Data Stream (TDS) protocol, such as Sybase databases and Microsoft SQL server. This foreign data wrapper requires a library that implements the DB-Library interface, such as FreeTDS. This has been tested with FreeTDS, but not the proprietary implementations of DB-Library. This should support PostgreSQL 9.2+. The current version does not yet support JOIN push-down, or write operations. It does support WHERE and column pushdowns when match_column_names is enabled.

Support

Quality

Security

License

Reuse

Support

tds_fdw has a low active ecosystem.

It has 309 star(s) with 93 fork(s). There are 33 watchers for this library.

It had no major release in the last 12 months.

There are 126 open issues and 114 have been closed. On average issues are closed in 200 days. There are 4 open pull requests and 0 closed requests.

It has a neutral sentiment in the developer community.

The latest version of tds_fdw is v2.0.3

Quality

tds_fdw has 1 bugs (1 blocker, 0 critical, 0 major, 0 minor) and 6 code smells.

Security

tds_fdw has no vulnerabilities reported, and its dependent libraries have no vulnerabilities reported.

tds_fdw code analysis shows 0 unresolved vulnerabilities.

There are 0 security hotspots that need review.

License

tds_fdw has a Non-SPDX License.

Non-SPDX licenses can be open source with a non SPDX compliant license, or non open source licenses, and you need to review them closely before use.

Reuse

tds_fdw releases are available to install and integrate.

Installation instructions are available. Examples and code snippets are not available.

It has 326 lines of code, 14 functions and 5 files.

It has high code complexity. Code complexity directly impacts maintainability of the code.

Top functions reviewed by kandi - BETA

kandi's functional review helps you automatically verify the functionalities of the libraries and avoid rework.
Currently covering the most popular Java, JavaScript and Python libraries. See a Sample of tds_fdw

Get all kandi verified functions for this library.

tds_fdw Key Features

No Key Features are available at this moment for tds_fdw.

tds_fdw Examples and Code Snippets

No Code Snippets are available at this moment for tds_fdw.

Community Discussions

Trending Discussions on tds_fdw

tds_fdw PostgreSQL Foreign Table Truncates Large Text to 2048 Characters

PostgreSql foreign table select fails due to special characters rows

QUESTION

tds_fdw PostgreSQL Foreign Table Truncates Large Text to 2048 Characters

Asked 2021-Oct-24 at 21:36

I have created several foreign tables already, and they all work fine, but now I have to deal with a table that has a column containing 20-30 KB of text in some rows. If that text is small, it is rendered in full, but if it happens to be longer than 2048 characters, the rest is cut off.

My tds_fdw setup:

...

ANSWER

Answered 2021-Oct-24 at 19:29

Thanks to @FlipperPA. In short, the solution I take is to set the "text size" parameter of /etc/freetds/freetds.conf or /var/lib/postgresql/.freetds.conf to the maximum value (4294967295):

Source https://stackoverflow.com/questions/69676773

QUESTION

PostgreSql foreign table select fails due to special characters rows

Asked 2021-Oct-06 at 08:34

I just set up a new foreign table and it works as intended if I just select the "ID" (integer) field.

When I add the "Description"(text) field and try to select the table, it fails with this error message:

...

ANSWER

Answered 2021-Oct-06 at 08:34

As Laurenz Albe suggested in the comments, I created a freetds.conf in my PostgreSQL folder with the following content:

Source https://stackoverflow.com/questions/69452847

Community Discussions, Code Snippets contain sources that include Stack Exchange Network

Vulnerabilities

No vulnerabilities reported

Install tds_fdw

You can download it from GitHub.

Support

If you find any bugs, or you would like to request enhancements, please submit your comments on the project's GitHub Issues page. Additionally, I do subscribe to several PostgreSQL mailing lists including pgsql-general and pgsql-hackers. If tds_fdw is mentioned in an email sent to one of those lists, I typically see it.

Find more information at: