
PACHA . DEV {
}
Title:
pacha.dev/blog - Comparing SQLite, DuckDB and Arrow with UN Trade Data
Description:
A quick exploration of different technologies to work with medium/large datasets.
Website Age:
5 years and 2 months (reg. 2020-05-08).
Matching Content Categories {📚}
- Technology & Computing
- Events
- Education
Content Management System {📝}
What CMS is pacha.dev built with?
Website use quarto-1.3.340.
Traffic Estimate {📈}
What is the average monthly size of pacha.dev audience?
🚦 Initial Traffic: less than 1k visitors per month
Based on our best estimate, this website will receive around 560 visitors per month in the current month.
check SE Ranking
check Ahrefs
check Similarweb
check Ubersuggest
check Semrush
How Does Pacha.dev Make Money? {💸}
We're unsure how the site profits.
Some websites aren't about earning revenue; they're built to connect communities or raise awareness. There are numerous motivations behind creating websites. This might be one of them. Pacha.dev has a secret sauce for making money, but we can't detect it yet.
Keywords {🔍}
homepachacomtraderds, files, reporteriso, sqlite, duckdb, rds, unspecified, null, sql, year, yrpc, file, arrow, narm, data, create, table, creating, countries, indexes, con, varchar, collect, order, database, sizes, columns, structure, rows, filtering, index, false, groupbyyear, summarise, mediantime, memalloc, package, decimal, default, dbsendquerycon, readrdsx, dbdisconnectcon, memory, mark, filterreporteriso, totalexportsinusd, sumtradevalueusdexp, totalimportsinusd, sumtradevalueusdimp, read,
Topics {✒️}
dev/blog comparing sqlite rds /home/pacha/comtrade/2011 rds /home/pacha/comtrade/2012 rds /home/pacha/comtrade/2013 rds /home/pacha/comtrade/2014 rds /home/pacha/comtrade/2015 rds /home/pacha/comtrade/2016 rds /home/pacha/comtrade/2017 rds /home/pacha/comtrade/2018 rds /home/pacha/comtrade/2019 rds /home/pacha/comtrade/2020 partner_iso varchar commodity_code varchar apples/oranges/bananas/ medium/large datasets create index year create index reporter_iso single large file ll add rows memory } creating newer duckdb provide duckdb files consists create table yrpc trade_value_usd_exp decimal trade_value_usd_imp decimal total_size_in_mb = sum rds files obtained ~/comtrade/2011_2020 duckdb database ram memory extension = gsub median_time = median sqlite database size_in_mb = sizes size_in_mb = sizes2 year integer reporter_iso varchar add indexes trade data sql arrow unlike sql large tables creating quick exploration relative efficiency boss asked aggregate exports sri lanka arrow speeds team pointed
Questions {❓}
- Why these differences?
External Links {🔗}(3)
Libraries {📚}
- Bootstrap
- Clipboard.js
- Popper.js
Emails and Hosting {✉️}
Mail Servers:
Name Servers:
- ns-37-b.gandi.net
- ns-54-a.gandi.net
- ns-73-c.gandi.net