Our Commitment
THREDr LLC is dedicated to revolutionizing data management and analysis with THREDrDB, an advanced software solution. Our platform simplifies the creation and management of SQLite memory databases, facilitates seamless data import from various sources (including API calls), and enables the execution of complex queries with ease.
We empower users to load API data directly into the table, define custom query definitions, export data effortlessly, and leverage advanced SQLite functions for streamlined database interactions.
All of THREDrDB's functions are asynchronous array functions so they don't block the UI even while loading or retrieving very large arrays of data.
Key Functionalities
Streamlined Data Handling
THREDrDB streamlines data handling by enabling the swift import of data from different sources into a SQLite database, allowing for efficient querying and manipulation without extensive setup.
Effortlessly export tables and queries in various formats for convenient sharing, reporting, and further analysis, empowering seamless data dissemination.
Custom Query Creation
Define personalized query definitions within the SQLite database to extract specific datasets, gain valuable insights, and create chains that are complex yet easy to visualize, debug, and edit; enhancing the flexibility and precision of data analysis.
No-Code API Integration and Processing, along with advanced Circular Logic capabilities.
You provide the URL and THREDrDB does the rest!
Experience the excitement of custom functions that seamlessly run API's and pull in data for your worksheets and SQLite tables at your preferred intervals while you work!
With volatile formulas, you can unleash circular logic between your worksheets and SQLite, making iterative calculations a breeze. Watch as downstream formulas refresh automatically whenever there's a change in API or volatile results. Transform your Excel worksheets into dynamic program loops that keep your live results updating continuously and converge calculations without the need for manual updates!
Optimized Performance
THREDrDB's functions are all asynchronous and designed to optimize performance, ensuring that complex calculations do not impact user experience. The integration with Excel's multi-threaded calculation engine allows for efficient data processing without disrupting workflow.
How to Add THREDrDB to Excel
1
Open the Excel Add-in Store and go to Manage Add-Ins
2
Lookup "THREDrDB" and Press Enter
Then Click "Add" on the right-hand side of the window
3
Start using THREDrDB functions immediately, or click "Activate THREDr" for additional features!
Refresh Table
Use the THREDrDB.REFRESHTABLE function to load data from your Excel workbook into the SQLite memory database.
API Call
Use the THREDrDB.APICALL function to call API's, convert the JSON response to table data, and load the data into the SQLite memory database
THREDrDB Functions
Query
Use THREDrDB.QUERY to run SQLite queries, join data, and define views in the database.
Clock
Use the THREDrDB.CLOCK function to trigger recalculation of all dependent formulas on a specified interval. This means THREDrDB can automatically refresh your API's and downstream calculations without the need to trigger the refresh manually or externally.
​
