MySqlConnector
aqtinstall
Our great sponsors
MySqlConnector | aqtinstall | |
---|---|---|
8 | 26 | |
1,352 | 853 | |
1.3% | - | |
9.2 | 8.2 | |
7 days ago | 7 days ago | |
C# | Python | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
MySqlConnector
-
Faster MySQL with HTTP/3
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.
-
Implementing the MySQL server protocol for fun and profit
> 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.
-
Ask HN: Examples of Top C# Code?
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.
- Do I need to worry about connection pooling/etc with MySql.Data.MySqlClient?
-
Need some help/direction reading CSV into MySQL without duplication
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.
- Finding an Authorization Bypass on My Own Website
-
Performance Improvements in .NET 6
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).
-
MongoDB C# Driver Vs. MongoDB.Entities Benchmark
e.g. this community effort of a MySQL ADO.NET provider is miles ahead of Oracle's driver.
aqtinstall
-
Qt 5.15.11 open source released
I've used aqt[1] before but it doesn't look like it's seeing 5.15.11 yet, just 5.15.2.
[1]: https://github.com/miurahr/aqtinstall
-
Unified Installer - Commercial only?
Don't use the Qt installer. It sucks. It's only reason is to annoy people and collect your data. Use aqt: https://github.com/miurahr/aqtinstall
-
Adventures in Debian's Qt Land
I mostly disagree. Like you said, Qt is the best native GUI toolkit available today. And that is a hard achievement. There are many tradeoffs (some you pointed out) but the open source community seems to find a way around those limitations. There are thousands of open source libraries you can plug-in into your Qt app to overcome many of its limitations (although some remain, like how can't we still not easily change caret/cursor color of QTextEdit??).
Unlike you, I like the direction where Qt is taking. I think QML and Qt Quick are great. I just implemented a feature in my note-taking app that turns Markdown text into Kanban board using QML and the experience has been great (https://github.com/nuttyartist/notes/pull/574). I'm planning to continue transition from QWidgets to QML/Qt Quick.
I do worry of the continuous friction with open source development and hate the online installers as well. I can recommend this useful tool https://github.com/miurahr/aqtinstall that allows you to easily download prebuilt Qt binaries. I hope they can revert their approach on that.
-
Current Issues With The Qt Project - From The Outside Looking In
Install the qt binaries from the command line https://github.com/miurahr/aqtinstall
-
KDE Plasma development switches to Qt 6 tomorrow
https://github.com/miurahr/aqtinstall will help you with that.
- Qt 6.5 will switch to FFMPEG as the default Qt Multimedia backend for all platforms
- Getting “QT with MinGW support”?
-
Qt 6.4 Released
you can install it from vcpkg or conan (or https://github.com/miurahr/aqtinstall if you really want the official Qt binaries) and it'll be much less
-
Trouble Building Qt6/5
Is there any particular reason why you want to build Qt yourself? This is usually quite painful and requires a lot of extra stuff (see https://wiki.qt.io/Building\_Qt\_6\_from\_Git) . If you just want to avoid the (horrible) official installer and a Qt account, you can use aqtinstaller to fetch everything you need: https://github.com/miurahr/aqtinstall
-
Please do not use Python for tooling
Just recently, I had to recompile a (singleplayer) save game editor. So basically a GUI that does some clever hex editing.
It was written in C++ using Qt.
Have you ever tried compiling a Qt program on Windows? It involves signing up for an official Qt developer account to even install qmake.
To the point I had to use an unofficial Qt installer CLI app (aqtinstall) [0] to even install the toolchain to build this little shitty app... which still relied on having several Qt .dll files in the same directory as the .exe to work.
Have you clicked on [0] yet? Well, then guess what programming language aqtinstall uses.
[0] https://github.com/miurahr/aqtinstall
What are some alternatives?
Pomelo.EntityFrameworkCore.MySql - Entity Framework Core provider for MySQL and MariaDB built on top of MySqlConnector
archinstall_gui - Guided Arch Linux graphical installer
Avalonia.FuncUI - Develop cross-plattform GUI Applications using F# and Avalonia!
openiddict-core - Flexible and versatile OAuth 2.0/OpenID Connect stack for .NET
Crow - A Fast and Easy to use microframework for the web.
Hot Chocolate - Welcome to the home of the Hot Chocolate GraphQL server for .NET, the Strawberry Shake GraphQL client for .NET and Banana Cake Pop the awesome Monaco based GraphQL IDE.
GuiLite - ✔️The smallest header-only GUI library(4 KLOC) for all platforms
Marten - .NET Transactional Document DB and Event Store on PostgreSQL
IdentityServer - The most flexible and standards-compliant OpenID Connect and OAuth 2.x framework for ASP.NET Core
imgui - Dear ImGui: Bloat-free Graphical User interface for C++ with minimal dependencies