Register a SA Forums Account here!
JOINING THE SA FORUMS WILL REMOVE THIS BIG AD, THE ANNOYING UNDERLINED ADS, AND STUPID INTERSTITIAL ADS!!!

You can: log in, read the tech support FAQ, or request your lost password. This dumb message (and those ads) will appear on every screen until you register! Get rid of this crap by registering your own SA Forums Account and joining roughly 150,000 Goons, for the one-time price of $9.95! We charge money because it costs us money per month for bills, and since we don't believe in showing ads to our users, we try to make the money back through forum registrations.
 
  • Post
  • Reply
Only Kindness
Oct 12, 2016
Maybe so, Pen-pen, but Starmer isn't Prime Minister!

Hup! tax

Adbot
ADBOT LOVES YOU

sebzilla
Mar 17, 2009

Kid's blasting everything in sight with that new-fangled musket.


"I can assure the House that the Prime Minister is not hiding under a desk" is a hell of a quote.

Only Kindness
Oct 12, 2016

sebzilla posted:

"I can assure the House that the Prime Minister is not hiding under a desk" is a hell of a quote.

No, she's hiding behind Mommy Mordaunt's skirts.

Bonusse Catte Giffe

The Question IRL
Jun 8, 2013

Only two contestants left! Here is Doom's chance for revenge...

In other news, tiny little story here.

One of such a fringe interest, it's no wonder that no British Publication (The BBC, The Independent, The Guardian, The Torygraph etc....) were running with it.

https://www.rte.ie/news/2022/1016/1329499-abuse/

Dead Goon
Dec 13, 2002

No Obvious Flaws



Unimaginative Question.

Unfortunate Question.

Utilitarian Question.

Unqualified Question.

Guavanaut
Nov 27, 2009

Looking At Them Tittys
1969 - 1998



Toilet Rascal

The Question IRL posted:

In other news, tiny little story here.
It's hardly like they can bring him in for questioning.

Tesseraction
Apr 5, 2009

The Question IRL posted:

In other news, tiny little story here.

One of such a fringe interest, it's no wonder that no British Publication (The BBC, The Independent, The Guardian, The Torygraph etc....) were running with it.

https://www.rte.ie/news/2022/1016/1329499-abuse/

Ah so that's why he's trending on Twitter lol

cat botherer
Jan 6, 2022

I am interested in most phases of data processing.
In retrospect, Britain using a family of inbred nonces as a symbol of national pride and unity maybe wasn't the best option.

You should just gently caress your flag like we do in the US.

Oh dear me
Aug 14, 2012

I have burned numerous saucepans, sometimes right through the metal

Trin Tragula posted:

Gee, it's almost as though all stampeding out of the party in a snit at losing one leadership election might make it harder to support good candidates in future

It's not one leadership election, it's all leadership elections in the foreseeable future, since they've rigged the candidate selection for that as well.

keep punching joe
Jan 22, 2006

Die Satan!
https://twitter.com/CatNeilan/status/1582029265973182464?t=tay6n_um1gB2insfcWbGvA

Lmao

Failed Imagineer
Sep 22, 2018

cat botherer posted:


You should just gently caress your flag like we do in the US.

Turns out you can gently caress the flag, the Royal family, a nonagenarian Army veteran, and the concept of poppies all at the same time

Aipsh
Feb 17, 2006


GLUPP SHITTO FAN CLUB PRESIDENT
TRUSS IN DA HOOSE

keep punching joe
Jan 22, 2006

Die Satan!

Aipsh posted:

TRUSS IN DA HOOSE

Humiliation fetish confirmed

Jeherrin
Jun 7, 2012

The Question IRL posted:

In other news, tiny little story here.

One of such a fringe interest, it's no wonder that no British Publication (The BBC, The Independent, The Guardian, The Torygraph etc....) were running with it.

https://www.rte.ie/news/2022/1016/1329499-abuse/

The Times is running it.

Tigey
Apr 6, 2015

That 'hiding/cowering under the desk' quote from Mordaunt feels like it was absolutely deliberate.

