• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EST 00:27
CET 06:27
KST 14:27
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
Team Liquid Map Contest #235[ASL22] Finals Preview: Sweet Victory!12[ASL22] Ro4 Preview: Mirror Mirror6[ASL22] Ro8 Preview: Within Reach5[ASL22] Ro8 Preview: In A Tizzy11
Community News
Weekly Cups (Nov 9-15): Clem and herO take over1Dark completes military service, returns to SC215[BSL23] RO16 Group Stage20Weekly Cups (Nov 2-8): herO back on top?2Weekly Cups (Oct 26 - Nov 1): MaxPax, herO, Solar win0
StarCraft 2
General
Team Liquid Map Contest #23 Dark completes military service, returns to SC2 Weekly Cups (Nov 9-15): Clem and herO take over StarCraft open world shooter announced at BlizzCon No more SC2 streamers on team liquid?
Tourneys
Sparkling Tuna Cup - Weekly Open Tournament RSL goes to London! 2026 Offline Finals Nov 21-22 Sea Duckling Open (Global, Bronze-Diamond) Dark returns! GSL CK #7 4v4 Team Battle (Nov 19) soO & FanTaSy return! SC2 Kevin Scrim 4v4 (Nov 16)
Strategy
[H] ZvP Mid-Late Game: Stalkers Collossi HT
Custom Maps
[G] How to playtest arcade maps Starcraft 2 Advance [D] the control group Simple Questions/Answers
External Content
Mutation # 552 Secret Storm The PondCast: SC2 News & Results Mutation # 551 Robotic Revival Mutation # 550 Graveyard Shift
Brood War
General
BW General Discussion List of top players active on ShieldBattery NaDa's Body Shield Battery Server New Patch BGH Auto Balance -> http://bghmmr.eu/
Tourneys
SC1 Kevin Scrim hosted by SOOP (Nov 18-19) [IPSL] Winter 26-27 Round of 16! [Megathread] Daily Proleagues 2v2v2v2 Tournament Stage 2: Players
Strategy
Pluto's TvP 5Marine 2Medic Push Simple Questions, Simple Answers Infested Terran strategies in 2026 Nuke strategy worked in K-League 2026-11-09
Other Games
General Games
Nintendo Switch Thread Stormgate/Frost Giant Megathread Free Space RTS Game, optimised f. Phone/Tablet etc List of Game Threads The PlayStation 5
Dota 2
League of Legends
[TL LoL EUW IHs] Teemo shall perish
Heroes of the Storm
Heroes of the Storm 2.0
Hearthstone
Deck construction bug
TL Mafia
TL Mafia Community Thread
Community
General
US Politics Mega-thread Trading/Investing Thread Artificial Intelligence Thread Russo-Ukrainian War Thread Things Aren’t Peaceful in Palestine
Fan Clubs
Fan Club Resource Thread Reynor Fan Club The Flash Fan Club
Media & Entertainment
Movie Discussion! Anime Discussion Thread [Manga] One Piece
Sports
Football (Soccer) Thread TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread
TL Community
The Automated Ban List Recent Gifted Posts
Blogs
The time I organised my…
AssyrianKing
Why I built Repalyzer (1.1.…
BlueStar
Innovate or Game Over?
TrAiDoS
ShieldBattery on Mac
Kraekkling
Can Bots Beat Pros?? Starcr…
namkraft
StarCraft improvement
iopq
Socialism Anyone?
GreenHorizons
Customize Sidebar...

Website Feedback

Closed Threads



Active: 11074 users

The Big Programming Thread - Page 977

Forum Index > General Forum
Post a Reply
Prev 1 975 976 977 978 979 1032 Next
Thread Rules
1. This is not a "do my homework for me" thread. If you have specific questions, ask, but don't post an assignment or homework problem and expect an exact solution.
2. No recruiting for your cockamamie projects (you won't replace facebook with 3 dudes you found on the internet and $20)
3. If you can't articulate why a language is bad, don't start slinging shit about it. Just remember that nothing is worse than making CSS IE6 compatible.
4. Use [code] tags to format code blocks.
Acrofales
Profile Joined August 2010
Spain18502 Posts
Last Edited: 2018-10-26 10:57:01
October 26 2018 10:53 GMT
#19521
On October 26 2018 19:45 bo1b wrote:
I know it's possible like that, but I'm asking if it's possible to subtract in anyway. I found this schema out of a textbook:

https://d2vlcm61l7u1fs.cloudfront.net/media/86b/86b4f72e-7407-4e33-af28-e90aacc10ccc/php4ZZyIW.png

Lets say you're trying to find the amount of copies remaining at specific library branch, using an aggregate count might not work, depending on how they've set up the schema. If all they've done is input that there are 5 copies of Casino Royal at that library, and 2 separate people have loaned a copy from that library, how can you output the correct answer?

I'm just trying to find out if you can do arithmetic from one column of data (assuming they're both numbers) to another, which I don't think is possible (or I never learned, which is more likely).

With SQL you can use basic arithmetic. Of course, SQL is not pure relational algebra, so don't know if that answers your question.

E: of course, the question you're asking isn't actually about relational algebra. Which is, per definition, about the relations in your database, not about manipulating individual values. So just as you cannot do string operations in relational algebra, you cannot do arithmetic operations: it's simply not what the algebra is for.
bo1b
Profile Blog Joined August 2012
Australia12814 Posts
October 26 2018 11:04 GMT
#19522
That's what I figured, I've been given a certain question relating to it and I don't want to ask for the answer online. Meaning the tutors either explained the problem wrong or I'm reading the question wrong.
tofucake
Profile Blog Joined October 2009
Hyrule19272 Posts
October 26 2018 13:52 GMT
#19523
you can select the book you're checking from book_copies, then join on book_loans and subtract the count(id) of that book.

Also it's odd there's no return_date column in book_loans
Liquipediaasante sana squash banana
bo1b
Profile Blog Joined August 2012
Australia12814 Posts
October 26 2018 20:23 GMT
#19524
There is a due date though.

How do you subtract in relational algebra? Could you give an example if possible?
Blitzkrieg0
Profile Blog Joined August 2010
United States13132 Posts
October 26 2018 20:39 GMT
#19525
On October 27 2018 05:23 bo1b wrote:
There is a due date though.

How do you subtract in relational algebra? Could you give an example if possible?


Due date shouldn't tell you if the book has been checked in or not. It should be checked in before the due date and it being past due doesn't mean it was turned in.
I'll always be your shadow and veil your eyes from states of ain soph aur.
bo1b
Profile Blog Joined August 2012
Australia12814 Posts
October 26 2018 21:12 GMT
#19526
Ah, yeah I see what you mean. I think it's just a homework assignment, and they weren't being particularly enthusiastic in creating it.
bo1b
Profile Blog Joined August 2012
Australia12814 Posts
Last Edited: 2018-10-30 03:32:53
October 30 2018 03:32 GMT
#19527
I've been using fzf on my linux install, and man oh man is it good. I've put this in my bashrc:

alias m="WD\$(pwd);cd ;mpv \"\$(fzf)\";cd \$wd"

and opening a terminal, and pushing m pulls up a library of every file in my home directory. Typing in a few letters of the show I want to watch narrows it down, and selcting it and pushing enter pulls it up on my screen in mpv. If I know what I want to watch it takes all of about 2 seconds to load up the video and start watching; more to the point I've done something similar with zathura for ebooks; now I have a library without the shitty reader that callibre provides, and it's so so fast.

This post brought to you by surplus autism™
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
November 01 2018 01:46 GMT
#19528
For once in my life I am trying to plan out my project before jumping into it but I'm struggling to nail down exactly how I want to do some things in terms of design.

I am making a debate site. It has Debates, Posts, Communities, and Users. Posts belong to Debates and Users. Debates belong to Communities and Users. Communities belong to Users. I'll probably need to add Teams and Coalitions.

There are different types of Debates. For example, Direct Debates(1v1 or team v team), Coalition Debates(team vs team with subteams with different objectives).

It seems to me that each type of Debate should be a subclass of Debate. However, I am having problems understanding how to configure that. In a Coalition debate, if Team A and B are in a Coalition, and Team C and D are in a Coalition, then the debate order goes A, C, B, D. However, how would I assign this order to the Debate? I am thinking of having simply, Post A, Post C, Post B, Post D and they must be in order, but this seems like a terrible solution.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
November 01 2018 01:55 GMT
#19529
On a entirely unrelated note, do you think that at some point in the future Serverless providers will switch to simply using WebAssembly for all of their different types of languages, rather than having to specifically enable certain languages?
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Acrofales
Profile Joined August 2010
Spain18502 Posts
November 01 2018 08:30 GMT
#19530
On November 01 2018 10:46 WarSame wrote:
For once in my life I am trying to plan out my project before jumping into it but I'm struggling to nail down exactly how I want to do some things in terms of design.

I am making a debate site. It has Debates, Posts, Communities, and Users. Posts belong to Debates and Users. Debates belong to Communities and Users. Communities belong to Users. I'll probably need to add Teams and Coalitions.

There are different types of Debates. For example, Direct Debates(1v1 or team v team), Coalition Debates(team vs team with subteams with different objectives).

It seems to me that each type of Debate should be a subclass of Debate. However, I am having problems understanding how to configure that. In a Coalition debate, if Team A and B are in a Coalition, and Team C and D are in a Coalition, then the debate order goes A, C, B, D. However, how would I assign this order to the Debate? I am thinking of having simply, Post A, Post C, Post B, Post D and they must be in order, but this seems like a terrible solution.

This is horribly confusing. I don't think anybody cares about"belonging" for any of those things, except posts. Maybe throw that draft away and focus on the basics:

What is a debate? Is it just a thread? Is it a thread with rules? Is it moderated?

What is the structure of your community? You mention users and community, but then mention teams and coalitions. What are these things? Can users belong to multiple teams? Can teams be in multiple coalitions? Is there something happening at community level, or is it just the set of all users? Are teams and coalitions managed in some way?

emperorchampion
Profile Blog Joined December 2008
Canada9496 Posts
November 01 2018 09:23 GMT
#19531
On November 01 2018 17:30 Acrofales wrote:
Show nested quote +
On November 01 2018 10:46 WarSame wrote:
For once in my life I am trying to plan out my project before jumping into it but I'm struggling to nail down exactly how I want to do some things in terms of design.

I am making a debate site. It has Debates, Posts, Communities, and Users. Posts belong to Debates and Users. Debates belong to Communities and Users. Communities belong to Users. I'll probably need to add Teams and Coalitions.

There are different types of Debates. For example, Direct Debates(1v1 or team v team), Coalition Debates(team vs team with subteams with different objectives).

It seems to me that each type of Debate should be a subclass of Debate. However, I am having problems understanding how to configure that. In a Coalition debate, if Team A and B are in a Coalition, and Team C and D are in a Coalition, then the debate order goes A, C, B, D. However, how would I assign this order to the Debate? I am thinking of having simply, Post A, Post C, Post B, Post D and they must be in order, but this seems like a terrible solution.

This is horribly confusing. I don't think anybody cares about"belonging" for any of those things, except posts. Maybe throw that draft away and focus on the basics:

What is a debate? Is it just a thread? Is it a thread with rules? Is it moderated?

What is the structure of your community? You mention users and community, but then mention teams and coalitions. What are these things? Can users belong to multiple teams? Can teams be in multiple coalitions? Is there something happening at community level, or is it just the set of all users? Are teams and coalitions managed in some way?



I agree with the idea of having specific debate types as subclasses of Debate. I also agree with what Acrofales is saying, and that some of the things you say should _have_ users, posts, etc., but not necessarily belong to them. I also don't understand what a community is, to me the community is the entire site.

In my mind the Debate is responsible for managing a debate. A Debate has (among other things): rules (how the debate is structured), teams (at least two), moderators, at least 1 thread (depends on the debate type, maybe some are private), and whatever else you think of that is necessary to actually carry out the debate. Some things floating around in my head: a 1v1 Debate limits the number of teams to 2 and the team size to 1, a coalition debate has a CoalitionTeam instead of a regular Team, each Debate subclass defines the Rules of the debate.
TRUEESPORTS || your days as a respected member of team liquid are over
WarSame
Profile Blog Joined February 2010
Canada1950 Posts
November 04 2018 01:00 GMT
#19532
On November 01 2018 17:30 Acrofales wrote:
Show nested quote +
On November 01 2018 10:46 WarSame wrote:
For once in my life I am trying to plan out my project before jumping into it but I'm struggling to nail down exactly how I want to do some things in terms of design.

I am making a debate site. It has Debates, Posts, Communities, and Users. Posts belong to Debates and Users. Debates belong to Communities and Users. Communities belong to Users. I'll probably need to add Teams and Coalitions.

There are different types of Debates. For example, Direct Debates(1v1 or team v team), Coalition Debates(team vs team with subteams with different objectives).

It seems to me that each type of Debate should be a subclass of Debate. However, I am having problems understanding how to configure that. In a Coalition debate, if Team A and B are in a Coalition, and Team C and D are in a Coalition, then the debate order goes A, C, B, D. However, how would I assign this order to the Debate? I am thinking of having simply, Post A, Post C, Post B, Post D and they must be in order, but this seems like a terrible solution.

This is horribly confusing. I don't think anybody cares about"belonging" for any of those things, except posts. Maybe throw that draft away and focus on the basics:

What is a debate? Is it just a thread? Is it a thread with rules? Is it moderated?

I used belonging to refer to a "has-a" relationship. So a Debate has Posts. I also need to track this stuff to see, for example, who made a specific Debate.

What is the structure of your community? You mention users and community, but then mention teams and coalitions. What are these things? Can users belong to multiple teams? Can teams be in multiple coalitions? Is there something happening at community level, or is it just the set of all users? Are teams and coalitions managed in some way?

A Community has Users that are subscribed to it, and contains Debates within it. I think I might rename it a Forum. It's similar to a Subreddit.

A Team is a group of co-operating Users within a Debate. A Coalition is a group of co-operating Teams to represent a side. The classic example of a Coalition Debate is France and Austria vs. Britain and Prussia to mirror the Napoleonic Wars.

Users cannot belong to multiple Teams. Teams cannot be in multiple Coalitions. Communities are collections of Debates posted to that Community and subscribed Users. Yes, I envision Teams and Coalitions being defined at the start of Debate, with modification possible with agreement between the Moderator(which I haven't thought much about yet), and both sides.

On November 01 2018 18:23 emperorchampion wrote:
Show nested quote +
On November 01 2018 17:30 Acrofales wrote:
On November 01 2018 10:46 WarSame wrote:
For once in my life I am trying to plan out my project before jumping into it but I'm struggling to nail down exactly how I want to do some things in terms of design.

I am making a debate site. It has Debates, Posts, Communities, and Users. Posts belong to Debates and Users. Debates belong to Communities and Users. Communities belong to Users. I'll probably need to add Teams and Coalitions.

There are different types of Debates. For example, Direct Debates(1v1 or team v team), Coalition Debates(team vs team with subteams with different objectives).

It seems to me that each type of Debate should be a subclass of Debate. However, I am having problems understanding how to configure that. In a Coalition debate, if Team A and B are in a Coalition, and Team C and D are in a Coalition, then the debate order goes A, C, B, D. However, how would I assign this order to the Debate? I am thinking of having simply, Post A, Post C, Post B, Post D and they must be in order, but this seems like a terrible solution.

This is horribly confusing. I don't think anybody cares about"belonging" for any of those things, except posts. Maybe throw that draft away and focus on the basics:

What is a debate? Is it just a thread? Is it a thread with rules? Is it moderated?

What is the structure of your community? You mention users and community, but then mention teams and coalitions. What are these things? Can users belong to multiple teams? Can teams be in multiple coalitions? Is there something happening at community level, or is it just the set of all users? Are teams and coalitions managed in some way?



I agree with the idea of having specific debate types as subclasses of Debate. I also agree with what Acrofales is saying, and that some of the things you say should _have_ users, posts, etc., but not necessarily belong to them. I also don't understand what a community is, to me the community is the entire site.

In my mind the Debate is responsible for managing a debate. A Debate has (among other things): rules (how the debate is structured), teams (at least two), moderators, at least 1 thread (depends on the debate type, maybe some are private), and whatever else you think of that is necessary to actually carry out the debate. Some things floating around in my head: a 1v1 Debate limits the number of teams to 2 and the team size to 1, a coalition debate has a CoalitionTeam instead of a regular Team, each Debate subclass defines the Rules of the debate.

I guess I mis-used the term "belong".

Thank you for your stab at it there. I think I like it. I think for Rules I could make an Interface that all Debates must implement to control how they go through their phases.
Can it be I stayed away too long? Did you miss these rhymes while I was gone?
Manit0u
Profile Blog Joined August 2004
Poland17875 Posts
November 05 2018 16:54 GMT
#19533
[image loading]
Time is precious. Waste it wisely.
Artesimo
Profile Joined February 2015
Germany628 Posts
November 05 2018 21:48 GMT
#19534
He definiteley wants to be a friends class of her
Manit0u
Profile Blog Joined August 2004
Poland17875 Posts
Last Edited: 2018-11-06 15:30:43
November 06 2018 08:58 GMT
#19535
https://www.humblebundle.com/books/dev-ops-oreilly

Edit:
Also this: https://github.com/chubin/cheat.sh

Amazing tool.
Time is precious. Waste it wisely.
Manit0u
Profile Blog Joined August 2004
Poland17875 Posts
November 07 2018 17:11 GMT
#19536
[image loading]

Finally something to send to your friends and family...
Time is precious. Waste it wisely.
Manit0u
Profile Blog Joined August 2004
Poland17875 Posts
November 08 2018 14:12 GMT
#19537
Some stuff I'm dealing with at work:

SQL query built with Java JDBC, called from Scala, called from Python, called from bash script...

[image loading]
Time is precious. Waste it wisely.
JosephJameson
Profile Joined November 2018
6 Posts
November 14 2018 20:41 GMT
#19538
--- Nuked ---
TentativePanda
Profile Joined August 2014
United States800 Posts
November 16 2018 20:04 GMT
#19539
FLASK vs Django?

I'm working on a university project and trying to decide which framework would be better for us (group project). Here is the info about the project and the members that are of note:

- Group project (3 of us) due in 2 weeks
- Need to design a user interface for our database server (website backed by DB)
- MySQL was used for database design
- We all have fairly decent python experience (and I'd like to think we are all capable people, willing and able to learn - even in this short amount of time)
- We have little to no web development experience

I know there are plenty of differences from what online (although both would work). I may be wrong, but I think the most important factor for us would be which framework allows us to work and connect to MySQL most easily.

Thank you so much to people who reply, it will be super appreciated!
solidbebe
Profile Blog Joined November 2010
Netherlands4921 Posts
November 16 2018 22:30 GMT
#19540
I have not worked with Django. Ive used Flask with sqlite, not MySQL, but my experience was that it was very straightforward to use. I dont think you can really go wrong with it.
That's the 2nd time in a week I've seen someone sig a quote from this GD and I have never witnessed a sig quote happen in my TL history ever before. -Najda
Prev 1 975 976 977 978 979 1032 Next
Please log in or register to reply.
Live Events Refresh
PiGosaur Cup
10:00
#108
Liquipedia
[ Submit Event ]
Live Streams
Refresh
StarCraft 2
RuFF_SC2 257
SortOf 48
ProTech6
StarCraft: Brood War
ToSsGirL 68
Bale 35
ZergMaN 25
Noble 23
Icarus 9
sOs 8
Force[name] 7
League of Legends
JimRising 731
Heroes of the Storm
Trikslyr71
Other Games
summit1g12224
WinterStarcraft509
C9.Mang0392
ViBE82
trigger7
Organizations
Other Games
gamesdonequick943
[ Show 11 non-featured ]
StarCraft 2
• CranKy Ducklings SOOP22
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• Migwel
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• lizZardDota297
League of Legends
• Rush1182
Upcoming Events
The PondCast
4h 33m
University League
4h 33m
LiuLi Cup
5h 33m
Rogue vs TBD
Maru vs TBD
OSC
10h 33m
Replay Cast
17h 33m
GSL
1d 6h
Maru vs Dark
Patches Events
1d 8h
OSC
1d 10h
Replay Cast
1d 17h
KCM Race Survival
2 days
[ Show More ]
Ultimate Battle
2 days
ZerO vs Bisu
RSL Revival
3 days
BSL
3 days
eOnzErG vs StRyKeR
Cross vs JDConan
RSL Revival
4 days
IPSL
4 days
Ret vs ggnore13
nOmaD vs Aether
BSL
4 days
Bonyth vs Doodle
Kyrie vs Jimin
Replay Cast
4 days
WardiTV Weekly
5 days
Kung Fu Cup
6 days
Solar vs Classic
ByuN vs SHIN
PiGosaur Cup
6 days
Liquipedia Results

Completed

Proleague 2026-11-16
Blizzard Classic Cup 2026
HCC Season 3

Ongoing

Acropolis #5
KCM Race Survival 2026 Season 4
International ShieldBattery League
BSL Season 23
IPSL Winter 2026-27
Calamity Cup Div. A Season 8
Underdog Cup 2026 Div 2-3
Stake Ranked Episode 6
BLAST Rivals Fall 2026
IEM Beijing 2026
PGL Masters Bucharest 2026
Stake Ranked Episode 5
1win Private Club #2
Thunderpick World Champ. '26
ESL Pro League Season 24
Stake Ranked Episode 4
1win Private Club #1
Logitech G Play Connect 2026
SL StarSeries Fall 2026
FISSURE Playground #3
BLAST Open Fall 2026

Upcoming

Sector 591
YSL S4
SC4ALL II: Brood War
NBSL 2026 Xiamen LAN
BSL 23: Non-Korean Championship
HSC XXX
Stellar Fest 2: Lunar Cup
StarCraft2 Weekly Open Tournament 2026 Grand Finals
SC4ALL II: StarCraft II
Kung Fu Cup 2026 Grand Finals
RSL Offline Finals
IEM Kraków 2027
PGL Bucharest 2027
BLAST Bounty Winter 2027
PGL Major Singapore 2026
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2026 TLnet. All Rights Reserved.