From: Mike Gilbert <floppym@gentoo.org>
To: gentoo-user@lists.gentoo.org
Subject: Re: [gentoo-user] SQL Server Advice for Small Business
Date: Mon, 29 Jul 2013 16:58:16 -0400 [thread overview]
Message-ID: <CAJ0EP406AXzf7eDG4yjzW+SV9S0-hsVFX_kKgXLKue+n-_Ncmw@mail.gmail.com> (raw)
In-Reply-To: <20130729202238.GA23113@artifex>
On Mon, Jul 29, 2013 at 4:22 PM, Randy Westlund <rwestlun@gmail.com> wrote:
> Hey guys,
>
> I'm planning to set up an SQL server for my dad's small canvas awning business, and I've never done this before. Most of my sysadmin-type skills are self-taught. I could use some advice.
>
Heh, based on the capitalized subject line I was going to ask why you
were asking about Microsoft SQL Server on this list. ;-)
> Table structure:
>
> I'm diving into database design and normalization rules now. I'll need to store binary files (pictures of job site, scanned documents), and am currently planning on base64 encoding them (or something similar) and storing them in the database to keep it ACID compliant.
If you really want to store binary data in the database, use a binary
(BLOB) data type. Base64 will increase their size significantly.
next prev parent reply other threads:[~2013-07-29 20:58 UTC|newest]
Thread overview: 10+ messages / expand[flat|nested] mbox.gz Atom feed top
2013-07-29 20:22 [gentoo-user] SQL Server Advice for Small Business Randy Westlund
2013-07-29 20:58 ` Mike Gilbert [this message]
2013-07-30 5:52 ` J. Roeleveld
2013-07-30 21:34 ` Randy Westlund
2013-07-31 6:00 ` J. Roeleveld
2013-07-31 8:48 ` Michael Hampicke
2013-07-31 17:39 ` Andrew Lowe
2013-07-30 10:31 ` microcai
2013-07-30 13:35 ` Mick
2013-07-30 17:50 ` Bruce Hill
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
Avoid top-posting and favor interleaved quoting:
https://en.wikipedia.org/wiki/Posting_style#Interleaved_style
* Reply using the --to, --cc, and --in-reply-to
switches of git-send-email(1):
git send-email \
--in-reply-to=CAJ0EP406AXzf7eDG4yjzW+SV9S0-hsVFX_kKgXLKue+n-_Ncmw@mail.gmail.com \
--to=floppym@gentoo.org \
--cc=gentoo-user@lists.gentoo.org \
/path/to/YOUR_REPLY
https://kernel.org/pub/software/scm/git/docs/git-send-email.html
* If your mail client supports setting the In-Reply-To header
via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line
before the message body.
This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox