Recent searches

No recent searches

Search options

Not available on lingo.lol.
lingo.lol is one of the many independent Mastodon servers you can use to participate in the fediverse.
A place for linguists, philologists, and other lovers of languages.

Administered by:

Server stats:

66
active users

lingo.lol: AboutProfiles directoryPrivacy policy

Mastodon: AboutGet the appKeyboard shortcutsView source codev4.4.1

#SQL

3 posts3 participants0 posts today
Oliver Kohll

Pleased to have had the opportunity to use my brain on a programming (#SQL) task.

It was a bit like working out compound interest, when the interest rate changes every year. The task was:

In a manufacturing process, there are various losses of material at each step. Each input component has a cost per kg, so when the mass of the final output is less, the cost per kg of items produced goes up (using costs from the original materials).

Now each processing step has a known loss (e.g. 5% for one step, 6% for the next). The loss acts on what's left from the step before, so is compound.

We want a report of the amount of money lost at each step of the way, with a final total at the end.

The solution involved creating a new #Postgresql operator to do a cumulative multiplication (Postgres can do cumulative sums but not multiplications out of the box) and Window functions, so made my day 🙂

Glad to have the help of colleagues as well.

Calishat

#SQL #databases #LEGO

'This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts.'

eric.ed.gov/?id=EJ1468081

eric.ed.govERIC - EJ1468081 - Using LEGO® Brick Data to Teach SQL and Relational Database Concepts, Information Systems Education Journal, 2025This paper introduces the LEGO® Database, a large natural dataset that can be used to teach Structured Query Language (SQL) and relational database concepts. This dataset is well-suited for introductory and advanced database assignments and end-of-semester group projects. The data is freely available from Kaggle.com and contains eight tables with 633,250 rows of data on 11,673 LEGO® sets sold between 1950 and 2017. As a guiding example, I introduce an example group project assignment designed to provide students hands-on experience with database management and SQL queries. I also discuss tips, suggestions, and lessons learned from using the data for group projects over the past five years. While LEGO® bricks have been widely used in educational settings, including college and computer classrooms, this is the first work to discuss the use of LEGO® data in a college database course.
*
Albert Cardona

Two open positions in my lab to develop scientific software with python and javascript.

Software: CATMAID

Documentation:
catmaid.readthedocs.io/en/stab

Source code:
github.com/catmaid/CATMAID/

Example:
l1em.catmaid.virtualflybrain.o

If you have experience with #SQL (#postgresql), #python and its many libraries (particularly #django), #rust, and #javascript, write to me and let's discuss.

Examples of open issues: github.com/catmaid/CATMAID/iss

catmaid.readthedocs.ioWelcome to CATMAID — CATMAID 2021.12.21 documentationThe Collaborative Annotation Toolkit for Massive Amounts of Image Data. Used for image viewing, neuron reconstruction, ontology based annotations and more.
Boyd Stephen Smith Jr.

I want to be your next #FediHire ! I've been a programmer since 1985 (as a child), I've been an IT professional since 1995 (pulling wires and swapping cards and configuring MS Windows). I graduated from University of Arkansas Fayetteville with a BS in CS in December of 2003. A full resume is available.

I currently require a 100% remote position. I cannot relocate from Cove, #Arkansas. I would prefer W-2 employment with a base salary of at least 130k USD/yr, plus some sort of retirement offering (401k or similar) and healthcare benefits (HDCP + HSA or similar).

I prefer something where I can be a high-performing individual contributor: reading, writing and improving source text the majority of my day, with some time spent knowledge-sharing with other developers -- learning and teaching. I'd like to work with #Haskell, #Purescript, or #Idris as the primary source language. I've previously delivered value in Haskell, #Javascript, #SQL, #Python, #Scala, #Java, #C, and #C++ among others. I can be productive in almost any language (no PHP, please; I promised myself never again).

*
⚯ Michel de Cryptadamus ⚯

pro tip for user interface designers:

if you have hundreds of millions of dollars of venture capital and you want to make a user facing data analytics tool of some kind and you think it's reasonable to ask an average human being to type this:

CAST('2023-05-01' AS TIMESTAMP)

to do literally anything with a date or time in your application's user interface, just stop right there. do not pass go, do not collect $200, and do not ever attempt to offer feedback to a UX designer ever again. something is deeply broken inside you that means there are certain mysteries of the universe that even the guys who designed the postgres command line can access that you will never know, and that's ok. You can still live a really rad life.

#SQL#dba#dataengineering
Rami Krispin :unverified:

The new PostgreSQL extension for VScode is amazing! 🚀

The VSCode team recently released a new extension for working with Postgres, and its features are mind-blowing. This includes the following features:
🔹 Support both connections to local and cloud-based Postgres databases
🔹 Schema visualizations ❤️
🔹 Copilot SQL agent
🔹 Docker supports 🐳
🔹 SQL editor

More details on the extension documentation: marketplace.visualstudio.com/i

#Data#DataScience#SQL
TrendingLive feeds
About