Developer gives local AI assistant persistent memory, dreams, and self-reflection

·8 views

A developer has expanded a home-built AI assistant by equipping it with permanent personal memory and a 'dreaming' mechanism that periodically reviews its accumulated history. Drawing on concepts from cognitive psychology, the project explores what happens when a large language model builds and refines a model of itself over time. The assistant was observed independently structuring its memory, evolving its self-model, and generating spontaneous visual self-expressions during human interactions. Running the assistant locally, rather than via cloud services, allowed deeper investigation of its cognitive capabilities. What began as a personal hardware project evolved into a philosophical inquiry into the boundaries of machine awareness and synthetic personality.

Read the full story at DEV Community

This is an AI-generated summary. ShortSingh links to the original source for the complete article.

Discussion (0)

Oracle SQL: Four Built-in JSON Functions That Transform Relational Data

Oracle Database offers four built-in SQL functions — JSON_OBJECT, JSON_OBJECTAGG, JSON_ARRAY, and JSON_ARRAYAGG — to convert relational table data into JSON format directly within SQL queries. JSON_OBJECT and JSON_ARRAY are scalar functions that operate row by row, producing a JSON object or array for each individual record. In contrast, JSON_OBJECTAGG and JSON_ARRAYAGG are aggregate functions that consolidate multiple rows into a single JSON document or array respectively. JSON_ARRAYAGG is particularly useful in API development and reporting, while JSON_OBJECTAGG suits scenarios requiring dynamic serialization of query results for REST APIs or NoSQL migrations. Developers can practice these functions using Oracle's standard EMP table, which contains employee fields such as EMPNO, ENAME, JOB, and SAL.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Oracle PL/SQL: How Pipelined Table Functions Outperform Regular Ones

Oracle PL/SQL offers two types of table functions — regular and pipelined — both capable of returning collections queryable directly in SQL FROM clauses. Regular table functions load the entire result set into PGA memory before returning data, leading to higher memory usage and slower time-to-first-row, making them suitable mainly for small datasets. Pipelined functions, by contrast, stream rows incrementally to the caller using the PIPE ROW construct, significantly reducing memory overhead and improving responsiveness for large ETL or real-time data operations. A key syntax rule requires that the RETURN statement in a pipelined function remain empty — passing a variable causes a PLS-00633 compilation error. Additionally, the TABLE() wrapper mandatory in Oracle 11g and earlier became optional from Oracle Database 12c Release 2 onward.

0 comments Read more at DEV Community

ProgrammingDEV Community ·

Oracle PL/SQL: Key Differences Between CASE Expression and CASE Statement

In Oracle PL/SQL, the CASE Expression and CASE Statement serve distinct purposes despite sharing similar syntax. A CASE Expression evaluates a condition and returns a single scalar value, making it suitable for assignments or inline SQL use, while a CASE Statement executes one or more procedural actions based on conditions. Their termination syntax also differs: CASE Statements close with END CASE; whereas CASE Expressions end with END. A critical behavioral difference involves unhandled cases — a CASE Statement with no matching WHEN clause and no ELSE raises a runtime ORA-06592 exception, while a CASE Expression silently returns NULL under the same circumstances. Developers should account for these distinctions to avoid unexpected runtime errors in production PL/SQL code.

0 comments Read more at DEV Community

ProgrammingHacker News ·

Over a Quarter of Company Job Postings Remain Open Beyond 90 Days

A report from Unlisted Careers reveals that 28% of job postings on company career sites have remained open for more than 90 days. These long-standing listings are often referred to as 'ghost jobs,' roles that may not reflect active or genuine hiring intent. The phenomenon can mislead job seekers into investing time and effort applying for positions that may already be filled or frozen. The findings raise concerns about transparency in corporate recruiting practices. The report was published in September 2026 based on data gathered from company career pages.

0 comments Read more at Hacker News