computer_science_and_programming | Unsorted

Telegram-канал computer_science_and_programming - Computer Science and Programming

141165

Channel specialized for advanced topics of: * Artificial intelligence, * Machine Learning, * Deep Learning, * Computer Vision, * Data Science * Python Admin: @otchebuch Memes: @memes_programming Ads: @Source_Ads, https://telega.io/c/computer_science

Subscribe to a channel

Computer Science and Programming

🧲 Forty tabs open and none of them is the answer.

Docs, someone's gist, a five-year-old Stack Overflow thread. The search isn't the work — putting it together is, and that part is still on you.

Create your own AI agent inside Telegram in about a minute.

▫️ paste the error and get the reason explained, not another snippet to try
▫️ send a repo link or a doc page and ask what it actually does
▫️ it writes the throwaway script you need and runs it right in the chat — parser, converter, quick report
▫️ describe the task by voice on the way home, read the answer when you are back
▫️ it keeps your project, your stack and your past decisions in memory for months
▫️ any model from the world's providers, switched with one command

Setup takes a minute: open the link and name your agent.
Free to use — no card needed.

🧲 Try your own agent

Читать полностью…

Computer Science and Programming

Scaling Down Costs, Not Performance: How We Migrated from Couchbase to PostgreSQL

Trendyol's product content team details a phased, zero-downtime migration of five 'helper bucket' datasets (2.24 billion documents across two clusters) from Couchbase to PostgreSQL to cut infrastructure costs while preserving read performance. The strategy combined dual-writes via Kafka consumers, a custom CDC-based migrator tool for historical backfill, and feature-flagged cutover of read traffic. Key production challenges included a mysterious TPS spike traced to PgBouncer's server_reset_query_always setting, a connection-limit incident causing a primary node failover, and a hidden scaling issue where PgBouncer's own horizontal autoscaling multiplied backend connections beyond expectations (20 pods × 150 default_pool_size = 3000 potential connections). Final production benchmarks showed stable P50 latency and only a brief P99 spike (200ms to 400ms) under peak load, validating the migration.

Читать полностью…

Computer Science and Programming

Build with Tailscale using tsnet, APIs, and automated sharing

Tailscale is expanding from a network you configure into a platform you build with and on. The tsnet Go library lets applications embed Tailscale connectivity directly, giving each app its own tailnet identity, MagicDNS name, and automatic TLS certificates without opening ports or managing proxies. A tailscale-rs library is in pre-alpha, promising bindings for Rust, Python, Elixir, and C. On the automation side, the Tailnets API lets teams provision isolated tailnets on demand for per-customer or per-test isolation, and the same APIs power a new admin console so ACL updates, key rotation, and provisioning can be scripted rather than clicked. A new Declarative Node Sharing feature turns manual cross-tailnet sharing into GitOps-managed policy, currently available via waitlist.

Читать полностью…

Computer Science and Programming

First Look at @nestjs/observe in NestJS 12

NestJS 12 comes with some solid updates, no doubt about that. But if you haven’t looked at the new observability features yet, it is worth a close look.
Setting up APM tools in Node has always felt a bit clunky. Most agents sit outside the app, monkey-patching HTTP drivers and database packages to guess what is happening under the hood. It works, but you usually lose framework context along the way.
Full Article : https://lnkd.in/p/gP53bYmC

Читать полностью…

Computer Science and Programming

New system views in PostgreSQL 19

PostgreSQL 19 introduces four new system views for observability: pg_stat_lock provides cumulative cluster-wide lock contention statistics per lock type, including a fastpath_exceeded counter useful for partition-heavy workloads; pg_stat_recovery gives a single atomic snapshot of standby recovery state (replay LSNs, timelines, pause state, promotion status), replacing the need to combine several inconsistent functions;pg_stat_autovacuum_sc exposes the new per-table scoring system (based on XID age, multixact age, dead tuples, inserts, and analyze staleness) that now determines autovacuum table processing order, replacing the old pg_class ordering; and pg_dsm_registry_allocations lists dynamic shared memory registry entries (name, type, size) used by extensions that no longer need shared_preload_libraries and a restart. The piece walks through each view's schema and runs live demo queries showing sample output. PostgreSQL 19 is still in beta and details may change before GA.

