Microwave transmission by Ciro Santilli 37 Updated +Created
lujakob/nestjs-realworld-example-app SQLite port by Ciro Santilli 37 Updated +Created
Tried a quick port to SQLite to get rid of annoying local databases for development, but failed, at c1c2cc4e448b279ff083272df1ac50d20c3304fa
npm install sqlite3 --save-dev
and
{
  "type": "sqlite",
  "database": "db.sqlite3",
  "entities": ["src/**/**.entity{.ts,.js}"],
  "synchronize": true
}
then:
npm start
fails with:
DataTypeNotSupportedError: Data type "timestamp" in "ArticleEntity.created" is not supported by "sqlite" database.
Attempt to hack it:
--- a/src/article/article.entity.ts
+++ b/src/article/article.entity.ts
@@ -20,10 +20,10 @@ export class ArticleEntity {
   @Column({default: ''})
   body: string;

-  @Column({ type: 'timestamp', default: () => "CURRENT_TIMESTAMP"})
+  @Column({ default: () => "CURRENT_TIMESTAMP"})
   created: Date;

-  @Column({ type: 'timestamp', default: () => "CURRENT_TIMESTAMP"})
+  @Column({ default: () => "CURRENT_TIMESTAMP"})
   updated: Date;
and after that it seems to run.
I can signup and login, terrible error reporting as usual, make sure to use long enough usernames/passwords.
However, article creation fails with:
Unhandled Rejection (TypeError): Cannot read property 'slug' of undefined
Fluorescent lamp by Ciro Santilli 37 Updated +Created
ELF Hello World Tutorial / SHN_ABS by Ciro Santilli 37 Updated +Created
hello_world_len points to the special st_shndx == SHN_ABS == 0xF1FF.
0xF1FF is chosen so as to not conflict with other sections.
st_value == 0xD == 13 which is the value we have stored there on the assembly: the length of the string Hello World!.
This means that relocation will not affect this value: it is a constant.
This is small optimization that our assembler does for us and which has ELF support.
If we had used the address of hello_world_len anywhere, the assembler would not have been able to mark it as SHN_ABS, and the linker would have extra relocation work on it later.
Mineralogy by Ciro Santilli 37 Updated +Created
Pi bond by Ciro Santilli 37 Updated +Created
WormAtlas by Ciro Santilli 37 Updated +Created
A collection of closely related and curated C. elegans datasets.
Vertebrate subclade by Ciro Santilli 37 Updated +Created
Ubuntu 22.04 by Ciro Santilli 37 Updated +Created
SQLite isolation levels by Ciro Santilli 37 Updated +Created
The default isolation level for SQLite is SERIALIZABLE
It does not appear possible to achieve the other two levels besides SERIALIZABLE and READ UNCOMMITED
SQL SERIALIZABLE isolation level by Ciro Santilli 37 Updated +Created
NuNET by Ciro Santilli 37 Updated +Created
SARS-CoV-2 Nsp5 by Ciro Santilli 37 Updated +Created
Protease that cuts up ORF1ab. Note that it is also present in ORF1ab.
Raspberry Pi Pico H by Ciro Santilli 37 Updated +Created
Has Serial wire debug debug. Why would you ever get one without unless you are a clueless newbie like Ciro Santilli?!?!
Quantum field theory lecture by Tobias Osborne (2017) / Lecture 3 by Ciro Santilli 37 Updated +Created

Unlisted articles are being shown, click here to show only listed articles.