Unless some bigger news is coming later today, I suspect it will be picked up more widely across the media/commentators/papers. One more humiliation for loser Truss.

forkboy84
Jun 13, 2012

Corgis love bread. And Puro


Trin Tragula posted:

Gee, it's almost as though all stampeding out of the party in a snit at losing one leadership election might make it harder to support good candidates in future

Sure, that's one way to look at it, if you hang upside down like a bat and squint your eyes while staring at a bizarre arrangement of mirrors.

Alternatively you can look at it normally and observe that this is exactly why leaving the Labour Party is required, it has no place for socialists anymore and staying because you can't see that (if you're to the left of Angela Rayner) there's absolutely no point giving money to it that might keep it alive, sucking up support that could easily go to a party that isn't neoliberal in economic character & reactionary on civil liberties.

Labour is a trap.

Rarity
Oct 21, 2010

~*4 LIFE*~

Tigey posted:

One more humiliation for loser Truss.

Keep going she's almost there

ukle
Nov 28, 2005
https://twitter.com/RedfieldWilton/status/1582038729694191616?s=20&t=c81Xe68322yE6kBsVS5k6w

Can Keith break 60%, good possibility if Truss clings to 'power'.

Bobby Deluxe
May 9, 2004

While they're in opposition they are mildly beholden to the unions and members if they want to stay afloat, but I guess if they actually got in power they could sever that link the instant they got access to the public purse.

They'd be hosed as soon as they left power but that's not the point; the point is to get in power and then move on to cushy consultancy positions in whatever industries they ratfuck for private capital. The wholesale destruction of the Labour party is just a side benefit.

BougieBitch
Oct 2, 2013

Basic as hell
Not a UK poster normally, but the "how do we pay for it" seems like an incredibly easy proposition - propose the plan along with the taxes that fund it. Either raise the rate in the highest bracket of income, introduce a tax on luxury items (like, say, private medical care), or add a wealth or inheritance tax. There are plenty of taxes you can propose that make these policies redistributive, it really isn't a huge ask

William Bear
Oct 26, 2012

"That's what they all say!"

Tigey posted:

That 'hiding/cowering under the desk' quote from Mordaunt feels like it was absolutely deliberate.

Unless some bigger news is coming later today, I suspect it will be picked up more widely across the media/commentators/papers. One more humiliation for loser Truss.

In a way, we finally found out what it would be like if Jeb Bush was president of the United States.

keep punching joe
Jan 22, 2006

Die Satan!
Keith has played a blinder with his strategy of say and do absolutely nothing (except to deep throat the flag whenever possible), and wait for a succession of increasingly incompetent governments to just own themselves repeatedly. Much respect to the hard drinking lad.

Tarnop
Nov 25, 2013

Pull me out

BougieBitch posted:

Not a UK poster normally, but the "how do we pay for it" seems like an incredibly easy proposition - propose the plan along with the taxes that fund it. Either raise the rate in the highest bracket of income, introduce a tax on luxury items (like, say, private medical care), or add a wealth or inheritance tax. There are plenty of taxes you can propose that make these policies redistributive, it really isn't a huge ask

Let me tell you about the only thing other than racism that motivates a minimum of 30% of voters

keep punching joe
Jan 22, 2006

Die Satan!
Liz Truss in the commons looks like someone's spiked her. Like she genuinely looks like she's not well.

peanut-
Feb 17, 2004
Fun Shoe
Turns out restoring economic credibility is gonna mean doing even bigger austerity than Kwasi was going to

https://twitter.com/HugoGye/status/1582040163202772992?s=20&t=pz_FbbvfSoMd41cAWbsETg

Laughing Zealot
Oct 10, 2012


Not from the UK but hasn't the country been in austerity mode for more than a decade at this point?

Tarnop
Nov 25, 2013

Pull me out

Laughing Zealot posted:

Not from the UK but hasn't the country been in austerity mode for more than a decade at this point?

Yes. Boris pretended it was over for a bit but predictably most of the promised spending (40 hospitals) was lies or reannouncing budget allocation from years ago

Rarity
Oct 21, 2010

~*4 LIFE*~
Austerity has ended in the UK at least 4 times

