New pages
Jump to navigation
Jump to search
- 21:08, 30 May 2024 SQL Conditional Logic (hist | edit) [4,693 bytes] Ovidiu (talk | contribs) (Created page with "=Interna= * <tt>SQL WHERE</tt> =Overview= SQL conditional logic is the ability of SQL statements to take one of several paths during execution, depending on the value of an expression. The SQL has syntax that provides IF/ELSE conditional logic, except that it uses the <code>CASE</code> keyword instead of <code>IF</code>. The <code>CASE</code> expressions can be used in conditional <code>SELECT</code>, <code>SQL_INSERT#Conditional_I...")
- 23:06, 24 May 2024 Person Company City (hist | edit) [1,150 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Querying Multiple Tables =Overview= <syntaxhighlight lang='sql'> </syntaxhighlight>")
- 22:49, 24 May 2024 SQL ARRAY (hist | edit) [1,252 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL Data Types =Overview=")
- 22:27, 23 May 2024 SQL Set Operations (hist | edit) [167 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =TODO= <font color=darkkhaki>PROCESS: https://learning.oreilly.com/library/view/learning-sql-3rd/9781492057604/ch06.html</font>")
- 17:03, 23 May 2024 SQL CREATE ALTER DROP VIEW (hist | edit) [604 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL Data Types =Overview= =<tt>CREATE</tt>= <syntaxhighlight lang='sql'> CREATE TABLE person ( id smallint, name varchar(30) NOT NULL, CONSTRAINT pk_person PRIMARY KEY (id) ); </syntaxhighlight> :{| class="wikitable" style="text-align: left;" |- | PostgreSQL || MySQL |- |} =<tt>ALTER</tt>= <syntaxhighlight lang='sql'> ALT...")
- 00:13, 23 May 2024 SQL AUTO INCREMENT (hist | edit) [136 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * <tt>CREATE</tt> | <tt>ALTER</tt> | <tt>DROP</tt> | <tt>TABLE</tt> =Overview=")
- 23:52, 22 May 2024 SQL Constraints (hist | edit) [1,323 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= =Primary Key Constraint= <syntaxhighlight lang='sql'> CREATE TABLE ... ( ... CONSTRAINT pk_someconstraint PRIMARY KEY (somecolumn) ); </syntaxhighlight>")
- 23:14, 22 May 2024 SQL GROUP BY (hist | edit) [242 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= =Overview= <font color=darkkhaki>Make sure I understand thoroughly and link.</font>")
- 23:05, 22 May 2024 SQL Indexes (hist | edit) [175 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview=")
- 23:00, 22 May 2024 SQL Database Metadata (hist | edit) [436 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= A database server stores information about all the database objects (tables, views, indexes, etc.) that were created with the SQL schema statements.")
- 22:40, 22 May 2024 SQL WHERE (hist | edit) [4,771 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL <tt>UPDATE</tt> * SQL <tt>DELETE</tt> * SQL <tt>SELECT</tt>")
- 22:39, 22 May 2024 SQL DELETE (hist | edit) [563 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL <tt>WHERE</tt>")
- 22:39, 22 May 2024 SQL UPDATE (hist | edit) [931 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL * SQL <tt>WHERE</tt>")
- 22:38, 22 May 2024 SQL INSERT (hist | edit) [639 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * {{SQL#INSERT|SQL}} * {{SQL_WHERE#Overview|SQL <tt>WHERE</tt>}}")
- 22:23, 22 May 2024 SQL Data Types (hist | edit) [3,043 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= <font color=darkkhaki> * SQL data types * Database-specific data types * Working with different data types * Conversion functions </font>")
- 22:14, 22 May 2024 SQL CREATE ALTER DROP TABLE (hist | edit) [3,205 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * _ALTER_|_DROP_TABLE|SQL")
- 22:10, 22 May 2024 SQL Transaction Statements (hist | edit) [194 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview=")
- 21:10, 22 May 2024 SQL Querying Multiple Tables (hist | edit) [16,833 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Querying Multiple Tables =Overview= Querying Multiple Tables, Joining Tables Define join. Join condition Foreign key")
- 21:02, 22 May 2024 SQL SELECT (hist | edit) [7,913 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * SQL =Overview= Query execution. SQL optimizer. Subqueries.")
- 21:30, 21 May 2024 Masterminds/squirrel (hist | edit) [2,670 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://github.com/Masterminds/squirrel * https://medium.com/nerd-for-tech/postgres-libraries-to-try-with-go-8f80191edbff =Overview= <font color=darkkhaki>Intro how to use it: https://medium.com/nerd-for-tech/postgres-libraries-to-try-with-go-8f80191edbff</font>")
- 21:16, 21 May 2024 Jackc/pgx (hist | edit) [2,044 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.youtube.com/watch?v=sXMSWhcHCf8 =Internal= * PostgreSQL Support in Go")
- 16:25, 21 May 2024 NumPy Fancy Array Indexing (hist | edit) [1,046 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy <tt>ndarray</tt>")
- 16:25, 21 May 2024 NumPy Boolean Array Indexing (hist | edit) [2,999 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy <tt>ndarray</tt>")
- 19:53, 20 May 2024 NumPy Universal Functions (hist | edit) [135 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy Concepts * <tt>ndarray</tt> =Overview=")
- 19:51, 20 May 2024 NumPy Pseudorandom Number Generation (hist | edit) [1,139 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * NumPy Concepts =Overview=")
- 19:23, 20 May 2024 NumPy ndarray (hist | edit) [19,522 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Numpy Concepts =Overview= <code>ndarray</code> is an N-dimensional array object, which is a fast, flexible container for large datasets in Python. It is used to implement a Pandas Series.")
- 17:19, 17 May 2024 Python zip() (hist | edit) [365 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Python Language Functions =Overview= <code>zip()</code> "pairs" up the elements of a number of lists, tuples or other sequences to create a list of tuples.")
- 21:48, 16 May 2024 Slicing Lists and Tuples in Python (hist | edit) [4,557 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Lists * Tuples")
- 00:09, 15 May 2024 IPython Operations (hist | edit) [426 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * IPython")
- 00:09, 15 May 2024 IPython Concepts (hist | edit) [537 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * IPython")
- 23:52, 14 May 2024 Miniconda (hist | edit) [129 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * conda")
- 23:50, 14 May 2024 PyTorch (hist | edit) [98 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.statsmodels.org/stable/index.html =Internal= * Python for Data Analysis =Overview=")
- 23:47, 14 May 2024 Statsmodels (hist | edit) [349 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.statsmodels.org/stable/index.html =Internal= * Python for Data Analysis =Overview=")
- 23:39, 14 May 2024 SciPy (hist | edit) [919 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://scipy.org =Internal= * Python for Data Analysis")
- 23:35, 14 May 2024 IPython (hist | edit) [198 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://ipython.org =Internal= * Python for Data Analysis =Overview= An interactive Python interpreter, that encourages an execute-explore workflow instead of the typical edit-compile-run workflow.")
- 23:04, 14 May 2024 Scikit-learn (hist | edit) [176 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Python for Data Analysis")
- 22:40, 14 May 2024 Python for Data Analysis (hist | edit) [1,489 bytes] Ovidiu (talk | contribs) (Created page with "=External= =Internal= * Python Engineering =Overview=")
- 22:29, 14 May 2024 Descriptive Statistics (hist | edit) [155 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://www.investopedia.com/terms/d/descriptive_statistics.asp =Internal= * Statistical Concepts =Overview=")
- 20:29, 14 May 2024 State Machines in Go (hist | edit) [440 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * State Machines")
- 20:28, 14 May 2024 State Machines (hist | edit) [67 bytes] Ovidiu (talk | contribs) (Created page with "=Subjects= * State Machines in Go")
- 01:54, 11 May 2024 Protocol Buffer Services (hist | edit) [2,271 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= Protocol Buffers can define services that use messages to exchange data. A '''service''' is a set of '''endpoints''', introduced by the <code>rpc</code> keyword, with different semantics that can be used to call into the service, by sending a request, and then receiving a response. <syntaxhighlight lang='protobuf'> service SomeService { rpc SomeEndpoint(SomeRequest) returns (SomeResponse); rpc SomeOtherEndpoint(SomeOtherRequest) returns (So...")
- 01:38, 11 May 2024 GRPC Concepts (hist | edit) [1,629 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * gRPC =Overview= gRPC is a RPC framework that uses HTTP/2 as transport protocol and Protocol Buffers as serialization format. It provides the ability to define RPC services and generate the client and server code for the services. It also offers authentication, context propagation and documentation generation. An example of how to use gRPC and Protocol Buffers to implement a microservice API is available in Chapter 5. Synchronous Comm...")
- 23:36, 8 May 2024 Forward and Backward Compatibility (hist | edit) [1,303 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Serialization")
- 22:56, 8 May 2024 Converting Protocol Buffers Messages to and from JSON in Go (hist | edit) [1,088 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Protocol Buffer Concepts =Overview= This example uses this message definition: <syntaxhighlight lang='protobuf'> message SomeMessage { int32 id = 1; bool is_valid = 2; string name = 3; repeated string sample_list = 4; } </syntaxhighlight> The Go code is generated following the instructions from: {{Internal|Protocol_Buffers_Data_Type_Go_Code_Generation#Overview|Protocol Buffers Go Code G...")
- 22:18, 8 May 2024 Marshal/Unmarshal Protocol Buffers in Go (hist | edit) [1,051 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Protocol Buffer Concepts")
- 00:50, 7 May 2024 Protocol Buffers Data Type Go Code Generation (hist | edit) [10,545 bytes] Ovidiu (talk | contribs) (Created page with "=External= https://protobuf.dev/reference/go/go-generated =Internal= * Protocol Buffer Concepts =Overview= The code that supports the data types defined in the <code>.proto</code> files are generated as follows: <syntaxhighlight lang='bash'> </syntaxhighlight>") originally created as "Protocol Buffers Data Type Code Generation"
- 23:37, 6 May 2024 Protocol Buffer Types (hist | edit) [5,194 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Protocol Buffer Concepts =Overview=")
- 21:10, 2 May 2024 Protocol Buffer Operations (hist | edit) [190 bytes] Ovidiu (talk | contribs) (Created page with "=Internal= * Protocol Buffers")
- 21:09, 2 May 2024 Protocol Buffer Concepts (hist | edit) [19,637 bytes] Ovidiu (talk | contribs) (Created page with "=Overview= Protocol buffers is a format used for data serialization, publicly introduced by Google in 2008. The benefits of using Protocol Buffers include the simplicity of the definition language, a small data output size, high performance of serialization and deserialization and the ability to define derives in addition to data structures and compile client and server code in multiple languages. Protocol Buffer can be used as serialization format for Microservices|m...")
- 23:56, 25 April 2024 Github.com/uber/mock (hist | edit) [610 bytes] Ovidiu (talk | contribs) (Created page with "=External= * https://pkg.go.dev/go.uber.org/mock/gomock =Internal= =Overview=")