stux
Re:2004 RuneScape fit a multiplayer RPG into 56k dial-up
on Monday August 31, 2026 @10:56PM (#49517482)
> Before any networking occurs, the client runs a breadth-first search using the local collision map to build a path from where you are to where you clicked, and then writes the packet for the server to read. [...] The packet contains the absolute position of the first waypoint in the path, followed by the delta of each waypoint in the path against the first one
How come the client sends waypoints rather than just the destination? Naively it seems like sending less data would be better. Is the pathfinding so expensive that you'd want to avoid doing it on the server? I suppose it works out as long as it's cheap to validate/correct the client's path?
Re:Parrot – type-safe SQL in Gleam, supports SQlite, PostgreSQL and MySQL
on Sunday October 05, 2025 @10:01AM (#45481542)
These sqlc-style libraries are a great solution to the problem of “make running a query as easy as calling a function”, but I’ve always thought SQL’s lack of composability is a more interesting problem that I haven’t seen addressed (the problems with views are well documented).
Re:nullable but not null
on Friday July 25, 2025 @02:19PM (#44686423)
This is interesting! A field being nullable because it's legitimately optional in the domain model is one thing, but for new fields which shouldn't be nullable in the domain model, unless you can pick a reasonable identity value, you need a concept of absence that's different from null. Luckily the intersection of "non-nullable fields" and "fields with no reasonable identity value" and "fields which didnt exist in v1 of the domain model" is normally pretty small, but it's painful when it happens.
This reminds me of frozen/nonfrozen enums in Swift. You can do exhaustive case analysis on frozen enums, but case analysis on nonfrozen enums requires adding an `@unknown default` case.
https://docs.swift.org/swift-book/documentation/the-swift-pr...
Re:Web apps built with Ruby on Rails
on Friday January 10, 2025 @01:29PM (#42658443)
Rails definitely seems optimized for creating code, but how is it at maintaining code? I've never used it, but it seems like Ruby's dynamic types would make it really challenging to do large refactors. What techniques do rails developers use?
Re:Some Programming Language Ideas
on Wednesday January 08, 2025 @04:57PM (#42638887)
> with functions named by their normalized hash contents, and referred to anywhere by that, but I can't seem to remember what it's called right now. Something like "Universe" I think?
Re:We're forking Flutter
on Monday October 28, 2024 @07:02PM (#41977483)
> Flutter founder here.
Given that the literal founder of Flutter is in this thread using this introduction multiple times, it’s kinda hard to give you the benefit of the doubt that you honestly just meant “a founder using Flutter”.
Re:We're forking Flutter
on Monday October 28, 2024 @06:12PM (#41976995)
https://github.com/flutter/flutter/pulls?q=is%3Apr+author%3A...
- 0 open PRs
- 2 PRs merged, 1 PR closed in the past 4 years
- All PRs reviewed by a member of the Flutter team within 24hrs
- [“If I'm still supposed to write tests, even for this change, then this is probably as far as I take the PR.”](https://github.com/flutter/flutter/pull/128910#issuecomment-...)
- 40+ PRs from 2019
So, disgruntled ex-employee?
Re:Swift Static Linux SDK
on Tuesday June 11, 2024 @07:25PM (#40652827)
> Anonymous enums/structs in parameters
Can you share an example of this? It sounds really interesting but I couldn’t find any references. Do you mean the parameter “packs” features?
Re:The Git repositories of XZ projects are available on GitHub again
on Tuesday April 09, 2024 @06:52PM (#39985204)
Edit: nvm, dupe of https://news.ycombinator.com/item?id=39984512
Re:SQLite 3.44: Interactive release notes
on Wednesday November 01, 2023 @09:39AM (#38098028)
> Aggregate functions can now include an ORDER BY clause after their last parameter.
Hopefully that means we'll soon get support for `DISTINCT` in `GROUP_CONCAT`.
Atm you can do `group_concat(x, '|')` and `group_concat(distinct x)`, but you can't do `group_concat(distinct x, '|')`.
Re:Using Redundant Conditions to Unlock Indexes in MySQL
on Wednesday June 07, 2023 @02:13PM (#36230918)
As the article notes,
> Redundant conditions are nice because they require no changes to the database [...] This makes them useful for queries that are only sometimes run or where indexes can't be easily added to the main conditions
but where possible I typically prefer adding an index on the expression that the query is using (if your database supports it) since it expresses your intent more clearly. A redundant condition is more likely to get "optimized away" by other developers or changes in the query planner.
Re:Ask HN: What are some of the best podcasts for developers?
on Sunday December 11, 2022 @01:22PM (#33945799)
My two favourites at the moment that haven’t already been mentioned are:
https://podcasts.apple.com/ca/podcast/algorithms-data-struct...
https://podcasts.apple.com/us/podcast/software-unscripted/id...
Reminds me of the principles brought up in this talk by Sean Parent:
The temperature converter is a good example of an “implies” relationship, which Sean argues is difficult to model in UIs.
Re:SQLite: Vulnerabilities
on Monday July 05, 2021 @08:53AM (#27737440)
I think the tone of this page is frustration that this page needs to exist. I think if I had to constantly deal with stuff like this I'd be pretty frustrated too:
> CVS-2019-19317 is an excellent example of a bogus CVE. This CVE describes a bug in an unreleased development version of SQLite. We were working on the new generated columns feature of SQLite, and a third-party hacker found an error in the code under active development, and then wrote a CVE against it. The error was fixed before the problem was ever released, and yet still there is this CVE sitting out there, unresolved, and as far as I can tell unresolveable.
Lot's of great related discussion from drh in this[0] sqlite forum thread.
Re:Writing a SQLite clone from scratch in C (2017)
on Sunday July 04, 2021 @11:18PM (#27734355)
I agree with your general point that "it's very hard to write safe C code", and
> people keep finding use-after-free bugs in sqlite3
is true, but
> that allow attackers to escalate the memory corruption into arbitrary code execution... bugs that have affected major projects, including iCloud and Chrome; here are a handful: there are lots more even from just the past year :/
is just incorrect. I'd strongly encourage you to read https://www.sqlite.org/cves.html
Re:Simple SQL in Python
on Thursday August 13, 2020 @01:07PM (#24145587)
Yeah this approach is definitely way nicer with some tooling support.
For example https://github.com/cashapp/sqldelight for Kotlin integrates with IntelliJ to provide ctrl+click navigation (see gif in their readme), and https://github.com/simolus3/moor/ for Dart has similar features that integrate with VSCode (https://moor.simonbinder.eu/docs/using-sql/sql_ide/).
(...since everyone is linking their favorite libraries with a similar approach!)
Re:How we use Rust in our mobile SDK
on Wednesday April 29, 2020 @07:34AM (#23017949)
Dart’s FFI is still stabilizing, but there’s a small example here https://github.com/brickpop/flutter-rust-ffi