PostgreSQL
>create table:
CREATE TABLE table_name (column1, column2);
>add values:
INSERT INTO table_name (column1, column2) VALUES (value1, value2);
>add column:
ALTER TABLE table_name ADD COLUMN table_name data_type;
>open table:
SELECT * FROM table_name;
>update cell:
UPDATE table_name SET column_name='new_value' WHERE condition;
>set column as primary key:
CREATE table_name (id_column SERIAL PRIMARY KEY, column1);
>search for empty cells:
SELECT * FROM table_name WHERE column IS NULL;
---------------------------------------------------------
on web scraping
>HTTP request (solicitud HTTP): solicitud al servidor cuando quieres ir a una pagina web
>parsing (se usa tmb en AI): proceso de analizar data y descomponerlo en partes constituyentes. ///en web scraping, parsing se refiere principalmente a identificar objetos css
>DOM: las partes constituyentes ordenadas en jerarquía
>crawling: automatización completa de la url con el fin específico de indexear todo (ejemplo, los buscadores utilizan crawling)
>ubicadores de elementos html: >css selector: principalmente hecho para edición de css, limitado. >xpath: diseñado para movilizarse por todo el documento y realizar configuraciones más complejas
---------------------------------------------------------
practical deep learning for beginners
>validation set: data that tests accuracy of a model
---------------------------------------------------------
how to produce a fucking song (source: sage audio)
>leveling of course
>balance stereo image (giving each track good stereo placement)
>of course eq in the context of the full mix
>"shift attention to dynamics and adsr"
>temporal effect (delay, reverb): create a virtual room.
---------------------------------------------------------
computer structure: a programmer's perspective (bryant, 2016)
Architecture of an average computer:
>byte=8 bits
>bit= a binary value
>buses: wires. transfer data in an specific
word size (byte size)
>i/o devices: peripherals
>main memory: a temporary storage device that holds both a program and the data it manipulates while the processor is executing the program. it is a collection of DRAM (dynamic ram) chips, which is data constantly being refreshed.
>processor/cpu: read and interpret binary instructions that are stored in main memory. keywords: ALU, register file.
>network is just another i/o device
>api (application program interface): allows programmers to use code via functions.
>"The OS kernel serves as an intermediary between the applica- tion and the hardware. It provides three fundamental abstractions: (1) Files are abstractions for I/O devices. (2) Virtual memory is an abstraction for both main memory and disks. (3) Processes are abstractions for the processor, main memory, and I/O devices."
///i like how they said that you should have a "solid intuition", effectively acknowledging that complete understanding is a myth (unless you're autistic)
---------------------------------------------------------
Structure and Interpretation of Computer Programs (abelson, 1996)
>Well-designed computational systems, like well-designed automobiles or nuclear reactors, are designed in a modular manner, so that the parts can be constructed, replaced, and debugged separately.
>The general form of a procedure definition is:
(define ([name] [formal parameters]) [body]).
>///apparently, mathematical functions follow a similar logic to that of p.l. functions.
>In mathematics we are usually concerned with declarative (what is) descriptions, whereas in computer science we are usually concerned with imperative (how to) descriptions.
>The users of the procedure may not have written the procedure themselves, but may have obtained it from another programmer as a black box.///this sounds cool.
---------------------------------------------------------
on the measure of intelligence (chollet, 2019)
>friedberg (1958) said to build a truly intelligent machine, you either reduce all skills into exact sciences "or we must develop a machine that can do things without being told precisely how".
>"the field of artificial intelligence has been very successful in developing artificial systems that perform these tasks without featuring intelligence" (hernandez-orallo, 2017). chollet says this trend still continues.
>"AI's focus on achieving task-specific performance while placing no conditions on how the system arrives at this performance has led to systems that, despite performing the target tasks well, largely do not feature the sort of human intelligence that the field of AI set out to build."
>"As humans, we can only display high skill at a specific task if we have the ability to efficiently acquire skills in general, which corresponds to intelligence" ///ouch