شروع به کار با SignalR Core
نصب pgadmin در سیستم عامل ubuntu
How to Install pgAdmin4 on Ubuntu 20.04/18.04/16.04?. This post has been written primarily to guide new users on installing pgAdmin 4 on Ubuntu 20.04/18.04/16.04. pgAdmin is a feature-rich and open source PostgreSQL administration and development platform that runs on Linux, Unix, Mac OS X, and Windows.
With pgAdmin you can manage PostgreSQL database servers, from version 9.2 using an intuitive and powerful web interface. We have guides on installing pgAdmin 4 on other platforms.
گذری بر مفاهیم relationship
برای این منظور باید از recursive cte کمک گرفت.
فرض کنید درختی به شکل زیر داریم:
/* A / \ B C | /|\ D E F G | H */
و هدف بدست آوردن تمام زیر شاختههای گره A است.
ابتدا باید تمام گره هایی که مقدار گره پدرشان برابر با A است را بدست بیاریم یعنی گرههای B و C
حالا باید تمام گره هایی که گره پدرشان B و یا C است را بدست بیاریم یعنی گرههای D E F G
و در مرحله بعد باید تمام گره هایی را بدست بیاریم که گره پدرشان برابر با یکی از مقادیر بدست آمده در مرحله قبل (یعنی D E F G) یعنی H
این الگوریتم را توسط Recursive CTE پیاده میکنیم:
declare @t table ( id char(1) primary key not null, pid char(1) null --references @t ); insert @t values ('A', null), ('B','A'),('C','A'), ('D','B'), ('H','D'),('E','C'),('F','C'),('G','C'); with cte as ( select id from @t where pid = 'A' union all select t.id from cte c join @t t on t.pid = c.id ) select * from cte
موفق باشید
dotnet publish -r win10-x64 /p:PublishSingleFile=true
With ReadyToRun images | IL-only Application |
Startup time: 1.3 seconds | Startup time: 1.9 seconds |
Memory usage: 55.7 MB | Memory usage: 69.1 MB |
Application size: 156 MB | Application size: 150 MB |
<PublishReadyToRun>true</PublishReadyToRun>
dotnet publish -r win-x64 -c Release
<PublishTrimmed>true</PublishTrimmed>
dotnet publish -r win-x64 -c Release
In the last post, I looked at auto-property enhancements, with several comments pointing out some nicer usages. I recently went through the HtmlTags codebase, C# 6-ifying “all the things”, and auto property and expression bodied function members were used pretty much everywhere. This is a large result of the codebase being quite tightly defined, with small objects and methods doing one thing well.
NetSqlAzMan
- NetSqlAzMan allows you to change User Authorizations without recompile your application !
- NetSqlAzMan supports AOP (Aspect Oriented Programming
SQLite compiled to javascript
For the impatients, try the demo here: http://kripken.github.io/sql.js/examples/GUI
sql.js is a port of SQLite to Webassembly, by compiling the SQLite C code with Emscripten. It uses a virtual database file stored in memory, and thus doesn't persist the changes made to the database. However, it allows you to import any existing sqlite file, and to export the created database as a javascript typed array.