211
User-defined Order in SQL
Some applications, such as todo lists, need to maintain a user-defined order of items. The challenge is that the order is arbitrary and can change when the user rearranges items:
New
The latest blog posts to take off on Hacker News. 265 posts.
212
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.
213
A picture got my PostgreSQL database to start mining Monero
A Deep Dive into Database Attacks [Part III]: Why Scarlett Johansson’s Picture Got My Postgres Database to Start Mining Monero
214
215
Atomic Commit in SQLite (2007)
An important feature of transactional databases like SQLite is "atomic commit". Atomic commit means that either all database changes within a single transaction occur or none of them occur. With atomic commit, it is as if many different writes to different sections of the database file occur instantaneously and…
216
The 600+ Companies PayPal Shares Your Data With
One of the effects of GDPR—the new EU General Data Protection Regulation—is that we’re all going to be learning a lot more about who collects our data and what they do with it. Consider PayPal, that just released a list of over 600 companies they share customer data with. Here’s a good visualization of that data. Is…
217
218
Memory efficiency of parallel IO operations in Python
Python allows for several different approaches to parallel processing. The main issue with parallelism is knowing its limitations. We either want to parallelise IO operations or …
219
220
Anna: A Fast, Scalable, Flexibly Consistent Key-Value Store
There’s fast and there’s fast. This post is about Anna*, a key/value database design from our team at Berkeley that’s got phenomenal speed and buttery smooth scaling, with an unpr…
221
HTTP Analytics for 6M requests per second using ClickHouse
One of our large scale data infrastructure challenges here at Cloudflare is around providing HTTP traffic analytics to our customers. HTTP Analytics is available to all our customers via two options:
222
Why DNSFilter replaced InfluxDB with TimescaleDB
Stay informed with the latest updates, trends, and insights on DNS and content filtering. Get useful tips and best practices in network security.
223
Jepsen: Aerospike 3.99.0.3
Aerospike , formerly Citrusleaf, is a distributed, sharded document store designed for high-throughput, low-latency applications. Each record is a map of keys to values, which may be either primitive types (integers, strings, bytes, etc.) or nested collections like lists and maps. Secondary indices are also available…
224
Create Statistics in PostgreSQL 10
Postgres stores a lot of statistics about your data in order to effectively retrieve results when you query your database. Here we deep dive into some of the statistics PostgreSQL stores and how you can leverage a new feature in Postgres 10 to improve performance when different columns are related.
225
Notes on Analytics and Tracking in Onavo Protect for iOS
Recent media coverage of Onavo Protect encouraged me to investigate the code for the iOS version of their app. I wanted to determine what…
226
The metrics behind Spotify’s IPO
Spotify's direct listing IPO filing reveals how monthly churn fell from 7.7% to 5.5% as personalization and family plans drove subscriber retention at scale.
227
228
A new storage engine for PostgreSQL to provide better control over bloat
In the past few years, PostgreSQL has advanced a lot in terms of features, performance, and scalability for many-core systems. However, o...
229
230
231
Google-Landmarks: A New Dataset and Challenge for Landmark Recognition
Posted by André Araujo and Tobias Weyand, Software Engineers, Google ResearchImage classification technology has shown remarkable improvement over ...
232
233
NumPy Exercises for Data Analysis in Python
The goal of the numpy exercises is to serve as a reference as well as to get you to apply numpy beyond the basics. The questions are of 4 levels of difficulties with L1 being the easiest to L4 being the hardest.
234
Announcing Google Cloud Spanner as a Vault Storage Back End
By using Cloud Spanner as a storage backend for HashiCorp Vault, you get all the benefits of a traditional relational database, the scalability of a globally-distributed data store, and the availability of a fully managed service.
235
236
CockroachDB Interactive, D3-Powered Simulations
An interactive demo (using D3) of CockroachDB. Watch as CockroachDB evolves with your application, from proof-of-concept, to multi-node cluster, to international deployment.
237
238
239
Serverless Databases: The Future of Event-Driven Architecture
Serverless Database is specially designed for the workloads which are unpredictable & can change rapidly. Click to know everything about Serverless Database.
240
Performance Benchmark 2018 – MongoDB, PostgreSQL, OrientDB, Neo4j and ArangoDB
The only enterprise AI data platform that cuts complexity, reduces costs, and gets you to production faster.