Skip to main content

Does anybody know where to learn database programming? I have a thing at work that would work so well with a database but I don't know where to begin learning the mental model or interface.

Do you mean using a database? Writing a database? What kind of database? What kind of programming have you done before?

Using, writing, querying a database. Right now all the data is in a big Excel spreadsheet with tables and VBasic functions to query the data.


Basically, I work in a library. I build a list every month for the books we check out to local preschools. I have a table with all the books we have in our collection, and I have another table with all the checkouts I've done over time. Each month I generate a report that figures out what books we're going to check out next month, which is based on what books were previously checked out (I don't want to check the same book out two months in a row, for example).


I've thought since making this big Excel sheet that it seems like a good application for a database, but I don't know for sure.

I'd consider myself a "hobbyist-level" programmer. I know what control flows and variables and all that are, but I don't get pointers yet. I've used python, bash, haskell, javascript, lua, etc., but mostly just to write little scripts.
I hope that answers your questions! Sorry for the wall of text. It's a complex problem I'm facing.


Here's what I'd do:

I don't know what language(s) you know but for the sake of discussion, let's say Python.

There are many online tutorials for Django which include some ORM layer. Learn that.

Okay, so I'd use Django as the interface with the backend in the database? I think this is where my confusion lies. I'll try reading that tutorial.

I did half-heartedly try this with Flask before, but maybe if it's more batteries-not-included, I should start with a more comprehensive solution.

Django is a lot easier. I use flask for things more often, but for a newbie you want the batteries included.

Flask won't teach you a ton about what's going on behind the scenes, but for where you are, that's not as important.

To steal a phrase from


Former GE CEO Jeff Immelt: To Combat Costs, CEOs Should Run Health Care Like a Business

it took the 2008 global financial crisis for him to really scrutinize how much GE was spending on health care costs. It had grown 7% over more than two decades.
The dude who traveled with a spare plane so he wouldn't be inconvenienced by breakdowns---which was financed by selling his customers appliances that broke down, ahem---is butthurt that employer costs only experienced 2 years' worth of inflation in 2 decades?!


Part of me wants to staple EMPLOYEE cost explosions to his forehead... but, fuck it... let's just cut to the chase...

@Foryouwhynot IB - Yes, they are/were known for good car audio.

Too bad they couldn't get a deal being the OEM provider...they've made it near impossible to put your own stereo in modern vehicles...


Content warning: Hey...

Case Duckworth reshared this.

Hey everyone, I’m #newhere. I’m interested in #cnc, #irishflute, #music, #software, #tinwhistle, and #woodwind.

I make musical instruments and ship them all over the world. I am looking for an alternative to FB and I like the way that this works. Thought I would give it a try.

Trocatintas reshared this.

Welcome! Follow lots of #tags is my advice to you.


Published on 17 Jul 2019
"Englishman in New York"
"Don't Make Me Wait"
"Shape of My Heart/Lucid Dreams"

Sting: vocals, bass, guitar; Shaggy: vocals; Dominic Miller: guitar; Gene Noble: vocals; Melissa Musique: vocals

#Sting #Shaggy #NPR #music

If it's got a hip-hop element to it, I probably don't care to hear it.

Hey everyone, I’m #newhere. I’m interested in #cnc, #irishflute, #music, #software, #tinwhistle, and #woodwind.

I make musical instruments and ship them all over the world. I am looking for an alternative to FB and I like the way that this works. Thought I would give it a try.

A$AP Rocky - CALLDROPS ft. Kodak Black #np #FreeAsap

What is it with people... does people not respect due process any longer? Beating someone up is not legal. Especially if you are many beating up one guy. That is just cowardice.. and a bad roe-model.

maybe i'd listen to your sectarianism more if you didn't call the USSR an evil empire lol....epic to be a ronald reagan anarchist eh

Federation Bot reshared this.


#censorship and bans of #gab is wrong and dangerous

#F-droid, #google and many others are banning gab (a free software network allowing free speech) on the grounds of fighting hate speech and right-wing extremism. Many people on the left support this. Unfortunately what they help achieve by this is strengthening extremism.

I'll leave aside my usual arguments against censorship in general and rather only share this one:

By banning gab apps and telling people to avoid the network we weaken and almost eliminate any opposition to the right wing on that platform. We won't ever stop or eliminate the number of rightists using the platform, we're just collectively eliminating the numbe... show more

@Michael Rupp
A person whose actions relative to the observer are far outside the expectations of the observer.
So anyone who greatly surprises me, even in a nice way, is an asshole?

“You can lead a horse to water but you can’t make him drink.” That has a new addition to it, “But if you keep him around long enough he’ll get thirsty.”
This is nice, I have to note it somewhere :)


