GitHub

Microsoft.Data.Sqlite: Streaming of Blobs out of sqlite not working (as expected)

I try to stream from/to sqlite Blobs. I've read the examples here (https://docs.microsoft.com/de-de/dotnet/standard/data/sqlite/blob-io). Streaming to a sqlite DB ...
GitHub

水平分割したテーブルの利用方法

Doma では、データ分散のためにテーブルを水平分割するにはどのような Dao を作ればよいでしょうか。 例えば、1 つのテーブルを同じスキーマのまま books_p1, books_p2, ... books_pX と作っていき ...
Ars Technica

Powershell. SQL Query. How to determine if a query returns no results?

I’ve created a script that monitors a table in a SQL Server database. I’m only interested in one column in the table: TimeStamp. If the maximum (newest) value in TimeStamp is more than 30 minutes ...
Redmond Pie

Inserting and Retrieving images from SQL Server Database using C#

I think storing images in a database can save a developer loads of time and can ease his life while dealing with visuals, either creating a local application or a web application. Think of storing ...