| Repo | Release | Link | Client | Features | Developer |
|---|---|---|---|---|---|
| repo | 17/12-24 | link | NKVTS | facetWPintegrationmicrosoftMSSQLsearchWP | Marius J |
Functionality
An integration that pulls data from NKVTS’s internal MSSQL research database, and publishes it as various WordPress post types.
The content is indexed and available through SearchWP and FacetWP for easy browsing and discovery by those looking to learn more about the research done.
The MSSQL queries uses a custom database abstraction layer, modeled after WPDB, to provide developers with an easily recognizable platform for future development needs.
Dependencies
The server needs to support the SQLSRV protocol for communicating with Microsoft SQL databases.
Links
Notes
MSSQL is very strictly typecast, the abstraction library handles this by performing type-conversions on the data submitted to it basedo n database schemas in the most intelligent manner possible depending on user configuration.
This means the devloper can disable caching of database schemas, which may impact performance, but improve security for sites that have library files in the public domain, or they can keep the schema in memory for as long as the script is executed, this may have a larger memory footprint, but improves performance per run over having to do schema lookups for every SQL command executed.
