MySQL Database Management System
We had a few choices when it came to database management systems — well, really, only two. We chose MySQL over MS SQL Server for a few reasons.
- It’s scalable — Whether it’s one computer or 20 computers MySQL Server can handle it.
- It’s reliable — Transaction-based database writes for atomical and precise data.
- It’s lightweight — You need a SQL-based RDBMS, but it doesn’t have to be such a resource hog that it consumes your entire system.
- It’s easy to administrate — Open source and the most popular database management system on the planet. Ask around, technophiles will be happy to hear we chose MySQL Server over Microsoft SQL Server.
- It’s compatible — There’s nothing stopping you from running MySQL on your own Linux-based server, or even your own off-site, hosted server if you’re so inclined. Have at it!
MySQL Server provides the best in reliability, compatibility, and performance. MySQL also supports Parameterized Queries, which all queries in Consignment Anywhere are fully parameterized.
.NET Code Base
Consignment Anywhere is written in VB.NET. .NET is a modern code base, which provides a current programming platform, ready to handle the requirements of modern technology.
- Modern — .NET is a modern language, which means simple things such as sending email, aren’t trapped in the 90s.
- Flexible — .NET provides a flexible framework, which allows us to handle virtually any requirement thrown our way.
- Reliable — With .NET being as ubiquitous as it is, it ensures a level of reliability required in a code-base.
- Compatible — .NET runs on virtually every version of Windows, so whether you’re running Windows Vista (we don’t recommend doing so) or Windows 10, .NET is compatible.
.NET provides a modern, accessible code-base, which ensures our software is capable of addressing consignment store owners’ needs. Furthermore, Consignment Anywhere was designed with proper Exception Handling and Form Validation.
- Computers — Consignment Anywhere runs on Windows-based computers. We’re compatible with virtually any modern, Windows-based system, from Windows Vista, to Windows 10. I know, I know — you have a Mac and want to use it, which, technically, you can do! We’re realists though and we understand the many layers of technology which comprise a consignment store’s infrastructure. Printers specifically, are typically geared toward Windows systems, so for your tag + receipt printers alone, we’d recommend sticking with native Windows systems.
- Tag Printers — We are officially compatible with the following tag printers:
- Zebra LP2844
- Zebra CP450
- TSC TDP-247/-245
- If you have a Zebra LP2824 (the ‘narrow’ printers), they work too, but they tend to be, well, cheaper printers and we just don’t recommend them.
No matter which thermal tag printer you own, we can likely get it to work — and there’s no charge for Consignment Anywhere customers! We have 13 years of experience with tag printers and we’ll exhaust all efforts to make your existing hardware work.
- Tags/Labels — Consignment Anywhere is compatible with all of the direct thermal tags and labels available at Forms Plus.
- Receipt Printers — We recommend Citizen thermal receipt printers, but are also compatible with Star receipt printers.
- Barcode Readers/Scanners — If it can scan 1D barcodes, specifically, Code 128 barcodes, it will work with Consignment Anywhere.
- Cash Drawers — These are dependent on your receipt printer + the unique cable utilized to connect them to your receipt printer.
- Pole Displays — These are soooo 90s. 😀 Consignment Anywhere can utilize a full-color, customer-facing display. For stores that purchase a server/main license + two workstation licenses, we’ll include one at no additional charge. 🙂
Forget consignment software for a second — let’s get right to it. A modern Windows computer should have the following:
- A minimum of 4 GB of RAM for workstations, 8 GB of RAM for servers or *heavy-use* workstations.
- An Intel-based processor — An i3 is more than enough for most scenarios.
- An Intel or My Digital SSD — Trust us, you’ll thank yourself for only utilizing SSDs.
- Get a managed (has a USB port) CyberPower battery backup — do it! 😀
For point of sale or inventory/intake workstations, an Intel Celeron is just fine, as long as you have an SSD. For manager’s workstations, ‘server’ computers, or stations where you’re running QuickBooks, editing images, etc. stick with an i3 processor. If you have 10 workstations, we’d say go ahead and make the leap to an i5 or i7 in your server PC. Will you suffer with an i3? Likely not, but a system with 10 workstations means larger backups and lots of other *stuff* that starts to add up @ resource usage.