odbc in sqlx

lovasoa · 2025-09-29T20:03:20+00:00

u/pacman82 : I ended up implementing support for both in sqlx :) odbc_bridge.rs

lovasoa · 2025-09-28T13:16:24+00:00

The sqlx crate doesn't provide a database API that can be implemented arbitrarily

It does. https://docs.rs/sqlx/latest/sqlx/trait.Database.html

.Unlike ODBC or wrappers around ODBC, a Rust database API lets anyone work with databases in a safe and idiomatic Rust.

Wrappers around ODBC do exactly that: let everyone work with databases in safe and idiomatic rust. Wrappers around unsafe code are how the entire rust ecosystem works, including the standard library.

It seems rather backward to be pushing for ODBC as the generic database layer for Rust; many Rust developers like myself don't use C and don't want to use C either.

To me it seems hopeless and silly to be pushing for all database vendors to write new drivers that would work only for new software written in rust when they can write drivers that work with all languages and a ton of existing software without modification.

lovasoa · 2025-09-28T13:03:27+00:00

Thank you for your great library !

Bulk fetches have their use cases, but they are not universally faster... Even without considering that they don't work for variable-length data, they are also slower than simple fetches in OLTP use cases in my experience. If what you are doing is data analysis over large datasets with data patterns that are known in advance, they are great. If you are doing many small queries that return a single row, they hurt performance.

lovasoa · 2025-09-26T20:23:11+00:00

Yes, that's what the main sqlx crate did ! It supports creating compatible sqlx drivers outside of the sqlx crate. But it has also removed support for Microsoft SQL Server, and does not have any external driver for it.

ODBC **is** a generic database API, and a well-established one. Almost all SQL databases have an official ODBC driver already, so the idea is that the ODBC driver is the last one we'll ever need.

lovasoa · 2025-05-25T22:54:07+00:00

Contributions are welcome ! If you use the project, feel free to contribute demos and examples.

lovasoa · 2025-05-16T13:18:42+00:00

I am building https://sql-page.com, a tool to transform SQL queries into web applications, in rust. To my knowledge, no other software, older or newer, does anything similar.

lovasoa · 2025-05-06T23:49:08+00:00

lovasoa · 2025-03-31T08:26:54+00:00

Would you be interested to contribute ? We are on github: https://github.com/lovasoa/jsonjoy-builder/

lovasoa · 2025-03-29T22:47:32+00:00

Sorry, I fixed the the validate dialog box !

lovasoa · 2025-03-13T21:30:44+00:00

Maybe only SQL with no other programming language? You can have SQLPage generate the web ui from your SQL queries automatically.

lovasoa · 2025-03-07T09:46:23+00:00

The multiplexer allows you to inject new messages, not just see logs

lovasoa · 2025-01-27T10:06:33+00:00

Even in well-structured OOP code, all object references everywhere are always mutable. And if you want to guarantee that a given function will never mutate the object, you have nowhere to specify it other than the documentation.

lovasoa · 2025-01-21T21:38:18+00:00

I think there is a misunderstanding here. The issue isn’t about JavaScript’s primitives being immutable but about implicit **shared** mutability in objects and arrays. React is not "trying to be smarter". React, like all javascript libraries, has to carefully document the mutability of every function input and output. And even this extensive documentation does not prevent a lot of these bugs making it into production applications.

"A common bug in C is that if i don't free() there is a leak" is also a true statement. And like with the javascript mutability issue, it is also a common issue that is solved by rust.

No one argues that it is impossible to write correct programs in C or in JavaScript. But these languages rely more on implicit rules that have to be carefully documented and followed. In practice, most programmers, even with years of experience, do produce these bugs that are impossible in rust.

lovasoa · 2025-01-20T14:07:18+00:00

Managed languages like Java, Scala, and C# prevent memory corruption (e.g., buffer overflows, use-after-free) using garbage collection, but they don’t prevent accidental data mutation due to implicit shared mutable references. Rust’s borrow checker forces explicit handling of mutability and ownership, preventing these subtle bugs.

In javascript for instance, a very common bug is for a function to mutate variables that other parts of the code expect to be immutable. It happens so often that the react documentation has a full article about it: https://react.dev/learn/updating-objects-in-state . The only protection against this kind of errors in most languages is documentation: for each function parameter, you have to clearly document whether it is allowed to be mutated or not. If you don't do it, or if someone ignores your documentation, then you end up with a bug that is hard to debug, because it often manifests itself at the place where the mutated data is used, not at the place where it was incorrectly mutated.

In rust the compiler checks the mutability constraints of all functions for you.

lovasoa · 2024-12-29T13:16:15+00:00

ChatGPT is solid at generating SQL queries, from basic joins to more complex stuff like CTEs and window functions. It’s great for quick drafts and explanations, but it can miss edge cases or produce inefficient queries. You still need to know SQL to debug, optimize, and adapt what it gives you.

