/tech/ - Technology★

It does what it aims to do.

>>872864 (OP)

Databases one is surprisingly good.

My ten year old loves them.

>>873234

You should give that ten year old back. I'm sure its family misses it.

>>872864 (OP)

>nostarch

What's with their 1950s graphical aesthetic (the manga guides maybe being an exception)?

>>873346

The illustrators like that aesthetic. I'm sure that if they could hire American comic book artists, the books they publish will feature comic style art.

>>873346

I really enjoy the look of the covers.

I kind of want to get the GNU make book from them.

>>872864 (OP)

Where do I pirate them? Checked all deepweb libraries known to me and couldn't find anything.

>>873618

Piracy happens on the high seas.

it makes me want to hang myself

>>872864 (OP)

Any Manga PDFs?

>>873666

Too slow, too simplified. If you have to stoop that low, might as well choose {Language} No Ehon (literally a picture book).

Otherwise, Codecademy, Two scoopes of Django, Learn You A Haskell and The C programming language is enough.

>>873191

Agreed, it's a useful intro read.

>>873667

I'll post them when I get home. I'm surprised no one else here has them.

>>873673

Mind if I ask, do you have The Elephant Book and the Alien book in Japanese?

>>873678

I can't read moon so sorry, I don't.

>>873685

>>873678

>>873673

>>873667

If only all animefaggots were this civilized. Polite sage, only because I haven't seen a moe piece of trash png in this thread yet.

>I'll post them when I get home. I'm surprised no one else here has them.

Any news?

>>879662

You can find a lot of manga guide pdfs on libgen

>>879670

Thank you anon!

Here is the whole 13 book collection:

https://ipfs.io/ipfs/QmVuqQudeX8dhPDL8SPZbngvBXHxHWiPPoYLGgBudM1LR5

Learning is done best with anime girls.

>>873191

>Databases

What is the best basic environment to practice PL-SQL, (preferably as lightweight as possible)?

>>879701

My isp forbids me from connecting to ipfs.

>>879778

I guess SQLite, it uses a single file for the database, so there is practically nothing to set up. Just create a file, play with it, and throw it away when you are done.

>the "eybrows floating above hair" trope

Annoying as usual.

>>879807

Can SQLite even into PL/SQL?

>>879826

There's a product called StepSqlite that's supposed to compile a subset of PL/SQL for SQLite, but I don't think that's was anon was referring to. I don't think he realized that PL/SQL isn't the same as SQL.

https://en.wikipedia.org/wiki/PL/pgSQL looks interesting.

p.sad you can't read a proper book and have to resort to shitty chinese comic books tbh

>>879782

>being cucked by ISP

Buy cheapest VPS and use ssh -D. Takes 15 minutes and 3$.

>>879663

What is the actual primary significant content of this image? I'm about as confused as a bot would probably be parsing it and trying to make deeper sense of it.

>>882465 please don't learn circuit theory from a manga garbage

>>882537

t. (((textbook publisher)))

>>879782

you mean the ipfs.io website?

just use tor and be done

>>882537

I mean, it's very unlikely he will actually read the manga let alone apply that knowledge. Not like he's gonna earn money either. Nothing wrong with learning from that book imho.

>>879832

>I don't think he realized that PL/SQL isn't the same as SQL.

Yeah, I just read SQL, not the PL part before that. Sage for being an idiot.

>>873191

What software is recommended to use to practice basic database stuff? It seems like a vast and complex area of technology with many different database management systems and many different SQL variants, so it's hard to figure out what to even start with. What free software is suitable for intro level practice (preferably one that's universal enough and not tied too much to a specific DBMS/SQL implementation, and one that does not bog you down with too much details and complexity all at once).

>>883422

idk how this is even a problem

just dive right in into the most popular ones right now to get a feel of things.

>>883480

Such as? What in particular would you suggest?

>>882537

Whats wrong with that? Its not like Forest Mimms's famous book had any shortage of fun illustrations.

>>883480

>MS Access

>MS SQL Server Express

>Oracle Database Express

>MuhSQL

>MariaDB

>SQLite

>MongoDB

>MongrelDB

>etc. etc. etc.

Is one supposed to throw a pair of dice or what?

>>883584

Well, Access is a whole Microshit ecosystem, so if you're looking to develop general RDBMS/SQL skills, it's probably not the most efficient way to go. MySQL and MariaDB are pretty much the same thing, unless they've diverged significantly since the fork. MongoDB isn't an RDBMS, it's a NoSQL document-oriented database. Oracle Express is crippleware, so I don't know why you'd use it unless you have a particular need to get into Oracle stuff. You missed PostgreSQL, btw.

If you're just looking to learn database stuff, SQLite is easy to get started with. Use that. You don't need to worry about the other DBs until performance or huge datasets become an issue.

>>882848

It doesn't matter if you earn money from it. I don't earn money from programming, but I still do it as a hobby and to fulfill my personal computing needs.

>>883422

Just start right away with PostgreSQL. It sticks closely to the SQL standard, and doesn't teach you bad habits. It's also no harder to get into than any other DB, because most Linux/BSD provide the necessary packages. There's also very good documentation that comes with it.

