Welcome to the Lounge

13-Jul-20 4:37

If doing your crossword is making you depressed, should you try not to get 2 Down?

"I have no idea what I did, but I'm taking full credit for it." - ThisOldTony
"Common sense is so rare these days, it should be classified as a super power" - Random T-shirt
AntiTwitter: @DalekDave is now a follower!

Mike Hankey13-Jul-20 4:41

Mike Hankey

13-Jul-20 4:41

or 2 across

I'm not sure how many cookies it makes to be happy, but so far it's not 27.

JaxCoder.com

honey the codewitch13-Jul-20 5:34

honey the codewitch

13-Jul-20 5:34

this joke made me cross. Mad | :mad:

Real programmers use butterflies

OriginalGriff13-Jul-20 5:45

13-Jul-20 5:45

You're being cryptic again ...

honey the codewitch13-Jul-20 5:55

honey the codewitch

13-Jul-20 5:55

i was just making a worse pun about a bad pun. don't mind me, i didn't even remove my coat.

Real programmers use butterflies

OriginalGriff13-Jul-20 6:01

13-Jul-20 6:01

Explaining jokes ...

"Cryptic" as in "CCC" - "Cryptic Crossword Clue" ...

Daniel Pfeffer13-Jul-20 5:45

Daniel Pfeffer

13-Jul-20 5:45

Get a clue!

Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.

ZurdoDev13-Jul-20 6:05

ZurdoDev

13-Jul-20 6:05

OriginalGriff wrote:
should you try not to get 2 Down?

I can't figure out 2 down until I get 9 across. I'm stuck. Mad | :mad:

Social Media - A platform that makes it easier for the crazies to find each other.

Everyone is born right handed. Only the strongest overcome it.
Fight for left-handed rights and hand equality.

Use SQL Server database as Windows file system

pkfox13-Jul-20 10:40

pkfox

13-Jul-20 10:40

Not too bad for you Big Grin | :-D

"We can't stop here - this is bat country" - Hunter S Thompson - RIP

Sharp Ninja13-Jul-20 2:23

Sharp Ninja

13-Jul-20 2:23

Are there and drivers for Windows that can use a SQL Server database as a file system?

The Sharp Ninja

g_p_l13-Jul-20 2:45

g_p_l

13-Jul-20 2:45

That sounds a lot like this WinFS - Wikipedia[^]

musefan13-Jul-20 2:49

musefan

13-Jul-20 2:49

Is that the same "FS" that is found in "FFS"?

g_p_l13-Jul-20 2:56

g_p_l

13-Jul-20 2:56

surely FES ?

Daniel Pfeffer13-Jul-20 2:58

Daniel Pfeffer

13-Jul-20 2:58

Close. It's the same FS that is found in F2FS. Smile | :)

Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.

Daniel Pfeffer13-Jul-20 2:56

Daniel Pfeffer

13-Jul-20 2:56

There is no reason why you couldn't store files as "blobs" in an SQL Server database, and use additional tables to add attributes to the "blobs". This would give you some of the WinFS capabilities, at a much lower cost.

Another way would be to store only the pathnames (rather than the "blobs") for each file. This would allow access by standard file APIs in addition to the API provided by your database, and may be useful for backward compatibility. One problem that arises here is synchronization - ensuring that new files are added to the database, and that deleted files are removed from the database.

Either way, you would have to write your own file access API - Windows provides no support for accessing files via anything but their pathnames (and directories).

Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.

musefan13-Jul-20 3:32

musefan

13-Jul-20 3:32

If they are large(ish) blobs you can use Filestream, which is a kind of a "best of both".

Although I only used it once as a prototype, never has a real use-case for it, so not sure what the downsides are.

PIEBALDconsult13-Jul-20 3:39

PIEBALDconsult

13-Jul-20 3:39

Roll your own.

OriginalGriff13-Jul-20 3:42

13-Jul-20 3:42

I'd suspect it would be a pretty low performance file system - it's going to hammer the bandwidth as soon as files get big, or many users access them - and it is guaranteed to be slower than the equivalent local storage.

Storage is cheap at the moment - you can get internal 1TB SSD drive for under £100 - so I'd be tempted to set up a file server instead; relatively low processor requirements (compared to SQL) and full SMB shares from Windows or Linux boxes.
Or buy a NAS ready loaded.

Roland M Smith13-Jul-20 5:08

Roland M Smith

13-Jul-20 5:08

You could store them as standard files but maintain a database that had the file location and information about the file. A Windows Service app could process file system change notifications to keep the database updated.