Menu

#OffSet

65 posts

Feed·
20 of 65 posts
One day is not 24 hours: date arithmetic that breaks quietly, measured on SQLite and D1
📰
0Read More

One day is not 24 hours: date arithmetic that breaks quietly, measured on SQLite and D1

DEV Community: webdev·MapToSite·1 day ago
#Xbjhorvg
#devtowebdev#devto#dev#date#asia

The same 6,480 rows returned 4,320 in one timestamp format and 0 in another. Measured on SQLite 3.46.1 and D1: a 23-hour and a 25-hour day, 60 local minutes that do not exist in 2026, a 24h window that reports 2,283 / 2,160 / 540 rows for one dataset, 20…

15s
A finished paged walk of a live feed is not a snapshot
📰
0Read More

A finished paged walk of a live feed is not a snapshot

DEV Community: python·Markedet·1 day ago
#rcj8n0xR
#devtopython#devto#dev#rows#offset

Offset paging over a feed that keeps changing duplicates or skips rows without any error. Why it happens, a local test that reproduces it, and how to page so you can trust a count or an absence.

15s
Young Thug Responds to Quavo’s Attempt to Have Him Reconcile With Gunna: ‘How Uma Fix Some Sh– I Didn’t Break Qua?’
📰
0Read More

Young Thug Responds to Quavo’s Attempt to Have Him Reconcile With Gunna: ‘How Uma Fix Some Sh– I Didn’t Break Qua?’

#billboardcom#billboard#gunna#thug#offset

Young Thug responded to Quavo's attempt to have him reconcile with Gunna after Offset explained why he stayed loyal to Gunna following the YSL Trial.

15s
Twenty phone photos into one PDF you can still email: skip PdfDocument and embed the JPEG bytes
📰
0Read More

Twenty phone photos into one PDF you can still email: skip PdfDocument and embed the JPEG bytes

DEV Community: kotlin·Ashwar Sadh·5 days ago
#a9OXgksO
#devtokotlin#devto#dev#offset#caption

Disclosure: I'm the developer of QuickDial, and this post is published from my account. It was...

15s
The Polyglot Paradox: How I Made a Normal Image Extract as a Secret ZIP Archive
📰
0Read More

The Polyglot Paradox: How I Made a Normal Image Extract as a Secret ZIP Archive

DEV Community: python·Rolan Lobo·9 days ago
#JUnSPDW9
#devtopython#devto#dev#file#byte

A while back, I was staring at a hex dump in VS Code late at night trying to answer a ridiculous...

15s
An ExecuTorch .pte has no pickle. Its risk is every size and offset
📰
0Read More

An ExecuTorch .pte has no pickle. Its risk is every size and offset

DEV Community: pytorch·munimv2·16 days ago
#GNexE1Zw
#devtopytorch#devto#dev#size#file

A lot of model-file security work starts and ends with "is there a pickle in here?" For good reason:...

15s
0Read More

Reducing cash drag risk during tax loss harvesting.

Hello, I have around €10,000 in capital losses that I can offset against capital gains in next year’s tax return or in the following two tax years. On the other hand, I hold shares in a fund that tracks the MSCI World and has an unrealized gain of 67.5%.…

15s
12 pagination test cases every API client should pass
📰
0Read More

12 pagination test cases every API client should pass

DEV Community·wilsen·20 days ago
#mcYHhX7N
#dev#cursor#offset#limit#article

Most pagination bugs I've seen weren't in the happy path. Page 1 works, page 2 works, and then...

15s
Why My Pagination Got Slower Every Page: Field Notes on OFFSET, Keyset Cursors, and Stable Sort Keys
📰
0Read More

Why My Pagination Got Slower Every Page: Field Notes on OFFSET, Keyset Cursors, and Stable Sort Keys

DEV Community: webdev·Ahmed Mahmoud·21 days ago
#jc2OFHqU
#devtowebdev#devto#dev#cursor#sort

Headline: OFFSET pagination tells PostgreSQL to read every row it skips and then throw those rows...

15s
The Bug My Unit Tests Didn't Catch: An Infinite Loop in Mutation Testing
📰
0Read More

The Bug My Unit Tests Didn't Catch: An Infinite Loop in Mutation Testing

DEV Community: go·Narek Kostanyan·24 days ago
#cJuZJNUs
#devtogo#devto#dev#test#loop

Who the hell writes a unit test for an infinite loop? Well, now that's me 😇 When I started working...

15s