Maugrim
Feb 16, 2011

I eat your face
:siren: UKMT Solidarity Fund "Monthly" Report, September 2022 :siren:

First off, I didn't post updates for July OR August - mea culpa, life was kicking my arse and once I'd missed one month it was all too easy to let another slip by. I might not even be posting now if I hadn't had a boot up the arse, specifically from this QCS thread regarding a CSPAM/US-based hardship fund run on significantly less... accountable lines than we have tried to maintain. Since we're suddenly being held up as a good example, it seemed like I'd better ensure the records are up to date.

Where are we at? Doing better than I expected for this point in the year, actually. As you can see from the charts there hasn't been the huge uptick in requests we were expecting, although we have noted an increase in the proportion of requests relating to bills and the rising cost of living. Generous goons are still donating regularly and the total amount of money in the fund remains surprisingly stable.

As always, thank you so much to everyone who helps us keep this running with your generosity.

July Stats:


August Stats:


September Stats:


Monthly donations and payouts to date:


Cumulative donations and payouts to date:



UKMTSF Data Trends | Record of Activity | Constitution

If you are someone that is in need, please get in contact. This fund is here to help you with whatever comes your way. If something is causing you stress, pain, worry or physical distress, please get in contact with us. Please do not go hungry or without something because you are of the belief that your pain is not important enough. Feel free to contact any of the committee if you would like to discuss an issue. All matters are treated in complete confidence.

Donate:
Bank Transfer - PM IrvingWashington (aka Bill Drummond on Discord) for account details

Apply:
Application Form
Email Us
PM: AceClown, Fargle (discord only), Maugrim, The DPRK or Tsietisin.

Only Kindness
Oct 12, 2016

Tarnop
Nov 25, 2013

Pull me out


When the Self is threatened it can be comforting to return to familiar patterns of behaviour :chef:

Bobby Deluxe
May 9, 2004

jesus she does look like chucky

BalloonFish
Jun 30, 2013



Fun Shoe

BougieBitch posted:

Not a UK poster normally, but the "how do we pay for it" seems like an incredibly easy proposition - propose the plan along with the taxes that fund it. Either raise the rate in the highest bracket of income, introduce a tax on luxury items (like, say, private medical care), or add a wealth or inheritance tax. There are plenty of taxes you can propose that make these policies redistributive, it really isn't a huge ask

This would be a great idea if we had a remotely sensible, even-handed media and a vaguely inquisitive and independent journalist class.

But since we don't - in 2019 Labour published a whole second document alongside their manifesto, setting out in plain language and pretty pie charts exactly which taxes were going up to pay for what spending, what the total borrowing would be at predicted interest rates, how that debt would sit relative to expected growth, how nationalising assets would offset the costs of acquiring them etc. etc. etc.

Hardly anyone (in the media/journalist class, anyway) read or mentioned it and those that did just dismissed it because Labour can't be trusted and Gordon Brown Sold All The Gold. While the Conservatives just said they'd spend billions on bridges to Northern Ireland, tunnels under the Pennines, a spaceport in Cornwall, dozens of new hospitals, a new fleet of naval frigates, RAF Space Command etc. etc. plus all the sunlit uplands of Brexit and were never once asked to show their workings.

It's a rigged game and Labour are always fools when they try and play it.

EvilHawk
Sep 15, 2009

LIVARPOOL!

Klopp's 13pts clear thanks to video ref