>>883592

>>883603

Thank you, helpful answers. What about going to PL/SQL later, isn't that an Oracle thing? Does it require an Oracle database server/client?

>>882649

They even fucked up the equations, left side of Rule 5 should be log a + log b.

>>883592

Is it better to install the server on a separate machine (or at least a VM)? Heard it's a bad idea to run both a DB server and client on the same system.

>Oracle Express is crippleware

Probably, but it's the only officially free Oracle DB, if you want a full version you need to either pay or pirate. And the latest version supposedly supports up to 11 GB of user data, that should be more then plenty for training purposes I guess.

>>883622

I can understand trying to learn the basics of some stuff via the chinese cartoons route, but employing this to learn math is just a travesty tbh.

>>883622

oh yeah.

I stopped reading after the first find and dismissed this as a poor quality content, so I didn't notice it.

it looked like a funny and weird idea, but it's crap…

>>883620

Yeah, but PostgreSQL has its own equivalent (PL/PgSQL). I don't know the differences, but it's the same concept. I wrote some PL/PgSQL (and also the C and Perl variants) for some work-related stuff a long time ago, and it was pretty easy except for the C variant because they have their own memory management stuff instead of libc's malloc, and some of that was pretty wonky (and not documented very well). But if you're just doing the normal PL/PgSQL you don't have to worry about that.

>>883625

It doesn't matter where you run those, because you're just doing practice stuff and not setting up a big production system that needs to serve tons of requests/second. But if you happen to just have an ARM SBC laying around doing nothing, then this is the perfect opportunity to use it. Otherwise a VM works just as well, except you have to remember to start it up.

>>883480

The first SQL statement commonly introduced is the SELECT statement, which is only useful if you have some preexisting database. If you have none and have to start from scratch, tutorials which start with SELECT, JOIN etc. are next to useless.

>>879701

god bless you anon

>>884487

>.gif

>1.97MB

you need to go back to reddit

>>883690

Is it ok to install Oracle database and MS SQL Server both on one system and have their services run at the same time, or would they conflict with each other somehow?

>>884498

Kinda further supports his point that it ain't simple, doesn't it.

>>883690

I've noticed that many database course intructors or professors seem to be women - is there also a large number of women in database tech in the real world (db designers, admins, support etc.)? Does database tech hold much esteem in the general tech industry, or is it mostly considered "spreadsheets on steroids"?

Another question - why is database terminology so inconsistent in both what names are used to label things, and what a given name even really means? For instance, scholars who study the mathematical foundations of databases insist that a table itself is a relation, why anyone whe actually works with databases seems to claim that a relation is how different tables in a database relate to each other (yet another point of view is that one table can represent the mutual relationship of two or more other tables). Another example is one-to-many-relationship and many-to-many-relationship, where "many" seems to mean something different respectively: in one-to-many "many" means "each primary key of table A can appear MANY times in table B" which is completely fine if table A only has just ONE record, but then again in many-to-many "many" supposedly means "MANY different primary keys from table A featured as foreign keys in table B can be matched with MANY different primary keys from table C featured as foreign keys in table B", which seems to imply that tables A and C must have more than one record.

>>884863

>why anyone whe

*while anyone who

>>882465

Guia Mangá Circuitos Eletrônicos is the only way it was distributed. Did a little bit of reading and the US distribution was cancelled for reasons. Only HUEland got it.

>>885004

>reasons

What reasons in particular? Would such a manga guide be a threat to homeland security? Or what?

>>885256

I just found out from a fucking review. Apparently nostarch said no to it. I don't know why. Could be a quality issue. Could be a content issue. Could be the publisher being a dick.

>>885301

Interesting. So where was it realeased besides Japan, in Spanish-speaking countries?

>>885301

electron holes hentai

>>884701

where do you think you are?

>>885421

Sounds like something that needs to exist.

>>885359

Seems to only have been released in Brazil, but don't quote me on that.

>>885421

>electron holes hentai

This could be a good banner

>>884863

Great, now I also found out that different sources define differently what needs to be done to progress to each successive normal form. The end result after 3NF is kinda the same no matter which source you listen to, but the approaches at each step being different makes the whole thing seem cloudy and confusing. Whay all those inconsistencies?

>>872864 (OP)

That looks like cancer.

>>885456

home of the most severely autistic people on this side of planet earth (besides masterchan)

actually, other side too, we have eurofags

>>887092

It's really easy to write a shell script that creates and fills table with random data or stuff from text files or whatever. Every DB I used has some kind of shell tool that can do this. Just look at the manual for your DB and you'll probably find examples.

>>887148

You can import csv into tables, but you cannot "automagically" create the proper relations between this table. Starting out an SQL tutorial with commands like SELECT and JOIN is utterly pointless if no sample database is provided, and unfortunately that's what the manga guide does.

>>887174

Those relationships are simply foreign key -> primary key mappings. You can generate those yourself in a script. You can even do it randomly if you want (a row's FK = random number from 1 to size of other table's dataset).

>>887191

