{"id":1001,"date":"2008-09-03T11:54:35","date_gmt":"2008-09-03T16:54:35","guid":{"rendered":"http:\/\/www.bytebot.net\/blog\/?p=1001"},"modified":"2008-09-03T11:56:52","modified_gmt":"2008-09-03T16:56:52","slug":"point-of-sale-systems-and-their-back-ends","status":"publish","type":"post","link":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends","title":{"rendered":"Point of Sale systems, and their back-ends"},"content":{"rendered":"<p><a href=\"http:\/\/www.oldtown.com.my\/\">Old Town White Coffee<\/a> is a place we&#8217;ve been hanging out a lot at. Its got wifi, power sockets, couches, good food and drink, great eye candy (bonus!), and is open till late.<\/p>\n<p>Today, we found out that all their PCs that hold the orders (order{1,2,3,4}) have Samba shares. Open to all, naturally. <\/p>\n<p>They use Crystal Reports. Have a custom front-end, with appropriate touch screen drivers, but the back-end is pretty stock. They use MySQL, Connector\/ODBC 3.51.12 and also use SQLyog 5.30. I know the system is designed and deployed by NIT, it looks like their <a href=\"http:\/\/www.nit.com.my\/f&#038;bpos.asp\">F&#038;B POS<\/a>.<\/p>\n<p>Their use of MySQL (schema wise), includes using VIEWs, stored procedures and triggers (on UPDATE and DELETE).<\/p>\n<p>I wonder how many point of sales systems are powered by open source software. This one runs Windows, but at least within the stack, there&#8217;s open source MySQL!<\/p>\n<p>P\/S: if you&#8217;re from NIT or Old Town, secure your order systems.<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Point%20of%20Sale%20systems%2C%20and%20their%20back-ends&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F09%2F03%2Fpoint-of-sale-systems-and-their-back-ends&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"86f7be0ba1\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1001\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1001\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1001\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"excerpt":{"rendered":"<p>Old Town White Coffee is a place we&#8217;ve been hanging out a lot at. Its got wifi, power sockets, couches, good food and drink, great eye candy (bonus!), and is open till late. Today, we found out that all their PCs that hold the orders (order{1,2,3,4}) have Samba shares. Open to all, naturally. They use [&hellip;]<\/p>\n<div class=\"sharedaddy sd-sharing-enabled\"><div class=\"robots-nocontent sd-block sd-social sd-social-icon-text sd-sharing\"><h3 class=\"sd-title\">Share this:<\/h3><div class=\"sd-content\"><ul><li class=\"share-email\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"\" class=\"share-email sd-button share-icon\" href=\"mailto:?subject=%5BShared%20Post%5D%20Point%20of%20Sale%20systems%2C%20and%20their%20back-ends&body=http%3A%2F%2Fwww.bytebot.net%2Fblog%2Farchives%2F2008%2F09%2F03%2Fpoint-of-sale-systems-and-their-back-ends&share=email\" target=\"_blank\" title=\"Click to email a link to a friend\" data-email-share-error-title=\"Do you have email set up?\" data-email-share-error-text=\"If you&#039;re having problems sharing via email, you might not have email set up for your browser. You may need to create a new email yourself.\" data-email-share-nonce=\"86f7be0ba1\" data-email-share-track-url=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=email\"><span>Email<\/span><\/a><\/li><li class=\"share-facebook\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-facebook-1001\" class=\"share-facebook sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=facebook\" target=\"_blank\" title=\"Click to share on Facebook\" ><span>Facebook<\/span><\/a><\/li><li class=\"share-linkedin\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-linkedin-1001\" class=\"share-linkedin sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=linkedin\" target=\"_blank\" title=\"Click to share on LinkedIn\" ><span>LinkedIn<\/span><\/a><\/li><li class=\"share-twitter\"><a rel=\"nofollow noopener noreferrer\" data-shared=\"sharing-twitter-1001\" class=\"share-twitter sd-button share-icon\" href=\"http:\/\/www.bytebot.net\/blog\/archives\/2008\/09\/03\/point-of-sale-systems-and-their-back-ends?share=twitter\" target=\"_blank\" title=\"Click to share on Twitter\" ><span>Twitter<\/span><\/a><\/li><li class=\"share-end\"><\/li><\/ul><\/div><\/div><\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"jetpack_post_was_ever_published":false,"jetpack_publicize_message":"","jetpack_is_tweetstorm":false,"jetpack_publicize_feature_enabled":true,"jetpack_social_options":[]},"categories":[23],"tags":[1775,454,453,452,451],"jetpack_publicize_connections":[],"jetpack_featured_media_url":"","jetpack_shortlink":"https:\/\/wp.me\/p4vJD-g9","jetpack_sharing_enabled":true,"jetpack-related-posts":[{"id":529,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/04\/24\/myodbc-not-showing-in-drivers-list-on-mac-os-x","url_meta":{"origin":1001,"position":0},"title":"MyODBC not showing in drivers list on Mac OS X","date":"24\/4\/2007","format":false,"excerpt":"Today I missed a bunch of good talks that I was hoping to attend, because I was figuring out a problem at the Guru Bar. Offending criminal: MySQL Connector\/ODBC 3.51. Offending OS: Mac OS X\/PowerPC. OS X comes with an ODBC Administrator. Once you unpack the MySQL package, and the\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1214,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/12\/12\/mysql-in-a-small-town-cafe","url_meta":{"origin":1001,"position":1},"title":"MySQL in a small town cafe","date":"12\/12\/2008","format":false,"excerpt":"Via Ditesh: Interesting aside: the bus stopped in a ${RANDOM} town in Johor for food, and at the cashier, I spotted the cashier using KC POS which had a prominent \u201cPowered by MySQL\u201d text and the Sakila logo. Very cool! This was a small town coffee shop, using a cash\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":3296,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2016\/12\/01\/debian-and-mariadb-server","url_meta":{"origin":1001,"position":2},"title":"Debian and MariaDB Server","date":"1\/12\/2016","format":false,"excerpt":"GNU\/Linux distributions matter, and Debian is one of the most popular ones out there in terms of user base. Its an interesting time as MariaDB Server becomes more divergent compared to upstream MySQL, and people go about choosing default providers of the database. The MariaDB Server original goals were to\u2026","rel":"","context":"In &quot;Distributions&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":534,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2007\/04\/25\/a-storage-engine-for-amazon-s3","url_meta":{"origin":1001,"position":3},"title":"A Storage Engine for Amazon S3","date":"25\/4\/2007","format":false,"excerpt":"A Storage Engine for Amazon S3, Mark Atwood It looks mighty interesting, as transfers to Amazon S3 are free. I think it'll work well in America and places where bandwidth rocks, but I don't see this working too well in Australia. Oh how I wish the Internets will improve. Mark\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":705,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2008\/01\/28\/mysql-miniconf-starts","url_meta":{"origin":1001,"position":4},"title":"MySQL Miniconf Starts!","date":"28\/1\/2008","format":false,"excerpt":"Arjen and Stewart are on stage, and there's an introduction session going on now. We're now, introducing the ex-MySQLers (Arjen), and MySQLers (Stewart, Giuseppe, me). Trent has just walked in, so that makes all the MySQLers that are around at linux.conf.au.Highlights of some of the attendees:A user from LG, who\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":2292,"url":"http:\/\/www.bytebot.net\/blog\/archives\/2012\/02\/05\/mysql-creatively-in-a-sandbox-by-giuseppe-maxia","url_meta":{"origin":1001,"position":5},"title":"MySQL Creatively in a Sandbox by Giuseppe Maxia","date":"5\/2\/2012","format":false,"excerpt":"Giuseppe Maxia of Continuent and long time creator of MySQL Sandbox. Only works on Unix-like servers. Works with MySQL, Percona & MariaDB servers. MySQL server has the data directory, the port and the socket - you can't share these. To use it: make_sandbox foo.tar.gz. Then just do .\/use. $SANDBOX_HOME is\u2026","rel":"","context":"In &quot;MySQL&quot;","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"amp_enabled":true,"_links":{"self":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1001"}],"collection":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/comments?post=1001"}],"version-history":[{"count":3,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1001\/revisions"}],"predecessor-version":[{"id":1004,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/posts\/1001\/revisions\/1004"}],"wp:attachment":[{"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/media?parent=1001"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/categories?post=1001"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.bytebot.net\/blog\/wp-json\/wp\/v2\/tags?post=1001"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}