SQLite UPSERT makes conflict handling part of INSERT
engineeringsqlitesqlupsertSQLite 3.24.0 adds PostgreSQL-style UPSERT. Conflict targets, excluded values and conditional updates let a statement express how an existing row should change.
Notes on building observable systems and operating them at scale.
SQLite 3.24.0 adds PostgreSQL-style UPSERT. Conflict targets, excluded values and conditional updates let a statement express how an existing row should change.
Istio 0.8 makes the new routing model available alongside streaming proxy configuration. The ADS implementation shows how declared mesh changes become updates to connected proxies.
Cachix launches hosted binary caches with an argument for sharing build results outside the central Nixpkgs package set.
Ruby 2.6 preview 2 exposes a method JIT that generates C and invokes GCC or Clang at runtime. The preview tests the compilation infrastructure before promising final application performance.
Numeric and symbolic properties now participate in keyof and mapped types. Import types separately let declarations refer to module types without changing a global script into a module.
Redis 5 RC1 introduces Streams with ordered entry IDs and non-destructive range reads. Its storage layout compresses repeated fields, while parts of the consumer-group implementation remain unfinished.
Kustomize introduces a way to reuse Kubernetes manifests without parameterizing every difference. Bases and overlays preserve resource declarations while recording environment-specific changes separately.
The Service Usage API becomes a prerequisite for managing project services. The provider's singular and plural resources express different ownership contracts.
The revised Go code of conduct addresses harmful behavior outside project forums and assigns enforcement to a trained Project Steward with institutional support.
Qualified index names expose a namespace difference between CockroachDB and PostgreSQL. Version 2.0.2 expands resolution for administrative statements used by existing tools.
The London NixCon announcement arrives after Nix 2.0, when common store operations and evaluation reproducibility offer concrete subjects for contributor discussion.
The planned retirement of search.cpan.org separates the maintenance of a documentation service from the continued use of CPAN packages.
The agreement to branch Cassandra 4.0 in early September follows an argument about who can validate it. A feature cutoff only helps when people can test the resulting database.
Strimzi 0.4 exposes Kubernetes resource settings and JVM memory options through its cluster configuration. The release also changes configuration keys and renames its controllers to operators.
impl Trait lets an API hide a concrete return type without requiring a boxed trait object. Rust 1.26 also simplifies matching borrowed values while preserving borrowing rules.
The May update fixes an adminpack privilege error and incorrect function labels. Existing databases need catalog changes that replacing server binaries does not perform.
Docker 18.05 avoids an unintended service rollout when stack deployment resets a force-update counter. It also repairs Compose network merging and reduces the growth of bridge isolation rules.
Datasette 0.21 adds response shapes, page-size controls and column-specific search. A smaller JSON response also changes how a client discovers pagination.
Community-hosted Swift CI begins with Fedora and ARMv7 Debian testing. Its post-merge execution model expands regression visibility while leaving host maintenance with volunteers.
GCC 8.1 adds library facilities and experimental C++2a support alongside calling-convention corrections. Language mode, library coverage and ABI compatibility remain separate properties of a build.
GCC 8.1 makes GNU C17 the default C dialect. The important distinction is between selecting the corrected standard, enabling GNU extensions and receiving the compiler's new diagnostics.
Python 2.7.15 releases the interpreter lock around more file operations. Its maintenance fixes also address garbage collection during concurrent subprocess creation and compiler assumptions about memory alignment.
FreeWheel describes replacing isolated application caches with shared Redis storage. The architectural gain is a common cache entry, while freshness still depends on the application policy.
Swift's new snapshot implementation represents implicitly unwrapped values as ordinary optionals. The resulting changes to inference and member lookup explain several source compatibility surprises.
Go's new visual identity gives the project a shared wordmark and presentation materials while retaining Renee French's mascot.
WG14's Brno agenda includes proposed attributes and a paper showing inconsistent deprecation diagnostics. The difficult question is how an API can deprecate its types without warning about its own declarations.
The redesigned routing API separates the host a client addresses from the workloads receiving its request. Ordered VirtualService routes and named DestinationRule subsets make that relationship explicit.
TypeScript 2.8.3 includes corrections to import organization and interoperability helper discovery. Both depend on preserving the meaning of an import while compiler tooling processes the surrounding file.
Strimzi 0.3 strengthens its Cluster Controller and changes advertised listeners to DNS names. Its ConfigMap-driven model needs both recovery from missed notifications and stable ways to identify individual brokers.
pip 10 implements PEP 518 and prepares a separate environment for declared build requirements. The change addresses the circular problem of executing setup.py to discover what it needs.