So Mordunt was sent up to front for the PM (who totally wasn't hiding and was doing something Super Serious), Truss showed up for 5 minutes, and has now hosed off again

Totally normal country

fuctifino
Jun 11, 2001

https://twitter.com/coldwarsteve/status/1582041020505632768
https://twitter.com/IamHappyToast/status/1582028687465058309

fuctifino fucked around with this message at 18:17 on Oct 17, 2022

WhatEvil
Jun 6, 2004

Can't get no luck.

Skip this post if you don't care about databases - but it should help understand what a database is and how it's different to a spreadsheet.

justcola posted:

What is a database exactly? When I've put together some awful spreadsheet in Excel that is used as a CRM database across multiple pages and tens of thousands of rows tracking 20+ types of data, I do wonder if there would be a better way of organising it, a sort of multi-dimensional spreadsheet that doesn't alter the way the data is laid out by making queries or organising it. Maybe this is what Access is for idk

So I don't think anybody really answered this? There were a few joke answers.

It sounds like you have it sort of right re: "a sort of multi-dimensional spreadsheet" but there's a bit more to it than that.

The easiest way to think about it is that in a spreadsheet, you infer relationships between atomic pieces of data based on their positional relationships within the sheet - so you may have a row of the sheet for a customer's details and in cell 1 you have their name, cell 2 you have their address, cell 3 is phone number, etc. and maybe somewhere you have formulas where cells reference other cells to bring data together, or you use pivot tables etc.

That data isn't actually "related" in the sense that excel doesn't understand or enforce the relation between the two. It's literally a human looking at it and saying "that piece of data is next to that piece of data, therefore that phone number belongs to that owner" (so the phone number belongs to that customer).

In databases, the data is still stored in tables, but you set it up so that each atomic piece of data is a record, with a unique record ID, and usually another field which tells the database what master record that piece of data belongs/relates to.

So your "master" record in a CRM system would typically be a Customer , so you'd have a Customers table, holding records with a CustomerID, along with some data fields like probably Name or FirstName and LastName, and then you'd either have a field for phone number if you only want to have one phone number per customer, OR you'd have a separate table called PhoneNumbers or something, where you'd have PhoneNumber records, with PhoneNumberID, PhoneNumber, CustomerID... and this would allow you to have multiple phone numbers per customer. So it might be set up like this:

code:
Table Customers:

CustomerID: 1145	CustomerName: Liz Truss		Address: 10 Downing Street	AccountType: Premium
CustomerID: 8376	CustomerName: Jeremy Hunt	Address: 11 Downing Street	AccountType: Basic

Table Phones:

PhoneID: 7746	CustomerID: 1145 	PhoneNo: 0181 811 8181		PhoneType: Main
PhoneID: 8827	CustomerID: 1145	PhoneNo: 07777 666777		PhoneType: Secondary
PhoneID: 5378	CustomerID: 1145	PhoneNo: 07123 456789		PhoneType: Secondary
PhoneID: 8127	CustomerID: 8376	PhoneNo: 0118 999		PhoneType: Main
So the first three phone records belong to customer ID 1145: Liz Truss, and the last one belongs to customer ID 8376, Jeremy Hunt. The IDs for each record are usually automatically assigned and tracked by the database.

If you wanted to do this in a spreadsheet you'd typically have a row for each customer, then "PhoneNumberMain" "PhoneNumber2" "PhoneNumber3".... but then what if you set it up like this and you have a customer who has 4 phone numbers, for example? A database can handle this no problem because you have what's called a "one-to-many" relationship here, so if you get another phone number for Liz Truss, you just add another record in the Phone table with CustomerID 1145. In Excel you'd need to change your whole sheet and add in a new column which might mess up your printing setup etc.
The database understands (and enforces) the relationships between data, and then you can pull out just the data you want at any time.

When you want to view the data you create a report by using a Query like this (note the SQL here may not be exact because I haven't used it in ages but the general principle is what's important):

code:
SELECT CustomerName FROM Customers
would give you a simple list of all the customer names from the Customers table.

code:
SELECT * From Customers
would give you a printout of all of the columns from the Customers table.

code:
SELECT CustomerName, CustomerAddress FROM Customers WHERE AccountType='Premium'
would give you a list of the customer names and addresses for only customers who have a "Premium" account. "WHERE" filters results.

SELECT CustomerName FROM Customers UNION SELECT PhoneNo, PhoneType FROM Phones would "union" the selected results from the two tables to show you all of the customer names from the Customers table and list all of their phone numbers associated with each one. I got this wrong because I haven't used SQL for about 8 years!

You'd use a JOIN to do this as Sebzilla pointed out.

Something like
code:
SELECT Customers.CustomerName, Customers.CustomerAddress, Phones.PhoneNo FROM Customers INNER JOIN Phones ON Customers.CustomerID=Phones.CustomerID
though that may still be wrong. What it's doing here is saying "select these fields from these different tables, where they have records that match up on CustomerIDs".

The point is, you can build more complicated queries that do smart things like bringing in data together from multiple tables in smart ways; summarising it; summing, averaging and aggregating numerical data similarly to how you can in Excel but in a much more powerful way, and lots of other things.

And you can set up queries like this and save them as "Reports" so once you've "built" the query, you save it and just click on your saved report and it updates the report to give you an up-to-date snapshot of the data which you can view or print, reflecting any updates, new customers, etc.

If you want to start recording some new kind of data about your customers, then no problem, you can just create a new field in one of your existing tables or create a new table. Each piece of data is only stored once, in one place, meaning that when it's updated, the update propagates through everything. The database software enforces the correct entry of data, the relationships between data, and can also do stuff like store a complete edit history.

The trade off is that designing the database, defining the relationships, designing the entry forms and data validation is more work, but typically then it's easier to get certain kinds of data out of it, plus it's much better for multi-user usage. Also you have stuff like I illustrated where any given Customer can have anywhere from zero to a billion phone numbers without it causing any issues for your data storage or formatting.

Of course if you're running a business selling stuff then this kind of structure allows you to very easily create Orders for Customers, each of which has one or more Products, with which you might associate a Shipment with a tracking ID and all of those pieces of data belong and relate to one another etc, which again, you can't easily do with Excel, because of the "One-to-many" relationship of data. A customer may end up with many orders, an order may contain many products, etc. and that's difficult to represent in a spreadsheet.

To help visualise what the relationships are like, here's a simple example:



But with something "Real-world" you might end up with something more like this:


(I made this - it was an ERP database for where I used to work, but we didn't end up using it for a number of reasons).


There's a lot more to it that I haven't gotten into here (like many-to-many relationships, where e.g. a book may have many authors but an author may have written many books, which is also possible to model in a DB and basically impossible in a spreadsheet) but that's the gist of it. It's a relational database because the structure is all about the relation of one piece of data to another piece of data, and that allows you to do cool things that aren't really possible with spreadsheets, because the relations within spreadsheets are only ever defined in terms to their relative positions on the sheet.

The SQL stuff is actually quite easy to learn. This website is excellent: https://www.w3schools.com/sql/sql_union.asp

WhatEvil fucked around with this message at 20:28 on Oct 17, 2022

sebzilla
Mar 17, 2009

Kid's blasting everything in sight with that new-fangled musket.


Small point of order in that you'd probably want a JOIN rather than a UNION to connect your phone numbers to your Customers (union just drops one table's rows after the other in your results, join allows you to specify which criteria to match up (in this case the Customer ID) and also what to do about records that don't match up etc.)

Otherwise a very nice write-up WhatEvil

Apraxin
Feb 22, 2006

General-Admiral
yikes
https://twitter.com/SuellaBraverman/status/1581618197585100800

Jedit
Dec 10, 2011

Proudly supporting vanilla legends 1994-2014

sebzilla posted:

Small point of order in that you'd probably want a JOIN rather than a UNION to connect your phone numbers to your Customers (union just drops one table's rows after the other in your results, join allows you to specify which criteria to match up (in this case the Customer ID) and also what to do about records that don't match up etc.)

Otherwise a very nice write-up WhatEvil

If you expect people round here to pick something over a UNION then you've set yourself a hard row to hoe.

Adbot
ADBOT LOVES YOU

Dabir
Nov 10, 2012

In practical day to day terms the main advantage of a database over a spreadsheet is that you can make changes to small bits of it and not cause problems. A spreadsheet is just a file, even if you keep it on a shared drive it won't like two people working on it at once. The best case scenario is that whoever saves the file second overwrites all changes made by the first person, the worst case scenario is the waking nightmare Jaeluni mentioned. Spreadsheet are a data ANALYSIS tool, not a STORAGE tool.

  • 1
  • 2
  • 3
  • 4
  • 5
  • Post
  • Reply