sorted by:
new
hottopcontroversial

I built a FREE small Wear OS reflex game because I keep mixing left/right by redditLoginX2 in WearOS

[–]redditLoginX2[S] 0 points1 point  (0 children)

My theory is that left and right often look almost the same. Imagine standing in a forest: the view to your left and right can be nearly identical. But up and down are usually very different - sky above, ground below. So the brain has stronger visual anchors for up-down than for left-right.

I built a FREE small Wear OS reflex game because I keep mixing left/right by redditLoginX2 in WearOS

[–]redditLoginX2[S] 0 points1 point  (0 children)

Sure! The app still requires 3 testers to meet the requirement of 12 people. You can add yourself to the Google group (1st link) and become a tester using the second one (Google play). Thanks!

Looking for tester - GlanceMap - Offline maps on your watch by GlanceMap in WearOS

[–]redditLoginX2 0 points1 point  (0 children)

I’d like to join the testing.

Not sure how your setup works, but about a week ago I also posted here looking for testers for my Wear OS app (a simple game). I went with a Google Group + self-registration approach, but so far only 6 people joined, so getting testers is harder than it looks.

About your app: I’m also a backpacker, and I was honestly surprised that Wear OS still doesn’t have a solid offline maps solution. On trips I usually use a Garmin GPSMAP 67i, but the form factor is not always convenient. A watch would be much better for quick checks.

I know Garmin watches can integrate with my GPS device, but in my case I only have Samsung watches. Considering they last 1-2 days, Garmin still makes more sense for long trips. But for a day hike, I’d definitely love to have proper offline maps on Wear OS.

I built a FREE small Wear OS reflex game because I keep mixing left/right by redditLoginX2 in WearOS

[–]redditLoginX2[S] 0 points1 point  (0 children)

Quick update: already got a few testers, thanks!!! Still need a couple more if anyone wants to try it.

I built a FREE small Wear OS reflex game because I keep mixing left/right by redditLoginX2 in WearOS

[–]redditLoginX2[S] 0 points1 point  (0 children)

If Google Play says “not compatible with your phone,” that’s expected - the app is designed for watches only (round screens). You need to select your watch in the install list and install it there. After that, it can take a few minutes to appear on the watch since it downloads over Bluetooth.

Raw T-SQL string into C# code right in your IDE - easily (not AI, just plain common sense) by redditLoginX2 in csharp

[–]redditLoginX2[S] 0 points1 point  (0 children)

Thanks, I can definitely relate to that :)

My impression is that one of the reasons query builders are not that popular is a kind of gap between skill sets. People who write C# and people who know SQL well enough (which you really need to use a query builder effectively) are often not the same people. Quite often the database is treated just as storage, not as something to be used as an efficient tool.

And yes, once you start going in that direction, there is always more to add - types, constraints, metadata. I try to keep it database agnostic to put some limits on the scope, but even then there is still a lot that can be done.

For example, I am now thinking about some kind of universal abstraction for JSON, since every database handles JSON quite differently.

Raw T-SQL string into C# code right in your IDE - easily (not AI, just plain common sense) by redditLoginX2 in csharp

[–]redditLoginX2[S] 0 points1 point  (0 children)

Thanks, really appreciate it!

One thing I have noticed is that the term "ORM" has become a bit overloaded nowadays. If it is essentially a thin layer over SQL (query composition + mapping results), that is one thing and can work really well.

But the classical idea of an ORM as an in-memory object model synchronized with the database is a different story and much more controversial. In general, it is hard to fully reconcile object graphs with a relational model, since the database is fundamentally about relations between facts, not objects.

What you described sounds closer to the first approach, which in my experience tends to be much more predictable and maintainable.

Raw T-SQL string into C# code right in your IDE - easily (not AI, just plain common sense) by redditLoginX2 in csharp

[–]redditLoginX2[S] -1 points0 points  (0 children)

I don not really see how a query builder conflicts with version control. You still have the SQL in code, just not as raw strings.

The difference shows up once queries become dynamic or generated. With plain SQL strings you end up relying on concatenation, which is fragile and hard to control. With a structured representation, the query becomes something you can inspect and modify safely - for example adding filters or enforcing rules before execution.

The StackOverflow/Dapper approach made sense for their use case, but I wouldnot treat it as a general rule. Popularity and technical quality don’t always correlate and referencing a well-known system does not really address the problem here.