Читать полностью…

Computer Science and Programming

Cancel In-Flight Form Submissions in Inertia.js v3.7

Inertia.js v3.7.0 adds a cancelOnUnmount attribute and a cancel method to the Form component so in-flight submissions can be aborted when a form unmounts or via a button click. usePoll now exposes a reactive polling value across Vue, React, and Svelte. Once props no longer lose their value during instant visits, and navigation no longer cancels background async visits aimed at other pages. Three fixes address a React back_forward stale-props bug, prop identity issues in replaceProp/appendToProp/prependToProp, and a Form unmount crash in React.

Читать полностью…

Computer Science and Programming

The Days Of Broadcast Digital TV Could Be Numbered

The UK government has set 2032 as a target date for switching off Freeview digital terrestrial TV broadcasting, moving television delivery entirely to internet-based streaming with an initial set-top-box requirement. This mirrors a broader European decline in over-the-air broadcast media, including the BBC's earlier shutdown of long wave and AM transmissions. Unlike past analog shutoffs, this move retires the very digital multiplex system (DVB-T/ATSC) that replaced analog TV roughly fifteen years ago, despite it still being widely used.

Читать полностью…

Computer Science and Programming

pnpm 12.0

pnpm 12 is now stable, a full Rust rewrite that preserves pnpm 11's commands, flags, settings, and lockfile format without requiring migration. It's installed via the next-12 npm tag since latest still points to pnpm 11. Breaking changes include git dependency specifiers resolving through canonical HTTPS URLs instead of SSH, unrecognized pnpm-workspace.yaml settings now being reported (and failing when a pnpm version is pinned), canonicalized lockfiles for cyclic dependency graphs (2-3x faster peer resolution, ~25% less memory on cycle-heavy workspaces), hardlink-first behavior for packageImportMethod: auto on Linux, and stricter engineStrict edge traversal. New features include project-aware global bins for node/deno/bun, pnpm provisioning other package managers (npm, Yarn, Bun) via pnx and pnpm shim, registry revisions for serving patched artifacts without version bumps, pnpm init pinning the latest pnpm version, batch approval for staged publishing, audit.ignorePrune, sudo restrict

Читать полностью…

Computer Science and Programming

Connection Pool Sizing, Measured: Why 48 Connections Beat 400

A benchmark sweep of a PostgreSQL instance from 1 to 400 connections shows throughput peaking at 48 connections (18,039 tps) and dropping 37% by 400 connections, while average latency multiplied 13x. The piece explains why connections are OS processes competing for cores rather than free capacity, tests the Universal Scalability Law fit (R²=0.94, predicted optimum 45.1), evaluates the (cores×2)+spindles formula (predicts 9, far off the measured 48), and finds that synchronous_commit=off raises throughput but does not shift the peak. It closes with practical guidance: watch queue depth (cl_waiting in PgBouncer, pending-threads in HikariCP) rather than connection count, account for instances × pool size multiplication, and use transaction pooling or RDS Proxy for Lambda to avoid connection exhaustion.

Читать полностью…

Computer Science and Programming

Postgres 19: How Our Advice Has Changed Since...

A deep retrospective revisits years of Crunchy Data's Postgres advice on COPY, TOAST, BRIN indexes, covering indexes, and partitioning, mapping which Postgres versions (14 through the upcoming 19) changed the underlying mechanics while the core recommendations largely held. Highlights for Postgres 19 (currently in beta) include SIMD-accelerated COPY parsing, ON_ERROR SET_NULL, LZ4 becoming the default TOAST compression algorithm, native REPACK CONCURRENTLY, native MERGE/SPLIT PARTITION syntax, COPY TO working directly on partitioned parents, autoscaling async I/O workers, parallel autovacuum workers, and JIT being turned off by default after being on since version 12. The piece closes with a checklist of advice that remains unchanged across all these releases.

Читать полностью…

Computer Science and Programming

VoidZero Releases Vite+ Beta: A Unified Web Toolchain Behind a Single Command

