MySqlConnector VS osu

MySqlConnector (the most popular .NET library for MySQL, and the one that I authored) has supported protocol compression for many years: https://github.com/mysql-net/MySqlConnector/issues/31.

> I kept technical notes about the protocol, to serve as a future reference for myself and for other developers.

As someone who's written a MySQL client (in C#: https://github.com/mysql-net/MySqlConnector), I'd be very interested to see your notes. Are they available anywhere, or were they the confidential IP of your client?

> Unsurprisingly, bugs were uncovered every time a new client was added.

I've faced the same thing, from a client perspective. Every time a new server is tested (MySQL, MariaDB, Amazon Aurora, Azure Database for MySQL, etc.), I find slightly different interpretations of the protocol and have to accommodate them.

I have had the pleasure of contributing to a couple different networked drivers with very talented maintainers that I like to use as references.

One supports a wide array of Framework versions and has both Sync and Async I/O, as it must to implement the ADO.NET database driver interfaces. Reading the internals really highlight the way that .NET has evolved over the years and what must be done in each target version to maximize performance:

https://github.com/mysql-net/MySqlConnector

The other supports .NET 6 only with Async I/O only. This support policy seems to be the way that "modern" .NET development is headed, as .NET 6 will be the floor for LTS .NET (formerly .NET Core) releases in a few months. Async APIs only greatly simplify development, and make it simpler to remain performant when targeting WASM.

https://github.com/Cysharp/AlterNats

As a library maintainer, one thing I often wonder about is how to indicate .NET version support. One option would be for the major version of the library to track the major version of .NET, so if I were to publish a new library today then start with .NET 6 support and start with version number 6.0.0 instead of 1.0.0. This would limit the library to only making breaking changes when the .NET version changes though.

Use the MySqlConnector to load the data into a temp table using the bulk copy API. Both of my libraries implement the IDataReader (DbDataReader) interface, so they can be directly used with the bulk copy APIs. Then insert into the final table from the temp table filtering out rows that are already in the final table.

I'm the author of what you might call the "new" MySQL ADO.NET library: https://github.com/mysql-net/MySqlConnector

I agree with your impression that developers of the other library don't seem to be "plugged in to" the .NET ecosystem. As an independent developer (not affiliated with Oracle or Microsoft), I've been able to influence GitHub PRs that shape the ADO.NET API for .NET 6.0, just by showing up and contributing; I haven't seen anyone from the Oracle MySQL team participating. Meanwhile, they violate basic principles of the .NET Framework Design Guidelines that have been around for over a decade (https://docs.microsoft.com/en-us/dotnet/standard/design-guid...), which makes their library feel alien to a .NET programmer (regardless of the quality issues it might have).

e.g. this community effort of a MySQL ADO.NET provider is miles ahead of Oracle's driver.

{"id":54,"name":"osu!","description":"osu! is a free-to-play rhythm game created by Dean \"peppy\" Herbert and released in 2007. It was originally created for Microsoft Windows and has since been ported to macOS, Linux, Android, and iOS. \n\nThe garish, large, and flat pink osu! logo has been an iconic and controversial fixture of r/place ever since its original incarnation in 2017.","links":{"website":["https://osu.ppy.sh/","https://en.wikipedia.org/wiki/Osu!"],"subreddit":["osuplace","osugame"]},"path":{"4-256":[[223,190],[222,191],[219,191],[218,192],[215,192],[214,193],[212,193],[211,194],[210,195],[209,195],[208,196],[207,196],[205,198],[204,198],[204,204],[198,204],[198,205],[196,207],[196,208],[194,210],[194,211],[193,212],[193,214],[192,215],[192,217],[191,218],[191,222],[190,223],[190,229],[191,230],[191,236],[192,237],[192,238],[193,239],[193,242],[194,243],[194,244],[196,246],[196,247],[198,249],[198,250],[204,256],[205,256],[207,258],[208,258],[210,260],[211,260],[212,261],[214,261],[215,262],[217,262],[218,263],[222,263],[223,264],[230,264],[231,263],[236,263],[237,262],[239,262],[240,261],[242,261],[243,260],[244,260],[246,258],[247,258],[249,256],[250,256],[256,250],[256,249],[258,247],[258,246],[259,245],[259,244],[261,242],[261,240],[262,239],[262,236],[263,235],[263,232],[264,231],[264,230],[264,227],[264,226],[263,225],[263,224],[262,223],[262,215],[261,214],[261,213],[260,212],[260,211],[259,210],[259,209],[258,208],[258,207],[256,205],[256,204],[250,198],[249,198],[247,196],[246,196],[245,195],[244,195],[242,193],[240,193],[239,192],[237,192],[236,191],[232,191],[231,190]]},"center":{"4-256":[227,229]}}