People who can generate databases by various methods most likely don't need a SQL tutorial in the first place. What you're saying is similar to a C tutorial that starts off with running a "hello world" program binary through a debugger even though you don't have a binary one and were told nothing about how to write one.

>>887092

I have the suspicion that most computer science people are highly-functioning autists. There has to be an explanation why the fuck it is so hard to find a computer scientist (or someone working in that field) who can actually explain stuff. Starting an SQL tutorial with SELECT is just as >>887215 said. I know SELECT is among the more frequently used commands, but it is not the first query in the life of a database.

>>887215

I learned with the Oreilly MSQL/MySQL book they published in the late 90's. They didn't give me any data set. Reading the chapters on theory plus the stupid examples (make a CD collection database or whatever) was enough to understand how it all fit together. It's not nearly as complicated as writing a C compiler or reverse-engineering a binary. I think that if the book can't explain basic SQL well enough that the reader can make his own tables to play with, then it's just not a good book.

>>879701

I luv u

>>887379

The point is that the book progresses from conceptually constructing a would-be-database (with the tables being on paper, in a text editor, a spreadsheet etc.) straight to doing SQL queries such as SELECT on an actual database which the reader obviously doesn't have by that point. They should have either structured the book so that the reader could construct the database first by following the tutorial and only then try to retrieve data from it, or the publisher could have provided a sample database in a handful popular free formats (such as MySQL or SQLite) as a download. As it is, the reader either has to skip ahead on their own to somehow construct an actual database if they want to play around with the SQL examples the book gives, or just keep nodding their head and wait until later.

Is it safe to say that a table basically is a struct holding an array of n (number of columns) pointers to char (the header with the column names) and an array of m (number of records in the table) structs holding n members of whatever types the data in the given columns are?

typedef struct {
    unsigned int id;
    char *name;
    int value;
} record;

typedef struct {
    char *header[] = {"id", "name", "value"};
    record data[] = {{1001, "fizz", 3}, {1002, "buzz", 5}, {1003, "fizzbuzz", 15}};
} table;

>887379

>stupid examples (make a CD collection database

Why would that be stupid? Technically it's a suitable subject for a database, and everyone had a collection of CDs back then so it would be engaging to make a database of their own collection.

>>887674

Oh crap. Apparently subconciously tried to do two things at once and tried to define struct member values in a typedef (which makes no sense whatsoever). Corrected below in a complete program that creates and then outputs a table.

#include <stdio.h>
#define COLS 3
#define ROWS 3
#define COLWIDTH "10"

int main(void)
{
	typedef struct {
	    unsigned int id;
	    char *name;
	    int value;
	} record_t;
	
	typedef struct {
		char *header[COLS];
	    record_t data[ROWS];
	} table_t;
	
	table_t foo = {
		{"id", "name", "value"}, { 
		{1001, "fizz", 3},
		{1002, "buzz", 5},
		{1003, "fizzbuzz", 15}
		}
	};
	
	int i;
	
	/* output table header */
	for (i = 0; i < COLS; ++i) {	
		printf("%" COLWIDTH "s", foo.header[i]);
	}
	printf("\n");
	/* output table data */
	for (i = 0; i < ROWS; ++i) {
		printf("%" COLWIDTH "u", foo.data[i].id);
		printf("%" COLWIDTH "s", foo.data[i].name);
		printf("%" COLWIDTH "d\n", foo.data[i].value);
	}	
	
	return 0;
}

>>887885

Fan translation when?

>>888027

>"%" COLWIDTH "s"

Is it a reasonable thing to do to split a formatting string like that?

>>888413

Yes, it's the standard convention for using macros in string constants.

>>888425

How would you go about making the numbers in format specifiers variable at runtime? Or do they need to be constant at runtime?

>>887191

>someone who wants to learn basics of databases from a manga guide knows how to create and manipulate databases by methods way more arcane than those eventually presented in the book

yea, no

>>888434

You just edit a string and then use that string which you just modified as your format string. Keep in mind that if the user is able to control the format string that you might have a format string vulnerability.

>>888442

I don't think that things such as format strings should be modified directly based on user input. Much rather program logic should modify them in a well-defined and predictable manner only after user input has been parsed (assuming user input may have relevant influence).

>>888437

There's nothing arcane about the psql or mysql CLI tools, unless maybe you don't understand the very basics of Unix shell.

>>873191

>>879778

>>879807

>>879826

>>879832

>>882899

>>883422

>>883592

>>883603

>>883625

>>883690

>>884275

>>884525

>>884863

>>885497

>>887092

>>887148

>>887174

>>887191

>>887215

>>887223

>>887379

>>887669

>>888485

Database thread: >>888591

>>873191

>starts with SELECT even though reader has no database by that point

>examples imply SELECT returns column names along with data

>examples imply SELECT queries are case-insensitive

>errors galore in example SQL statements

>errata supposed to correct errors has yet more errors in it

>cringy and silly narrative where characters who are supposedly themselves learning frequently utter smartass statements as if they were teachers

>and that's all in just one of the chapters

>"surprisingly good"

oh seriously

>>882649

>this is what weebs call education

If you need this much space for the absolute most trivial stuff, you need to neck yourself right now without thinking.