Link Issues by Keyword of Commit Message

date: 2024-02-14 · Tags: #dev, #git

I just knew that you can link a pull request to an issue by using a supported keyword in the pull request's description or in a commit message on GitHub.

  • close
  • closes
  • closed
  • fix
  • fixes
  • fixed
  • resolve
  • resolves
  • resolved

For example, a commit message with the text Fix #32 would close issue 32 automatically.

If you use a keyword to reference a pull request comment in another pull request, the pull requests will be linked. Merging the referencing pull request also closes the referenced pull request.

The syntax for closing keywords depends on whether the issue is in the same repository as the pull request.

Refs:

Multi-Database Support in DuckDB

date: 2024-02-12 · Tags: #news, #database

TL,DR: DuckDB can attach MySQL, Postgres, and SQLite databases in addition to databases stored in its own format. This allows data to be read into DuckDB and moved between these systems in a convenient manner.

Using the SQLite extension, we can open a SQLite database file and query it as we would query a DuckDB database.

ATTACH 'sakila.db' AS sakila (TYPE sqlite);
SELECT title, release_year, length FROM sakila.film LIMIT 5;

This is insane!

ATTACH 'sqlite:sakila.db' AS sqlite;
ATTACH 'postgres:dbname=postgresscanner' AS postgres;
ATTACH 'mysql:user=root database=mysqlscanner' AS mysql;

In modern data analysis, data definitely is combined from a wide variety of different sources. What a game changer feature.

Ref:

Tenets (of Svelte)

date: 2024-02-10 · Tags: #svelte, #dev, #insight

Svelte was born with serveral brazing new and interesting ideas for web development. Nowadays, it has been a mature framework with a quite strong community and a lot of resources. I'm aslo a big fan and lover of Svelte.

Last month, the founder of Svelte (@Rich-Harris) has published a blog post1 (? dicussion actually) about the tenets (of Svelte), which is an attempt to articulate the Svelte philosophy — their bedrock principles, that guide our design decisions.

It's unexpectedly pleasant to read and I understand why I'm in favor of Svelte, which I wholeheartedly endorse most of points.

The tenets are still strongly recommended to you, even if you are not a Svelte user.

Footnotes

  1. sveltejs/svelte - Announcements: Tenets #10085 ↩

<
Prev
2024-01
Next
2024-03
>