|
Are there and drivers for Windows that can use a SQL Server database as a file system?
The Sharp Ninja
|
|
|
|
|
|
Is that the same "FS" that is found in "FFS"?
|
|
|
|
|
|
Close. It's the same FS that is found in F2FS. 
Freedom is the freedom to say that two plus two make four. If that is granted, all else follows.
-- 6079 Smith W.
|
|
|
|
|
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.
|
|
|
|
|
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.
|
|
|
|
|
|
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.
"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!
|
|
|
|
|
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.
|
|
|
|
|
Yup, in multiple tastes.
You could use filestreams and access them like a FileSystem; needs a Windows share name and some configuration. See https://www.sqlshack.com/filestream-in-sql-server/[^] Easy to set up, and nice to have if you have a lot of blobs in your db, like images.
Alternative, you could look at the Dokan libraries; my article on it is outdated, but there was an open source interface to SQL Server. Dokan at the time was limited to roughly 50MB/s.
Last option might be FUSE, using Sql Server. See FUSE(file system in userspace) for Microsoft-SQL using C#[^].
Enjoy
Bastard Programmer from Hell 
If you can't read my code, try converting it here[^]
"If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.
|
|
|
|
|
This is the response I was looking for! Going to definitely check these out.
|
|
|
|
|
|
A question in Spanish. Now that is unusual in the Lounge.
/edit : tengas que preguntar ahi[^].
|
|
|
|
|
|
Two things:
1) This is an English language site, and we can only answer questions in that language. Use Google translate if your English isn't up to the task - it does a pretty good job of it!
Google Translate: 1) Este es un sitio de idioma inglés, y solo podemos responder preguntas en ese idioma. Use el traductor de Google si su inglés no está a la altura de la tarea, ¡lo hace muy bien!
2) This is the wrong place to post this, as it says at the top of the page. Posting programming questions here (in any language) will not get you much help, but may get you flamed. Post here instead:
Google Translate: 2) Este es el lugar equivocado para publicar esto, como dice en la parte superior de la página. Publicar preguntas de programación aquí (en cualquier idioma) no le dará mucha ayuda, pero puede incomodarlo. Publica aquí en su lugar:
Ask a question[^]
"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!
|
|
|
|
|
OriginalGriff wrote: will not get you much help, but may get you flamed. Google said: no le dará mucha ayuda, pero puede incomodarlo.
 I didn't know Google translator was that politically correct. 
M.D.V. 
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
I have to assume it knows what it's doing.
It knows everything else - just like my wife, really.
"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!
|
|
|
|
|
In this case it translated it as:
it might bother you
M.D.V.
If something has a solution... Why do we have to worry about?. If it has no solution... For what reason do we have to worry about?
Help me to understand what I'm saying, and I'll explain it better to you
Rating helpful answers is nice, but saying thanks can be even nicer.
|
|
|
|
|
OriginalGriff wrote: Use Google translate if your English isn't up to the task - it does a pretty good job of it!
Sure about it? 
cheers,
Super
------------------------------------------
Too much of good is bad,mix some evil in it
|
|
|
|
|
Sure - Griff speaks welsh and has been translating it to English using Google all these years.
|
|
|
|
|
Rage wrote: Griff speaks welsh sheep
FTFY
|
|
|
|
|
Sorry, I didn't know it was an English portal
|
|
|
|
|
Board meeting at mate's event? (5, 10)
"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!
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