VoidZero, the company behind Vite founder Evan You, has launched the beta of Vite+, a unified web toolchain accessible through a single vp command. It bundles Vite, Vitest, Rolldown, tsdown, Oxlint and Oxfmt with a built-in task runner, offering commands like vp dev, vp check, vp test, vp build, vp pack and vp run. Since its alpha, the team has merged over 500 pull requests, expanded vp migrate coverage, and added enterprise features like organisation templates. Over 1,300 public repositories already use it, including Dify, BlockNote and Cloudflare's vinext. Reception on Hacker News was largely positive, though a widely shared GitHub write-up by Jared Wilcurt criticized its vp env Node version manager and warned about ecosystem lock-in and heavy reliance on Rust rewrites of existing tools.

Читать полностью…

Computer Science and Programming

Stop burning tokens on code review


An engineering leader shares why AI-based code review tools like Cursor's BugBot and custom Claude code review skills became too slow, noisy, and expensive (hitting $1000/day in one case) for a team producing thousands of PRs a quarter. The fix that worked: converting team-specific coding rules from markdown guidelines into custom linters, which run in seconds, are deterministic, can run in-editor and on pre-commit hooks, and stop agents from ever pushing bad code. Several example custom lint rules are shared, covering design system consistency, logging, testing conventions, and prose quality.

Читать полностью…

Computer Science and Programming

WebSocket vs SSE vs Long Polling: The Real Cost of 1,000 Events

A hands-on benchmark built with a Node harness and a byte-counting TCP proxy measures the real wire cost of WebSocket, SSE, and long polling delivering 1,000 events. WebSocket used 119,692 bytes, SSE 131,596 (10% more), and HTTP/1.1 long polling 884,698 bytes (7.4x), mostly re-sent headers. On HTTP/2, long polling drops to 182,475 bytes (1.56x payload). Latency differences at low event rates were under 0.3ms across all three; long polling only degrades when events arrive faster than a round trip. Server memory for 500 idle connections favored WebSocket (6.2-6.7MB) over SSE (11MB) and long polling (10.3-10.9MB). Practical failure modes covered include idle timeouts, proxy buffering, and the six-connections-per-origin HTTP/1.1 cap on SSE. The recommendation: build SSE first for server-to-client feeds, move to WebSocket only when upstream or binary data is needed.

Читать полностью…

Computer Science and Programming

No Index GroupBy Optimization

Dolt and Doltgres were using a secondary index for GROUP BY queries even when a full table scan would be faster. By analyzing EXPLAIN output and flame graphs, the team discovered that when a filter selects more than ~50% of rows, the secondary index lookup overhead outweighs its benefits. They added heuristics to the query coster: secondary indexes are only preferred when they select fewer than 25% of rows, while primary keys and covering indexes are always preferred. Using existing statistics histograms to estimate filter selectivity, this reduced groupby_scan latency by 57% on Dolt (144ms → 62ms) and 44% on Doltgres (147ms → 83ms), making Dolt faster than MySQL on this benchmark.

Читать полностью…

Computer Science and Programming

What's new in PHP 8.6

PHP 8.6, scheduled for release on November 19, 2026, introduces several notable features: partial function application (PFA) for prefilling closure parameters, readonly property defaults (now allowed when implementing interfaces with property hooks), a new low-level Polling API for I/O multiplexing with epoll/WSAPoll backends, a built-in clamp() function, new isReadable/isWriteable reflection methods, function parameter doc comments via ReflectionParameter::getDocComment(), a SortDirection enum, debuggable enums via __debugInfo(), and improved session security defaults (HttpOnly, SameSite=Lax). The release also includes a large set of deprecations covering legacy functions (is_double, is_integer, is_long, doubleval, strcoll, metaphone, spl_classes, spl_object_hash), ArrayIterator methods, SplFileObject CSV methods, returning from finally blocks and constructors/destructors, and reserving keywords like let, is, and namespace for future syntax.

Читать полностью…

Computer Science and Programming

React 19.3 – React

