/dpt/ - Daglig programmeringstråd

Hva jobber dere med, Sup Forums?

Gammelt tråd:

Other urls found in this thread:

discord.gg/MsHme
twitter.com/SFWRedditVideos

Hey guys, need some SQL help.

I have four tables;

Suppliers(S#, SNAME, STATUS, CITY)
Parts(P#, PNAME, COLOR, WEIGHT, CITY)
Jobs(J#, JNAME, CITY)

and SPJ(S#, P#, J#, QTY) which is a table which represents shipments of parts from suppliers to jobs. S, P, and J are all foreign keys to their respective tables. I need a query that gets the name of projects with one or more red parts supplied to it. Any tips in the right direction?

Should mention projects are synonymous with jobs in my database.

Daily remainder. Macros are the future.

Explain this "putting your datastructure on the heap" meme

If you're 'datastructure' is large enough to justify calling it a 'datastructure' and not simply an 'object', then you really can't count on the stack being able to hold it. Which means either heap or bss, and bss is only suitable for that if you know at compile time exactly how big your data structure is.

upboat

>MFW MY BOOK FINALLY ARRIVED

What book?

>SPJ
Are you channeling Haskell's creator?

congratulations desu sempai

recursive persistent data structures my dude

SELECT DISTINCT j.jname
FROM jobs j, parts p, spj
WHERE j.j# = spj.j#
AND spj.p# = p.p#
AND p.color = 'red';

First for Turing machines and other abstract computers only define "possibility", not "practicality"

This. Total languages are much more appropriate for many tasks.

Elaborate for the dumbs please

...

Programming in D

>D
Trash.

Did I ask your opinion?

Yes.

Point to me where

Turing completeness says that all Turing complete languages can do everything that any other Turing complete language can do, but it doesn't say that they're good at it

Noice

Could I get your opinion on my book?

So basically some languages are better at other things than others and some languages are just outright better than others

Text looks kinda blurry, a misprinted copy maybe?

>He doesn't analyze how much memory he needs and sets the stack size appropriately
Sad

>He has to analyze how much memory he needs and sets the stack size appropriately
Sad!

Basically, most languages are shit and computer science was a mistake.

>He doesn't use his cache to its fullest
Sad!!

>He has to use his cache to its fullest
Sad!!!

counterfeit programming books are huge business now, thanks pajeet

>He uses caches
Sad!!!!

I don't :^)

If caches are so fast why don't we just use those instead of RAM?
Cache btfo

can't download cache

Anyone here use discord or other IM software, it'd be cool to have people to chat to in real time whilst programming

>proprietary software

Fuck off

No, there isn't a /dpt/ discord, you should probably leave right now before someone lies to you and tells you there is, getting your hopes up.

?

discord.gg/MsHme
Don't expect much from us

LE GAYMUR CHAT XDDDDDDDDDD

>muh freedoms

Discord shill fuck off back to

Excellent post
Cry more

This, IRC is still king

Go back, manchild

>over the age of 20
>playing video games
Kill yourself, basement dweller

What are some good programming IRCs then

What language are you using?

#lisp on freenode

Don't bring Sup Forums to IRCs please

Can software and OS be joined into one relation?

Keep crying bitch niggas

This.

>implying Sup Forums even know what IRC is
Those babbies only know discord

Scala for my coursework, Python and Java for fun. Learning MySQL at the moment and it's screwing me around a bit. The MySQL IRC was dead silent for hours.

Google around friendo, and leave your silly comments at the door.

irc://irc.freenode.net/scala

Go to the #scalaz channel for help with Scala.

Jesus, some guys are so productive
I often get sad and jealous of them ;_;

How do they do that? Advanced forms of autism?

yeah this was pretty normie tier stuff, sorry boys.

Pretty sure freenode has a channel for all those languages.

What do you think?

OS is software

>including headers for templates in c++
what a headache

Use a productive language

Practice will give you more understanding how you can deal with certain problems. Learn how to use your language's features.

It is and as OS has no other relationships in this model, it should be okay to implement this as just one relation assuming that OS has no other attributes that software does not have, is this correct?

>they're productive so something must be wrong with them
user...

>what job is this with, Sup Forums

Why learn about turing machines if every computer that can be constructed in the real world is a finite state machine?

CREATE TABLE computer(
id int NOT NULL PRIMARY KEY,
name varchar(15),
specs varchar(100),
price money,
os varchar(15),
package int
);

CREATE TABLE software(
serial int NOT NULL PRIMARY KEY,
os varchar(15) NOT NULL,
package int,
FOREIGN KEY(os) REFERENCES computer(os) ON UPDATE CASCADE ON DELETE REJECT,
FOREIGN KEY(package) REFERENCES computer(package) ON UPDATE CASCADE ON DELETE CASCADE
);

How'd I go?

>steveklabnik
lol

>every computer that can be constructed in the real world is a finite state machine?
While you can twist your logic and say that's true, it would be one of the most stupidly unhelpful ways of thinking about it.

anyone?

Explain this "putting your datastructure on the stack" meme

It's guaranteed to work in every conforming implementation of 'c'.

They allow for mathematical definitions of 'computation', and allow us to reason about computations more abstractly. How do computations relate? What does 'complexity' of a computation mean? Are there uncomputable things? (Turing ofc showed there are, i.e. Halting problem).

What is the sexiest data structure? I'd say redblack trees are pretty hot

BRB, creating a finite state machine for every 2^64+ states on my processor

>2^64+
There is more than that. You've got to consider the state of your storage as well, and possibly the state of the universe around it.

>mfw the entire internet is just a huge state machine
>mfw I'm just a state machine

I like the public class

Explain this "putting your datastructure in the cloud" meme

The cloud is undefined behavior.

>Doing problems from chapter 1 of K&R
>Chapter has not covered the modulo operator
>The answer to one of their problems uses modulo

Is this book badly organized or did the authors assumed that you knew what modulo was?

Remainder = Dividend - Dividend/Divisor
That being said, fuck C

perhaps a bit of both

what's the difference between C and C++

>not knowing what modulo means since the time you are born

>did the authors assumed that you knew what modulo was
Probably. It's not really a book for beginners.

C is C++ for kids

C++ is basically a bigger language built on top of C.

Many more features and such while being somewhat (to some extent, not fully) backwards compatible with C.

but c is lower level, closer to the hardware i thought?

i thought kids liked everything to be abstracted, pointers hidden, everything's a virtual, everything's a class, everything's a reference, do little applets and webdev

incorrect?

C is not a low level language, kids delude themselves into thinking it is

i didn't say it was low level, just lower level than c++

C is a somewhat minimal language, with a very focused design.
C++ is a fucking clusterfuck of random disparate features thrown together.

C has a certain elegance to its design. C++ does not.