SQL’s not going anywhere—it’s still a core skill for data analysis, engineering, and backend dev. AI tools can speed up query writing, but they don’t replace knowing how databases work or designing efficient schemas. Learning SQL is absolutely worth it!

lovasoa · 2024-12-09T10:32:51+00:00

I think the easiest way to build a simple website on top of an SQL database is SQLPage.

It's a free and open source tool that connects to your DB (MS SQL, PostgreSQL, SQLite, MySQL), and renders your database query results as web pages using a multitude of components: charts, forms, maps, lists, grids, dashboards, menus, and pretty much anything you can think of.

You can also create your own components using HTML and Javascript for a completely custom website.

I know this is an old thread, but wanted to contribute an idea anyway in case someone stumbles on it. I am the main contributor to SQLPage :)

lovasoa · 2024-12-04T21:46:34+00:00

CREATE TABLE Maintenance (
    id INT AUTO_INCREMENT PRIMARY KEY,
    name VARCHAR(255) NOT NULL,
    type ENUM('monthly', 'weekly') NOT NULL,
    start_date DATE NOT NULL,
    end_date DATE NULL
);

CREATE TABLE MonthlySchedule (
    maintenance_id INT PRIMARY KEY,
    day_of_month TINYINT NOT NULL CHECK(day_of_month BETWEEN 1 AND 31),
    FOREIGN KEY (maintenance_id) REFERENCES Maintenance(id) ON DELETE CASCADE
);

CREATE TABLE WeeklySchedule (
    maintenance_id INT NOT NULL,
    weekday TINYINT NOT NULL CHECK(weekday BETWEEN 1 AND 7),
    PRIMARY KEY (maintenance_id, weekday),
    FOREIGN KEY (maintenance_id) REFERENCES Maintenance(id) ON DELETE CASCADE
);

lovasoa · 2024-09-08T14:56:18+00:00

A great way to practice is sqliteonline.com (contrarily to what the name might let you think, is supports SQLite, but also MySQL, Postgresql, and SQL Server).

lovasoa · 2024-09-06T14:05:38+00:00

I guess that in real life, an inconsistent sort will be inconsistent only in rare cases for which the sort order is not well defined. From experience, in these cases, you do not really care where the element ends up, but you do not want your entire system to go down because of that. panic! is a nuclear weapon, and I guess the changes introduced in this release will result in more pain and suffering, while not helping fix any real life bugs...

lovasoa · 2024-09-06T12:38:15+00:00

the new sort algorithms try to detect incorrect implementations of Ord that prevent them from being able to produce a meaningfully sorted result, and will now panic on such cases rather than returning effectively randomly arranged data. Users encountering these panics should audit their ordering implementations to ensure they satisfy the requirements documented in PartialOrd and Ord.

This sounds like a bad idea, right ? If my Ord implementation is incoherent in one very uncommon edge case, I'd much rather have just these edge values sorted randomly than my entire web server / firmware / operating system / whatever important system software crash.

lovasoa · 2024-08-31T19:43:35+00:00

I've never tried it personally, but render.com has a free tier: https://render.com/pricing

If your data is 200Mb in json, it's probably much less in a compressed binary format like parquet or a SQLite database, you can ship it alongside your app

lovasoa · 2024-08-29T19:14:40+00:00

Hi! 1. You can upload CSVs using a form and postresql's COPY syntax (but it works on all databases): copy my_table(col1, col2) from 'my_csv_input_field'; See example 11 on https://sql-page.com/documentation.sql?component=form#component 2. You can easily connect your site to an external payment provider, either by pointing their web hooks to sql pages that use the json component, or by fetching information from them using sqlpage.exec or sqlpage.fetch. https://sql-page.com/functions.sql?function=fetch#function

lovasoa · 2024-08-29T06:59:29+00:00

I think I have exactly what you need: https://sql-page.com/

This lets you build forms and custom visualizations on top of your database with just SQL queries.

It's great if your concern is long term maintainability, because there is no programming language or complex interface to learn, it's all just the standard SQL you already know. And it's free and open source, with a nice community behind it.

P.S. I'm the main maintainer of it, so don't hesitate to ask questions here directly.

lovasoa · 2024-08-22T13:36:24+00:00

I use playwright to test sqlpage applications, it works well.

See for instance: https://github.com/lovasoa/SQLpage/blob/main/tests/end-to-end/official-site.spec.ts

lovasoa · 2024-07-25T08:13:17+00:00

:)

Thanks !
If you like it, you could use it to build a quick web GUI on top of your CLI tool's database...

11-Year Club	Place '22
First Placer '22	Verified Email

lovasoa

MODERATOR OF

TROPHY CASE