Timescale raises $16M from Benchmark, NEA, Two Sigma Ventures
Humanity is now living with machines and swimming in machine data. Timescale just raised $16M to help developers, businesses, and society make sense of it all.
Are triggers really that slow in Postgres?
PostgreSQL trigger performance. Should we use tiggers at all? Find out how triggers perform in performance tests.
Architecture of Nautilus, the new Dropbox search engine
Dash knows your context, your team, and your work, so your team can stay organized, easily find and share knowledge, and keep projects secure, all from one place.
Reduce GPS data error on Android with Kalman filter and accelerometer
IT blog about developing and managing enterprise-level software solutions for blockchain, fintech, transportation & logistics, security, edtech, and advertising industries.
A little bit of the one-time MacOS version still lingers in ZFS
You're probably reading this page because you've attempted to access some part of my blog (Wandering Thoughts) or CSpace , the wiki thing it's part of. Unfortunately you're using a browser version that my anti-crawler precautions consider suspicious, most often because it's too old (most often this applies to versions…
Zero-shot learning: Using text to more accurately identify images
WHAT THE RESEARCH IS: Zero-shot learning (ZSL) is a process by which a machine learns to recognize objects it has never seen before. Researchers at Facebook have developed a new, more accurate ZSL …
EdgeDB: A New Beginning
In a few weeks we will release the first public technology preview of EdgeDB—a new open-source object-relational database. This post is a brief introduction and is the first in the series.
Datasette Facets: Faceted Browse and a JSON API for any CSV File or SQLite DB
Datasette 0.22 is out with the most significant new feature I’ve added since the initial release: faceted browse. Datasette lets you deploy an instant web UI and JSON API for …
Gravwell Community Edition: A Splunk Alternative Built with Go
Initial Gravwell testers did a lot of home monitoring with the software and wanted to get licenses for their friends and colleagues but Gravwell was built for larger enterprises and our pricing model isn't set up for home use. All of that changes with the Community Edition...
Who Wrote the Anti-Trump New York Times Op-Ed? Using Tidytext
Like a lot of people, I was intrigued by “I Am Part of the Resistance Inside the Trump Administration”, an anonymous New York Times op-ed written by a “senior official in the Trump administration”. And like many data scientists, I was curious about what role text mining could play.
The design and implementation of modern column-oriented database systems
The design and implementation of modern column-oriented database systems Abadi et al., Foundations and trends in databases, 2012 I came here by following the references in the Smoke paper we looked…
How Numba and Cython speed up Python code
A high-level overview of Numba and Cython architectures
Postgres data types you should consider using
PostgreSQL has a rich collection of extensions and nearly 100 different data types, each with their own tuned indexing or specialized functions. You probably already use integers and text, and today we're going to explore a few less-used but incredibly powerful PostgreSQL data types.
A one-size-fits-all database doesn't fit anyone
The days of the one-size-fits-all monolithic database are behind us, and developers are using a multitude of purpose-built databases.
Parallel Index Scans in PostgreSQL
There is a lot to say about parallelism in PostgreSQL. We have come a long way since I wrote my first post on this topic ( Parallel Sequen...
Using parallel sequential scan in PostgreSQL
Parallel sequential scan is the first parallel access method in PostgreSQL and is introduced in version 9.6. The committer of this featu...
Fun with SQL: Window Functions in Postgres
Window functions in PostgreSQL are valuable when you want to compare & contrast data between rows. And window functions are key in analytics use cases. This post covers the basic structure of window functions as well as some of the more interesting things you can do with them.
Conservation of Intent: why A/B tests aren’t as effective as they look
When a +10% isn’t really a +10% OK, this is an infuriating startup experience: You ship an experiment that’s +10% in your conversion funnel. Then your revenue/installs/whatever goes up by +10% right?