# Core Infra

Meta organization that builds and operates online transaction processing infrastructure for access to and storage of online data.

This is one page of public article previews, not the complete archive. Follow Next page to continue. Summaries are not the original full articles.

## Longbridge Technology simplifies their architecture and achieves 10x performance boost with ClickHouse

DevFeed: [Longbridge Technology simplifies their architecture and achieves 10x performance boost with ClickHouse](<https://devfeed.tech/articles/longbridge-technology-simplifies-their-architecture-and-achieves-10x-performance-boost-with-clickhouse-5398.md>)

Original publisher: [Read original article](<https://clickhouse.com/blog/longbridge-technology-simplifies-their-architecture-and-achieves-10x-performance-boost-with-clickhouse>)

Author: Wenquan Liu, Longbridge Technology

Published: 2025-03-17T00:00:00Z

Content type: article

Language: en

Sources: [ClickHouse Blog](<https://devfeed.tech/sources/clickhouse-blog.md>)

Topics: [Core Infra](<https://devfeed.tech/topics/core-infra.md>)

Tags: [architecture](<https://devfeed.tech/tags/architecture.md>), [batch](<https://devfeed.tech/tags/batch.md>), [clickhouse](<https://devfeed.tech/tags/clickhouse.md>), [data](<https://devfeed.tech/tags/data.md>), [database](<https://devfeed.tech/tags/database.md>), [fintech](<https://devfeed.tech/tags/fintech.md>), [performance](<https://devfeed.tech/tags/performance.md>), [postgresql](<https://devfeed.tech/tags/postgresql.md>), [real-time](<https://devfeed.tech/tags/real-time.md>), [time-series](<https://devfeed.tech/tags/time-series.md>)

### AI overview

Longbridge Technology adopted ClickHouse on AliCloud to restructure market analysis, reporting a tenfold query-performance improvement. The article describes the need to ingest real-time market data at very high rates, run millisecond batch queries on historical data, and support Decimal and time-based functions.

### Source excerpt

Longbridge Technology adopts ClickHouse on AliCloud to restructure its market analysis business, achieving a tenfold improvement in query performance.

## Roshi: a CRDT system for timestamped events

DevFeed: [Roshi: a CRDT system for timestamped events](<https://devfeed.tech/articles/roshi-a-crdt-system-for-timestamped-events-2130.md>)

Original publisher: [Read original article](<https://developers.soundcloud.com/blog//roshi-a-crdt-system-for-timestamped-events>)

Published: 2014-05-09T00:00:00Z

Content type: article

Language: en

Sources: [SoundCloud Backstage Blog](<https://devfeed.tech/sources/soundcloud-backstage-blog.md>)

Topics: [Core Infra](<https://devfeed.tech/topics/core-infra.md>), [Apache Cassandra](<https://devfeed.tech/topics/cassandra.md>), [Streams](<https://devfeed.tech/topics/streams.md>), [Sorting](<https://devfeed.tech/topics/sorting.md>), [data](<https://devfeed.tech/topics/data.md>)

Tags: [announcements](<https://devfeed.tech/tags/announcements.md>), [cassandra](<https://devfeed.tech/tags/cassandra.md>), [data](<https://devfeed.tech/tags/data.md>), [event](<https://devfeed.tech/tags/event.md>), [go](<https://devfeed.tech/tags/go.md>), [infrastructure](<https://devfeed.tech/tags/infrastructure.md>), [open-source](<https://devfeed.tech/tags/open-source.md>), [scale](<https://devfeed.tech/tags/scale.md>), [sorting](<https://devfeed.tech/tags/sorting.md>), [streams](<https://devfeed.tech/tags/streams.md>)

### AI overview

SoundCloud describes Roshi, a CRDT system for timestamped events, in the context of building a large-scale social stream. The article contrasts the existing Cassandra-based fan-out-on-write model with fan-in-on-read, which stores events in users' outboxes and merges them when streams are requested. The alternative reduces writes and storage costs while making reads more challenging because many event streams must be time-sorted and merged.

### Source excerpt

Let's talk about the stream. The SoundCloud stream represents stuff that's relevant to you primarily via your social graph, arranged in time...