3 ms·
I'm working in a relational language (https://tablam.org https://tablam.org) that hopefully will be a great way to massage data and have in-built support for "l
by mamcx 6y ago
I'm working in a relational language (https://tablam.org https://tablam.org) that hopefully will be a great way to massage data and have in-built support for "linq/sql"-like queries across all the data sources (from site):
-- A column, aka: Vectors...
let qty := [10.5, 4.0, 3.0]
-- Like APL/kdb+ operations apply to more than scalars
prices * 16.0
-- The ? (query) operator allow to do SQL-like queries to anything
let doubled := qty ?select #0 * 2.0
let products := open("products.csv")
-- like files!
for p in products ?where #price > 0.0 do
print(p)
end
--so, we can do joins between anything:
for p in cross(products, qty) ?limit 10 do
print(p.products.price * p.qty)
end
I already have a crude working prototype, but need help (hands or funding) to move forward!
---
My long-term goal is to provide an alternative to Access/Excel/FoxPro with a full suite of decoupled components (language + rdbms components + interactive data repl + form builder) to capture the spirit of what this kind of tools allow but with a more solid foundation.