@fiz_karlsruhe @RADAR Thanks for sharing this here! As we are currently working on connecting @RADAR to #LinkAhead that's very interesting for us.
@fiz_karlsruhe @RADAR Thanks for sharing this here! As we are currently working on connecting @RADAR to #LinkAhead that's very interesting for us.
@erikp @rotnroll666 another downside is cancelling any cache mechanisms. I would say the best solution is often to not use stored procedures or triggers. The key mechanism for #RDMS is good query planners and efficient indexes, of course on top of #ACID
“Every year, poor data quality costs organizations an average$12.9M.” (source: https://buff.ly/3BuBEoX ) #sql #postgres #rdms #snowflake
We are organizing a workshop on semantic data management in April in #Göttingen!
Contributions can be submitted until 2024-03-06.
More information: http://www.bmp.ds.mpg.de/asdm2024/
Our new article titled "Mapping Hierarchical File Structures to Semantic Data Models for Efficient Data Integration into Research Data Management Systems" was published a few days ago!
https://doi.org/10.3390/data9020024
It discusses our method of data integration into @caosdb / #linkahead using a customizable file crawler.
#datamanagement #RDMS #researchdata #FileIntegration #FAIR #SemanticDataManagement
Postgres Language Server
A Language Server for Postgres. Not SQL with flavors, just Postgres
https://github.com/supabase/postgres_lsp
https://news.ycombinator.com/item?id=37020610
* active development; only ready for collaborators
* making this public so we can develop it in the open w. input f. community 👍️
Language Server Protocol
https://microsoft.github.io/language-server-protocol
* adds features like auto complete, go to definition, documentation on hover for a programming language
#PostgreSWL #SQL #LanguageServer #RDMS #postgres #LSP #Microsoft