# |
May 29th 2016, 10:40 |
ionas |
I cannot find experts that help me once I â??scaleâ? for good prices â?¦ and/or cannot look at the source (is it shared?) fix things etcâ?¦ its just not nice |
# |
May 29th 2016, 10:40 |
dakota |
Doesnâ??t bug me |
# |
May 29th 2016, 10:39 |
ionas |
maybe but no floss, no pick :p |
# |
May 29th 2016, 10:39 |
dakota |
sql server is fantastic |
# |
May 29th 2016, 10:39 |
ionas |
mariadb and postgres is <3 :) |
# |
May 29th 2016, 10:39 |
dakota |
linux driver is in alpha |
# |
May 29th 2016, 10:38 |
ionas |
however Iâ??d still not. |
# |
May 29th 2016, 10:38 |
dakota |
soon though |
# |
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 |