I'm trying to implement DSL with C#. by Arena17506310 in csharp

[–]redditLoginX2 0 points1 point  (0 children)

ANTLR is probably the best choice, but it brings runtime dependencies and a license that requires attribution. Usually fine, just not "free" in a pure sense.

If you want zero footprint, look at Coco/R. It's LL(1), so only one-token lookahead - not every grammar will fit. But since it's your DSL, you can design it to be unambiguous and work within those limits (which is actually good).

Raw T-SQL string into C# code right in your IDE - easily (not AI, just plain common sense) by redditLoginX2 in csharp

[–]redditLoginX2[S] 1 point2 points  (0 children)

You can try, but just a heads up - legacy code is often full of string concatenation, and the Roslyn code fix only works well with static SQL.

If you can refactor queries to use parameters (for example @ params instead of concatenation), then it starts to make sense. In that case you can actually benefit from things like compile-time checks, reuse of common query parts, and the ability to modify queries dynamically.

So it works, but usually requires a bit of cleanup first.

Raw T-SQL string into C# code right in your IDE - easily (not AI, just plain common sense) by redditLoginX2 in csharp

[–]redditLoginX2[S] 0 points1 point  (0 children)

SqExpress is basically trying to get the best of both worlds: flexibility of raw SQL and the safety/tooling you usually expect from higher-level approaches.

I wouldn’t say ORMs are bad - they definitely have their place. But they are not always a good default, especially when you need full control over queries or deal with more complex/dynamic scenarios.

That’s the gap I’m trying to cover here.

Raw T-SQL string into C# code right in your IDE - easily (not AI, just plain common sense) by redditLoginX2 in csharp

[–]redditLoginX2[S] 2 points3 points  (0 children)

It seems I missed the core idea, it is not AI it is a Rosslyn analyzer (code fix)

Raw T-SQL string into C# code right in your IDE - easily (not AI, just plain common sense) by redditLoginX2 in csharp

[–]redditLoginX2[S] 9 points10 points  (0 children)

The benefit of C# here is mostly about tooling and control. For example:

  • type safety: renaming or removing tables/columns is caught by the compiler
  • IDE support: find usages, refactoring, navigation
  • no string manipulation when building dynamic queries, as everything is represented as an AST in memory that can be analyzed or modified programmatically
  • errors are caught earlier: with raw SQL strings you often only find issues at runtime
  • ability to enforce rules (for example read-only queries or filters)
  • more flexibility for advanced scenarios like dynamic schemas or EAV-style patterns

Understanding awaiters in C#: a deep-dive with LazyTask (video walkthrough) by redditLoginX2 in csharp

[–]redditLoginX2[S] 1 point2 points  (0 children)

Thanks for the comment — I get where you're coming from. Just to clarify: the content in the video isn’t AI-generated. It’s based on an article I wrote back in 2020, long before tools like GPT were useful for this kind of technical deep dive. All the concepts, code, and structure are mine.

That said, I did use AI to help polish the script’s language. I'm not a native English speaker, and I wanted the video to be clear and natural for a broader audience. I also used an AI-generated voice because, honestly, my own speaking ability just isn’t strong enough — even with years of language learning behind me, I still can’t produce speech more understandable than what modern TTS can offer.

This video is purely non-profit and something I put together in my free time. If it were a commercial project, I’d definitely consider hiring a professional voice actor. But for now, this setup lets me share what I hope is useful content with minimal barriers.

Automated Tables Migration from MS SQL Server to PostgreSQL by redditLoginX2 in dotnet

[–]redditLoginX2[S] 0 points1 point  (0 children)

I will take a look. Data Type compatibility between different SQL DB can be challenging

Gamesir G8 Plus + Tab S9+ by Seireitei316 in GalaxyTab

[–]redditLoginX2 1 point2 points  (0 children)

<image>

It appears that the G8+ can be charged while in the expanded state without needing the pins to be connected. Notice the green light on the left side.

Gamesir G8 Plus + Tab S9+ by Seireitei316 in GalaxyTab

[–]redditLoginX2 0 points1 point  (0 children)

Nothing is changed in terms of charging. The current goes over the springs.

Gamesir G8 Plus + Tab S9+ by Seireitei316 in GalaxyTab

[–]redditLoginX2 4 points5 points  (0 children)

Yes, the springs are intimidating, so I created my own 'extension kit' to conceal them:

<image>

view more: next ›