openmolecules.org

 
Home » DataWarrior » Functionality » Database connection (Loading fresh data from database on file open)
Database connection [message #1386] Mon, 30 August 2021 05:13 Go to next message
nats is currently offline  nats
Messages: 3
Registered: August 2021
Junior Member
Is it possible to save a file and have the database queried automatically from a saved database connection and query (like reporting/BI software) or is a saved file just data that was retried from the database at the time of creating the file?
Re: Database connection [message #1389 is a reply to message #1386] Wed, 01 September 2021 13:17 Go to previous messageGo to next message
thomas is currently offline  thomas
Messages: 463
Registered: June 2014
Senior Member
I am not sure, whether I understand the question. If you query a database, e.g. Chembl, then the result is a subset in an open DataWarrior window. If you save the window, the subset is stored in a file. If the original Chembl database is updated, it does not change the saved file.

You may, of course, create a macro that queries the Chembl database, creates views, merges other data, or does some other fancy stuff with the query result. If you run the macro at a later time after Chembl update, then it does the same thing with the the query result of a different, up-to-date query result.

This applies to all databases that DataWarrior is able to query including your in-house databases if you use plain SQL or have build a plugin for.

Does this answer the question?
Re: Database connection [message #1394 is a reply to message #1389] Thu, 09 September 2021 03:23 Go to previous message
nats is currently offline  nats
Messages: 3
Registered: August 2021
Junior Member
Yes thanks
Previous Topic: Freeze panes
Next Topic: Box Plot - Statistics
Goto Forum:
  


Current Time: Sun Oct 24 09:19:35 CEST 2021

Total time taken to generate the page: 0.01565 seconds