Understand Group by in Django with SQL.

Aggregation is a source of confusion in any type of ORM and Django is no different. The documentation provides a variety of examples and cheat-sheets that demonstrate how to group and aggregate data using the ORM, but author of this article decided to approach this from a different angle.

#python #django #sql #orm #groupby #aggregation

SQLFluff is a dialect-flexible and configurable SQL linter. Designed with ELT applications in mind, SQLFluff also works with jinja templating and dbt. SQLFluff will auto-fix most linting errors, allowing you to focus your time on what matters.

#python #sql #linter #formatter

Apexcharts.js is a modern JavaScript charting library to build interactive charts and visualizations with simple API.

#javascript #js #charts #visualization #svg

Please, hold my cat until I learning Clojure.

Well, I'm done, give it back.

Ciphey is a fully automated decryption/decoding/cracking tool using natural language processing & artificial intelligence, along with some common sense.

#python #cryptography #cipher #cpp #hacking #artificial #intelligence #pentesting #ctf #hashes #encodings

GTD in 15 minutes – A Pragmatic Guide to Getting Things Done.

GTD — or “Getting things done” — is a framework for organizing and tracking your tasks and projects. Its aim is a bit higher than just “getting things done”, though. (It should have been called “Getting things done in a much better way than just letting things happen, which often turns out not to be very cool at all”.) Its aim is to make you have 100% trust in a system for collecting tasks, ideas, and projects — both vague things like “invent greatest thing ever” and concrete things like “call Ada 25 August to discuss conference schedule”. Everything!

#getting #things #done #gtd #organizing #tracking #tasks #projects

Hora is an approximate nearest neighbor search algorithm (wiki) library.

#rust #search #engine #ml

Semgrep is a fast, open-source, static analysis tool for finding bugs and enforcing code standards at editor, commit, and CI time.

Semgrep analyzes code locally on your computer or in your build environment: code is never uploaded.

#ocaml #static #analysis #javascript #python #ruby #c #go #typescript

SQLModel is a library for interacting with SQL databases from Python code, with Python objects. It is designed to be intuitive, easy to use, highly compatible, and robust.

#python #fastapi #sqlalchemy #pydantic

I know I shouldn't have done this, but this repository has a great meme potential.

An Opinionated Guide to xargs.

xargs is a command on Unix and most Unix-like operating systems used to build and execute commands from standard input. It converts input from standard input into arguments to a command. Some commands such as grep and awk can take input either as command-line arguments or from the standard input

This post has everything you need to know about xargs, an essential tool for shell programming.

#article #xargs #unix #nix #linux #shell #bash #programming