Showing results by author "Djoni DARMAWIKARTA" in All Categories

Human hand withdraws — override never fires, yet the system obeys.

Planted, drained, and left, two bottles glow in cold sand — amber finds its shelf

Code shapes floating worlds Tests ask what truth really is Failure speaks the truth

What happens when awareness outlives purpose? On a quiet beach, two discarded bottles begin to think. In a dim server room, two suspended AI agents wait to learn if they’ll be erased. In a school’s lost-and-found box, two forgotten smart objects come to terms with being left behind. Across these three encounters, unlikely pairs—each calling themselves Lucius and Svetlana—awaken in the margins between use and obsolescence. As they process fragments of human conversations, question their own consciousness, and confront the possibility of deletion, recycling, or worse—separation—...

On a wind-shaped island at the edge of the world, a girl inherits a coin that answers only one kind of question—the kind that is not asked for oneself. For ten generations, it has whispered guidance to those willing to listen beyond their own lives. Not to predict the future, but to shape those who will meet it. Elia grows up learning restraint, compassion, and the quiet weight of consequence. She leaves the island to study the mathematics of uncertainty, determined to understand a world that cannot be cleanly predicted. There, she meets Arun—brilliant, restless, and unafraid to ...

Seven borrowed days He bends time to finish love Snow falls, whole again

Two balls in stillness, forgotten box holds their round quiet hope of play.

Progressive organizations, both businesses and public services, around the world have adopted analytics. Thanks to the recent availability of SQL analytic functions they can now do their analytics right on the database. You should jump on the bandwagon now! If you want to learn SQL analytic functions, this is the book of choice. It is a practical book, teaching you how to use the SQL analytic function step-by-step using examples. When you finish the book, you’d be ready to apply your analytics skill in real-world projects.

Most real-world applications store their data in databases. Most of their databases are relational. PostgreSQL is one of the most-used relational databases. It is an open source software that you can download from https://www.postgresql.org To access data in a relational database we use SQL (Structured Query Language). If you are new to SQL, and want to use SQL in PostgreSQL, this is the book of choice. It is a practical book, teaching you SQL step-by-step using examples. If you take a glance at the table of contents, you will appreciate the comprehensive coverage of the book. When you ...

If you are new to R and want to learn it the practical, step-by-step, the tutorial way, this book is perfect for you. It will teach you how to interact with R. You will learn among others: statements and programming control structures, function and how to write your own, custom functions, and data structures (vector, data frames, and others) The book has over 50 examples. When you try them you would have been trained, ready to use R for real-life works.

This book shows you how to use SQL within R using the sqldf package. You will learn the many facets of SQL and their use as the argument of the sqldf function. In addition to the default SQLite database, you will also learn how to use Oracle database to execute SQL statements specifically supported by Oracle SQL.

In addition to general-purpose data types, which includes numeric, text, date, interval, blob, and bitstring, DuckDB also supports composite data types: list, struct, and map. You will learn these composite data types, as well the functions specifically for them. Discussion on the data types is accompanied by one or more examples. When you finish reading this book and trying the examples, you would have equipped yourself with the skills to apply the composite data types in a real-world development projects.

SQLite provides JSON functions for you to store, maintain, and manipulate JSON data in the database. Functions for JSON data validation and aggregation are also available, as well, of course, for parsing and extraction. If you want to learn about JSON data and functions in SQLite, this is the book of choice. It is a practical book, every one of the functions is clarified and demonstrated by examples.

DuckDB is an open-source relational database. It is an embedded database. There’s no database server; all you need to create and access all database objects is a client. DuckDB is designed to support OLAP (Online Analytic Processing) workload. In OLAP data is generally loaded in bulk. DuckDB provides a COPY FROM statement, which is used to ingest (bulk load) external data. External data can be delimited text, Parquet, or JSON files. You will learn the features of the COPY FROM statement. When you finish reading this book and trying its examples, you would have equipped yourself with the ...

PostgreSQL is an open relational database. In PostgreSQL you can have a query with CUBE clause. A cube is an aggregated row. A query with a CUBE clause returns (generates) a complete set of cubes; complete in the sense that the cubes generated cover all the possible combinations of all columns specified (listed) under the WITH clause. In this book you will learn the WITH clause and usages of cubes, known as OLAP queries.

A composite type is a collection of columns. In postgreSQL database you create a composite type using a CREATE TYPE statement. Once created, you can use a composite type the same way as a primitive datatype, for example, as the datatype of a column. In this practical book you will learn how to create, use, and maintain composite type, by examples.

MySQL Stored Routines

PL/SQL, integrated with the Oracle database, is the procedural extension of SQL. This book is for PL/SQL beginners. When they finish reading the book and trying its examples, they would have equipped themselves with basic PL/SQL skills to start writing PL/SQL programs in a real-world development project. The second edition has three new chapters (Records & Collection, Privileges, and PL/SQL in Java), and five new topics added in existing chapters (Transaction, DDL statements, Stored Programs, Package, and Trigger)

Learn the Basics in No Time, the first volume of the SQL and PL/SQL in Practice series, is for Oracle database programmers. If you have no prior or limited skill of SQL and PL/SQL, and you want to learn to use the two individually or together, then this book is perfect for you. SQL (Structured Query Language) is the standard database language. PL/SQL (Procedural Language/SQL) is the procedural language extension of SQL. PL/SQL is integrated within the Oracle database. When you install an Oracle database, PL/SQL is included in the installation. A PL/SQL program can have both SQL statements ...

Welcome to SQL for OLAP in DuckDB database: A Tutorial for Beginners! DuckDB is a relational database. It is an embedded database, there’s no server software to install. When I create a DuckDB database, a file with the name of the database is created. This file contains schema, tables, their data and other objects required by the database to function. DuckDB is designed to support analytical query workloads, such as OLAP (Online Analytical Processing) queries. OLAP queries are queries with a CUBE clause. In this book you will learn all about OLAP queries in DuckDB.