maybe you only play in lazer, if so replace your account url from osu.ppy.sh to lazer.ppy.sh

osu! (latest version is FOSS)

If you need a screenshot then there's one here: https://github.com/ppy/osu/discussions/23343

there's been a cross platform version for a few years, it's quite nice https://github.com/ppy/osu/

Custom rulesets are posted here. Most of them have instructions on their respective GitHub pages but generally it goes: To install this ruleset put the .DLL file onto your osu/Rulesets directory under %appdata%/. Restart osu!lazer and it will do the rest for you.

{ "id": "txibq9", "name": "osu!", "description": "osu! is a free-to-play rhythm game where the player clicks circles to the beat. The game was created by Dean \"peppy\" Herbert and released on September 16, 2007. It was originally written in C# on the .NET framework for Microsoft Windows, and has since been ported to macOS, Linux, Android, and iOS. It was inspired by iNiS's rhythm game Osu! Tatakae! Ouendan, and also takes inspiration from other rhythm games like Taiko no Tatsujin, Beatmania IIDX, Elite Beat Agents, O2Jam, StepMania, and DJMax. The game is heavily community-oriented, with all beatmaps and playable songs being community-made through the in-game map editor. Four different game modes exist, offering various ways to play a beatmap, which can also be combined with modifiers that increase or decrease the difficulty. The original osu!standard remains the most popular to date. As of r/place 2022, the game had 19,872,585 monthly active users according to the game's global country leaderboards.\n\nThis art is centered at the coordinates (727, 727), a reference to the osu! meme WYSI (when you see it). The meme originates from osu! top player chocomint setting a score worth 727pp (performance points) on the map \"Blue Zenith\", twice in 2016 and 2017. The meme saw a resurgence in 2020 from the top player Aireu after setting a play on \"Guess Who Is Back\", awarding him 727pp.\n\nIn 2017, the osu! logo was one of the most long-lasting, organized, well-maintained, and griefed logos, and continued its trend in 2022. It began as a controversial build due to its large size, and the bottom-right of the circle was heavily disputed with r/Superstonk's GameStop artwork. Despite multiple raids and griefs from larger communities and streamers, the osu! community proved to be indestructible, defending itself and its many allies.", "links": { "website": [ "https://osu.ppy.sh", "https://en.wikipedia.org/wiki/Osu!" ], "subreddit": [ "osuplace", "osugame" ] }, "path": { "T:0-1, 1-164": [ [ 721, 678 ], [ 728, 678 ], [ 729, 678 ], [ 729, 679 ], [ 730, 679 ], [ 730, 680 ], [ 731, 680 ], [ 731, 681 ], [ 735, 681 ], [ 735, 680 ], [ 736, 680 ], [ 737, 679 ], [ 746, 679 ], [ 746, 681 ], [ 748, 681 ], [ 748, 682 ], [ 750, 682 ], [ 750, 683 ], [ 752, 683 ], [ 752, 684 ], [ 753, 684 ], [ 753, 685 ], [ 755, 685 ], [ 755, 687 ], [ 758, 687 ], [ 766, 696 ], [ 766, 697 ], [ 769, 701 ], [ 770, 702 ], [ 770, 704 ], [ 771, 704 ], [ 771, 707 ], [ 773, 709 ], [ 773, 712 ], [ 774, 712 ], [ 774, 715 ], [ 775, 715 ], [ 775, 720 ], [ 776, 721 ], [ 776, 734 ], [ 770, 734 ], [ 770, 755 ], [ 768, 755 ], [ 768, 756 ], [ 767, 756 ], [ 767, 758 ], [ 766, 758 ], [ 766, 759 ], [ 765, 759 ], [ 765, 760 ], [ 764, 760 ], [ 763, 760 ], [ 763, 761 ], [ 762, 761 ], [ 762, 763 ], [ 761, 763 ], [ 761, 764 ], [ 758, 767 ], [ 757, 767 ], [ 755, 769 ], [ 753, 769 ], [ 753, 770 ], [ 752, 771 ], [ 750, 771 ], [ 750, 772 ], [ 748, 772 ], [ 748, 773 ], [ 746, 773 ], [ 744, 775 ], [ 740, 775 ], [ 739, 776 ], [ 735, 776 ], [ 734, 777 ], [ 720, 777 ], [ 720, 776 ], [ 715, 776 ], [ 715, 775 ], [ 711, 775 ], [ 711, 774 ], [ 709, 774 ], [ 709, 773 ], [ 706, 773 ], [ 706, 772 ], [ 704, 772 ], [ 704, 771 ], [ 702, 771 ], [ 702, 770 ], [ 701, 770 ], [ 701, 769 ], [ 699, 769 ], [ 699, 768 ], [ 698, 768 ], [ 698, 767 ], [ 696, 767 ], [ 696, 766 ], [ 695, 766 ], [ 695, 765 ], [ 694, 765 ], [ 694, 764 ], [ 693, 764 ], [ 693, 763 ], [ 692, 763 ], [ 692, 762 ], [ 691, 762 ], [ 691, 761 ], [ 690, 761 ], [ 690, 760 ], [ 689, 760 ], [ 689, 759 ], [ 688, 759 ], [ 688, 758 ], [ 687, 758 ], [ 687, 755 ], [ 685, 755 ], [ 685, 753 ], [ 684, 753 ], [ 683, 752 ], [ 683, 750 ], [ 682, 750 ], [ 682, 748 ], [ 681, 748 ], [ 681, 744 ], [ 680, 744 ], [ 680, 743 ], [ 679, 743 ], [ 679, 739 ], [ 678, 739 ], [ 678, 734 ], [ 677, 734 ], [ 677, 721 ], [ 678, 721 ], [ 678, 717 ], [ 679, 717 ], [ 679, 712 ], [ 680, 711 ], [ 680, 709 ], [ 681, 709 ], [ 681, 706 ], [ 682, 706 ], [ 682, 705 ], [ 683, 705 ], [ 683, 702 ], [ 684, 702 ], [ 684, 701 ], [ 685, 701 ], [ 685, 699 ], [ 686, 699 ], [ 686, 698 ], [ 687, 698 ], [ 687, 697 ], [ 687, 696 ], [ 688, 696 ], [ 688, 695 ], [ 689, 695 ], [ 689, 694 ], [ 690, 694 ], [ 690, 693 ], [ 691, 693 ], [ 691, 692 ], [ 692, 692 ], [ 692, 691 ], [ 693, 691 ], [ 693, 690 ], [ 694, 690 ], [ 694, 689 ], [ 695, 689 ], [ 695, 688 ], [ 697, 688 ], [ 696, 687 ], [ 697, 687 ], [ 697, 686 ], [ 699, 686 ], [ 699, 685 ], [ 701, 685 ], [ 701, 684 ], [ 702, 684 ], [ 705, 687 ], [ 710, 682 ], [ 710, 680 ], [ 711, 679 ], [ 712, 680 ], [ 712, 681 ], [ 713, 682 ], [ 714, 682 ], [ 714, 683 ], [ 717, 683 ], [ 719, 681 ] ] }, "center": { "T:0-1, 1-164": [ 724, 728 ] } }