React 19.3 is now available on npm, stabilizing two previously experimental APIs: View Transitions and Fragment Refs. The new <ViewTransition> component animates elements entering, exiting, moving, or resizing using the browser's View Transition API, with support for custom animations via addTransitionType and integration with Suspense for coordinated loading of fallbacks, images, and fonts. Fragment Refs let developers attach DOM behaviors (event listeners, focus management, IntersectionObserver/ResizeObserver) to a group of sibling elements without needing a wrapper div, by passing a ref to a Fragment. React DOM adds a new browser() API to opt components out of server-side rendering when they depend on browser-only APIs, plus Trusted Types support to prevent DOM-based XSS. Server Components can now render Context directly from a 'use client' module without a wrapper Provider. The release also includes numerous other changelog items and bug fixes across react, react-dom, and react-server

Читать полностью…

Computer Science and Programming

Bun v1.4.2

Bun v1.4.2 patches two regressions introduced in v1.4.1: a bun build variable name collision that broke Elysia imports with a SyntaxError, and an AsyncLocalStorage memory leak affecting timers and promises created inside store.exit() or nested store.run(). It also fixes a worker_threads 'online' event ordering bug that caused @discordjs/ws to hang, adds CMYK/YCCK JPEG decoding support to Bun.Image, pulls in roughly 350 upstream WebKit/JavaScriptCore commits fixing Intl, TypedArray, and Proxy correctness issues, and resolves several crash and hang bugs including a rare JIT crash, a musl GC crash, a bun install panic, and a double-close file descriptor bug on Linux

Читать полностью…

Computer Science and Programming

What’s new in Svelte: September 2026

Svelte 5.57 adds new SvelteMap methods (getOrInsert, getOrInsertComputed), a createContext has function, select defaultValue support, and new svelte/server type exports. SvelteKit 3's next release candidate continues iterating with several breaking changes including reworked cross-page form actions, split Vite plugin hooks, defineParams relocation, and route filtering for test files. The sv CLI replaces its mcp add-on with a broader ai-tools add-on and ships a task-based sveltekit-3 migration command that rewrites $lib imports to #lib and bumps dependencies. The roundup also covers stable SvelteKit 2.x patches, language tools updates, and a community showcase of Svelte apps, UI libraries, and dev tools.

Читать полностью…

Computer Science and Programming

Hello everyone some of you may not know but now we started to expand to WhatsApp and we are inviting you to join our WhatsApp channel link here 👇👇👇👇👇

WhatsApp Computer Science and Technology

We welcome you all to be part of this family

Читать полностью…

Computer Science and Programming

The best dark mode toggle is probably none • Lea Verou