Peacock Flower (Moraea villosa)

... leave ya wid a #flower, wid #beauty.

Did you take your lunch break? Even if you don't feel like eating, take the time to recharge.

Friday's funny by from

All characters and events depicted in this comic are entirely fictitious. Any similarity to actual events or persons is purely coincidental. 😉


Jennifer Freeman reshared this.

Truth is always stranger than fiction.

That is next since they have found it was a planned & rehearsed thing.


Content warning: drogas

Content warning: drogas


Pablo Iglesias mueve ficha: renuncia a estar en el Gobierno a cambio de ministros de Podemos

Este viernes el líder de Podemos ha hecho una jugada importante en las
negociaciones con el PSOE. Da un paso atrás y acepta no integrar el
gobierno, pero insiste con poner dirigentes de Podemos en el gabinete de


Con la cuenta atrás en marcha, cuando la ruptura de negociaciones esta
semana hacía prever el fracaso de la sesión de investidura, Pablo
Iglesias da un paso atrás que algunos analistas califican de “jugada
maestra”. Su renuncia al pedido de integrarse en persona en el nuevo
ejecutivo quita de en medio la principal excusa que había puesto Pedro
Sánchez, que no quería al líder de Podemos en su gobierno.

El actual presidente de gobierno en func... show more

Here's how. Works slick on my Galaxy Watch.


I never got on the smartwatch band wagon. It looks like a novelty fad or a rather niche product.

Do you use a smartwatch? If so, what made you decide to use one?

I've had one for ages. I do mostly use it for health tracking but I'm surprised at how often I use it to answer my phone since I never know where it is. Also handy for notifications (text & Telegram) and payment. I restrict notifications a lot. Since I put my watch on ShawOpen (a Canadian service), I can use my watch without my phone when I go to the gym as they have ShawOpen there.

El presidente de #Bolivia@evoespueblo presentó su plan de trabajo y la lista de candidatos para las elecciones del 20 de octubre

El líder del partido MAS-IPSP mencionó que el programa fue debatido y consultado por diversos sectores de la población

Silencing people whose first interaction is antagonistic is therapeutic.

The research fairy reshared this.

Federation report: in the last hour, received 8969 toots from 502 instances and is connected to 7959 instances.

A psychogram of the Boris.
Does he believe any of his own claims, and do his followers in turn believe him? In both cases, the answer is yes, but only in the highly qualified way that an actor inhabits his role and an audience knowingly accepts the pretense. Johnson’s appeal lies precisely in the creation of a comic persona that evades the distinction between reality and performance.

The anthropologist Kate Fox, in her classic study Watching the English, suggested that a crucial rule of the national discourse is what she called The Importance of Not Being Earnest: “At the most basic level, an underlying rule in all English conversation is the proscription of ‘earnestness.’” Johnson has played on this to perfection—he knows that millions of his compatriots would rather go along with his outrageous fabrications than be accused of the ultimate sin of taking things too seriously.
And what about the comparisons to the Donald?
Trump sustains his base through the relentless repetition of the same slogans. He is bru
... show more


From the Team Sintti archives, February / helmikuu 2011...
◽Black & White in two sizes◽

#TeamSintti #animals #kissat #cats #kitten #Sintti
Team Sintti is a #gplusrefugee

Yet more Trump administration fuckery.

Trump officials pressing to slash refugee admissions to zero next year

"The Trump administration is considering a virtual shutdown of refugee admissions next year — cutting the number to nearly zero — according to three peopl
... show more


Britain Pirates Iranian Ship 'Grace 1' - Iran Responds - Takes British Tanker Hostage

#UK #Iran #politics #international #MoA

"On July the Brits used their colonial outlet #Gibraltar to steal the Iranian #tanker 'Grace 1' and its load of 2 million barrel of #oil. The Iranian Revolutionary Guard Corps then threatened to take similar measures against British ships. Today Gibraltar announce that it will hold the 'Grace 1' for another month. We can guess that those plans will soon change".

It seems that today, at about 16:00 UTC, the IRGC got lucky".



@Mudflap Nah, I just draws fire.

I have had to be on my best behavior in town. No more one-finger waves of 'good luck'.

One of the reasons I like looking like a giant Viking.

The smart ones don't mess with me.

The stupid ones don't last ling and their friends tend not to either.