# |
May 29th 2016, 10:38 |
ionas |
I think MS is porting it to linux |
# |
May 29th 2016, 10:38 |
ionas |
hehe |
# |
May 29th 2016, 10:38 |
dakota |
sql server means windows which means iis |
# |
May 29th 2016, 10:38 |
dakota |
purely because youâ??ve then zero choice in anything else :slightly_smiling_face: |
# |
May 29th 2016, 10:38 |
ionas |
wonâ??t - not floss, I am out. |
# |
May 29th 2016, 10:38 |
dakota |
Donâ??t pick sql server |
# |
May 29th 2016, 10:36 |
ionas |
but now I have a solution anyway I hope |
# |
May 29th 2016, 10:35 |
ionas |
markstory well Iâ??d not pick sql server â??just because ofâ? binary file streams |
# |
May 29th 2016, 10:16 |
marlinc |
Hey ChrisSME |
# |
May 29th 2016, 10:14 |
johan |
something I used in the past was GlusterFS, but that was also when I was managing the storage cluster and related servers myself, on bare metal. my understanding is that CEPH is an alternative to that. |
# |
May 29th 2016, 10:13 |
markstory |
I've never used sqlserver filestream |
# |
May 29th 2016, 10:13 |
dakota |
No, FileStream (https://technet.microsoft.com/en-us/library/bb933993(v=sql.105).aspx) |
# |
May 29th 2016, 10:12 |
ionas |
dakota you mean sql server binary stream? |
# |
May 29th 2016, 10:12 |
dakota |
but you access it as if it was a db blob |
# |
May 29th 2016, 10:12 |
dakota |
The actual binary is stored on disk (or s3, etc.) |
# |
May 29th 2016, 10:11 |
ionas |
and thus should not be inâ?¦ say webroot/uploads |
# |
May 29th 2016, 10:11 |
ionas |
however the basic idea that the talk exposed is: code=stateless, data=instance/stateful |
# |
May 29th 2016, 10:11 |
ionas |
sure johan its not â??good ideaâ? unless there is binary streams like sql server has it |
# |
May 29th 2016, 10:11 |
dakota |
thatâ??s what I like about FileStream. Itâ??s DB blobs but not |
# |
May 29th 2016, 10:09 |
marlinc |
In that case you might be better of using something like Swift (OpenStack) or S3 I guess? |
# |
May 29th 2016, 10:09 |
markstory |
backups get harder. |
# |
May 29th 2016, 10:08 |
markstory |
Hard to but a CDN around blobs in the db. |
# |
May 29th 2016, 10:08 |
markstory |
blobs in the database are a bad idea imo. |
# |
May 29th 2016, 10:06 |
dakota |
I think SQL server did it right with File Stream |
# |
May 29th 2016, 10:01 |
johan |
everything is a trade-off :slightly_smiling_face: |
# |
May 29th 2016, 10:01 |
johan |
one obvious disadvantage to storing tons of binary data in SQL is backup and recovery becomes a little more interesting |
# |
May 29th 2016, 09:59 |
ionas |
is that a good idea? |
# |
May 29th 2016, 09:59 |
ionas |
I mean I always considered storing binary into sql, and he points out why but now I think about storing whatever â??user imagesâ? into redis or whatever |
# |
May 29th 2016, 09:58 |
ionas |
this talk is great |
# |
May 29th 2016, 09:57 |
marlinc |
https://twitter.com/dakotairene/status/736855039399079936 :P |
# |
May 29th 2016, 09:53 |
birdy247 |
gossip etc.. ;) |
# |
May 29th 2016, 09:53 |
birdy247 |
any cakefest updates ? |
# |
May 29th 2016, 09:47 |
ionas |
at least that makes it possible that I hire Varoufakis |
# |
May 29th 2016, 09:47 |
ionas |
ACTION cries. |
# |
May 29th 2016, 09:47 |
ionas |
I am a gabe lookalike |
# |
May 29th 2016, 09:46 |
marlinc |
http://orig08.deviantart.net/9f15/f/2013/009/f/a/gabe_newell__the_hero_of_us_all_by_radulfgreyhammer-d5r0ecr.jpg |
# |
May 29th 2016, 09:46 |
ionas |
http://vignette4.wikia.nocookie.net/half-life/images/2/2b/Gordon_bust_rtb2.jpg/revision/latest?cb=20100622090108andpath-prefix=en *sigh* |
# |
May 29th 2016, 09:46 |
ionas |
the one to the right https://www.google.nl/search?q=half+life+heroandclient=firefox-bandsource=lnmsandtbm=ischandsa=Xandved=0ahUKEwi-1PeR_f7MAhVJrRoKHU2RAwYQ_AUIBygB |
# |
May 29th 2016, 09:46 |
ionas |
ACTION suicides |
# |
May 29th 2016, 09:46 |
ionas |
omg |
# |
May 29th 2016, 09:46 |
ionas |
k3+H4jzjQeuKEIDl7p9b1ZZFTiq1x/LtO/6sP1cEIU+T9Krx/vFhKeAQhebk9PF2xukKS3DTAm+/khCztUltwLTx6yufwTQCSTbW30QhSaPWwxGvCfHRRarYQhVKSO5cU/iHUfNCFpGbYdphOHrf/GT5SsXizDj1/VCF1/5f1ri8/cMO0lIQBPH69yELpYu3GyaqxoeSEICLjiAI7/sojWShCDdexOqXZSIQH//Z |