Building on an earlier post advocating two-state (rather than tri-state) dark mode toggles, the author now argues that most websites shouldn't have a persistent dark mode toggle at all — the setting should default to following the OS and live in a settings panel instead. The piece responds point by point to Bramus's counter-argument for tri-state toggles (a scenario involving OS auto-switching plus reverted selections), calling it rare, cheaply recoverable, and a case of developers overweighting their own edge cases (IKEA effect meeting false-consensus bias). It also surveys community-designed alternative toggles (Vale's 3-in-2 design,

Читать полностью…

Computer Science and Programming

Hello everyone some of you may not know but now we started to expand to WhatsApp and we are inviting you to join our WhatsApp channel link here 👇👇👇👇👇

WhatsApp Computer Science and Technology

We welcome you all to be part of this family

Читать полностью…

Computer Science and Programming

Node.js — Node.js 24.20.0 (LTS)

Node.js 24.20.0 'Krypton' LTS ships several SEMVER-MINOR additions: using scopes for AsyncLocalStorage, an end parameter for Buffer, permission.drop and a new --permission-audit flag, package maps support in the loader, a new node:stream/iter module, context.log() in the test runner, and WebAssembly JSPI enabled. It also updates root certificates to NSS 3.125 and bundles numerous dependency upgrades (npm 11.19.0, ngtcp2, nghttp3, c-ares, sqlite, timezone data) plus a long list of bug fixes across crypto, buffer, http, http2, quic, and net modules.

Читать полностью…

Computer Science and Programming

Hello everyone some of you may not know but now we started to expand to WhatsApp and we are inviting you to join our WhatsApp channel link here 👇👇👇👇👇

WhatsApp Computer Science and Technology

We welcome you all to be part of this family

Читать полностью…

Computer Science and Programming

Hello everyone some of you may not know but now we started to expand to WhatsApp and we are inviting you to join our WhatsApp channel link here 👇👇👇👇👇

WhatsApp Computer Science and Technology

We welcome you all to be part of this family

Читать полностью…

Computer Science and Programming

Introducing G#: A Go-like language for .NET

G# is a new open-source, Go-inspired programming language that compiles to .NET, targeting systems programming and mobile applications while interoperating with existing .NET libraries and NuGet packages. It supports .NET 8 through 10 (10 preferred), offers a VS Code extension with language server support, and blends .NET-style async/await with Go-like fire-and-forget concurrency and channels via an optional extensions package. The language uses packages, funcs, structs and classes, and features like if let and for in for concise null checks and iteration. Beyond general development, it's positioned as an educational language and a lightweight candidate for WebAssembly and Hyperlight microVM scenarios, useful for developers moving from Swift or Kotlin into the .NET ecosystem.

Читать полностью…

Computer Science and Programming

How MongoDB Reduced PR Review Times with GitDailie

A case study describes how MongoDB adopted GitDailies, a GitHub PR alerting and metrics tool, to help engineering teams meet PR review SLAs. Customizable alerts, Slack integration, and personalized dashboards replaced ineffective existing alerting, reportedly cutting review times by up to 54% for one team and over 28% for nearly half the teams involved.

Читать полностью…

Computer Science and Programming

Does anyone run Postgres without PgBouncer?

Almost every notable managed Postgres provider bundles a connection pooler like PgBouncer, according to a survey of major providers including AWS RDS, Azure, Google Cloud SQL, Supabase, Neon, DigitalOcean, and others. Only IBM Cloud and Oracle OCI lack a managed pooling option, and both are dismissed as unlikely choices outside enterprise sales cycles. The piece argues connection pooling is effectively a mandatory add-on because Postgres itself handles many connections poorly, and contrasts this with MySQL and MongoDB, which don't require a bolted-on pooler. The wasted effort of every provider building homegrown pooling setups and every user having to learn PgBouncer's quirks (like the lack of LISTEN/NOTIFY support) is framed as evidence that native connection pooling in Postgres itself would be a high-impact improvement.

Читать полностью…

Computer Science and Programming

Dark mode toggles: two states are enough • Lea Verou

(Light, Dark, System). The core argument is that users only seek out theme toggles when something is wrong — not to preemptively express intent — making the 'System' state irrelevant at the moment of interaction. Tri-state toggles expose the underlying data model rather than aligning with actual user goals, adding cognitive load and UI friction for an extremely rare use case. A well-implemented two-state toggle can still represent all three underlying states: the first click overrides to the opposite of the current resolved value, and the second click removes the override and returns to system default. Common mistakes include storing a value that matches the system preference (silently pinning the theme) or removing overrides when the OS preference changes. Exceptions where tri-state controls are appropriate include dedicated settings panels and sites that implement meaningfully different color schemes depending on the OS setting.

Читать полностью…

Computer Science and Programming

DuckDuckGo "Normal F**king Sunglasses" Sold Out In Under a Week

DuckDuckGo partnered with sunglasses brand Knockaround to release "Normal F**king Sunglasses" — a satirical product mocking AI-powered smart glasses. The glasses have no camera, microphone, AI, battery, or electronics of any kind. They sold out in under a week. The collaboration is a commentary on growing surveillance concerns around AI glasses, particularly following Meta's use of Ray-Ban Meta smart glasses footage to train its AI systems and the June 2026 launch of Meta Glasses.

Читать полностью…

Computer Science and Programming

Retiring the Copilot Billing Preview app

GitHub has retired the Copilot Billing Preview app. Copilot spend can now be managed directly in GitHub billing settings, which offers a more complete view including user-level budgets, cost centers, and usage pool allocation. Users can view AI usage, set spending budgets, access user-level budget controls for organizations and enterprises, and pull raw usage data via usage reports and the billing API.

Читать полностью…
Subscribe to a channel