TrustRadius: an HG Insights company

Save this comparison

Save this comparison

Add Product

Recommended Comparisons

    Overview
    ProductRatingMost Used ByProduct SummaryStarting Price

    Lightspeed Retail

    Score9.2 out of 10
    N/ALightspeed Retail is a retail PoS system from Lightspeed headquartered in Quebec. Core retail POS features are expanded on higher service tiers with ecommerce option and payments gateway, an accounting system, and a customer loyalty program.N/A

    MySQL

    Score8.4 out of 10
    N/AMySQL is a popular open-source relational and embedded database, now owned by Oracle.N/A
    Pricing
    Lightspeed RetailMySQL
    Editions & Modules
    Basic
    $79.00 ($69.00)
    per month (when billed annually)
    Starter
    $119.00 ($99.00)
    per month (when billed annually)
    Standard
    $139.00 ($119.00)
    per month (when billed annually)
    Advanced
    $189.00 ($169.00)
    per month (when billed annually)
    Pro
    $259.00 ($229.00)
    per month (when billed annually)
    Enterprise
    Contact Sales
    No answers on this topic
    Offerings
    Pricing Offerings
    Lightspeed RetailMySQL
    Free Trial
    NoNo
    Free/Freemium Version
    NoNo
    Premium Consulting/Integration Services
    NoNo
    Entry-level Setup FeeNo setup feeNo setup fee
    Additional Details——
    More Pricing Information
    Community Pulse
    Lightspeed RetailMySQL
    Considered Both Products
    Lightspeed
    No answer on this topic
    Oracle
    No answer on this topic
    Key User Insights
    Would buy again
    60%
    Would buy again
    6 Answers
    94%
    Would buy again
    49 Answers
    Delivers good value for the price
    70%
    Delivers good value for the price
    7 Answers
    100%
    Delivers good value for the price
    51 Answers
    Happy with the feature set
    70%
    Happy with the feature set
    7 Answers
    98%
    Happy with the feature set
    51 Answers
    Lived up to sales and marketing promises
    70%
    Lived up to sales and marketing promises
    7 Answers
    97%
    Lived up to sales and marketing promises
    36 Answers
    Implementation went as expected
    80%
    Implementation went as expected
    8 Answers
    100%
    Implementation went as expected
    46 Answers
    Best Alternatives
    Lightspeed RetailMySQL
    Small Businesses
    Square POS
    Score9 out of 10
    MariaDB Platform
    Score9.1 out of 10
    Medium-sized Companies
    No answers on this topic
    PostgreSQL
    Score8.8 out of 10
    Enterprises
    No answers on this topic
    SQLite
    Score8 out of 10
    All AlternativesView all alternativesView all alternatives
    User Ratings
    Lightspeed RetailMySQL
    Likelihood to Recommend
    9.5
    (15 ratings)
    8.5
    (146 ratings)
    Likelihood to Renew
    -
    (0 ratings)
    9.0
    (5 ratings)
    Usability
    9.5
    (3 ratings)
    7.9
    (18 ratings)
    Support Rating
    9.8
    (4 ratings)
    9.0
    (3 ratings)
    Implementation Rating
    -
    (0 ratings)
    8.0
    (1 ratings)
    User Testimonials
    Lightspeed RetailMySQL
    Likelihood to Recommend
    Lightspeed
    It is perfect for any small business looking for inventory control, Tracking purchase history, and just an all round easy to use software for retail and beyond. I would not use it if I have only a few hundred items or was a larger company that can afford to build my own POS software.
    Incentivized
    Read full review
    Oracle
    MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.
    Incentivized
    Read full review
    Pros
    Lightspeed
    • Lightspeed Retail has great reports that are very easy to read and understand.
    • Lightspeed Retail is great to train new employees on because of its ease of use. There are not lots of different things that you have to learn just basics.
    Incentivized
    Read full review
    Oracle
    • Stable - it just runs, with minimal downtime or errors
    • Fast - well-structured data is quickly written and read
    • Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
    • Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL
    Incentivized
    Read full review
    Cons
    Lightspeed
    • With a larger SKU assortment size, the software really starts to struggle with doing physical inventory after scanning in a few hundred items.
    • Several times throughout each year Lightspeed went down on us (not our internet connection but actually Lightspeed verified).
    • Special order system could use a lot of modern improvements (ability to schedule ahead of time, etc.)
    • Reports are very basic, and will likely require there Lightspeed Analytics to actually get reports useful for day to day operations.
    • Weak system for receiving purchase orders.
    • Does not handle items and cases for reordering very well. Have used multiple Point of Sale systems in the past 10 years that allow to set reorder points based on single items, but reorder the case automatically, Lightspeed has no support for this.
    Incentivized
    Read full review
    Oracle
    • Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
    • Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.
    Incentivized
    Read full review
    Likelihood to Renew
    Lightspeed
    No answers on this topic
    Oracle
    For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
    Incentivized
    Read full review
    Usability
    Lightspeed
    Simply well designed with obvious icons per component, making it easy to interface with.
    Incentivized
    Read full review
    Oracle
    I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
    Read full review
    Support Rating
    Lightspeed
    I gave the rating of a 9 because ninety percent of the time when I talk to their support they're very helpful. One of the only real issues I have is there are times where the queue will be 7-9 people deep. When you have an error you don't know how to fix, sometimes this is very troubling. But overall their support is usually quick and friendly.
    Incentivized
    Read full review
    Oracle
    We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.
    Incentivized
    Read full review
    Implementation Rating
    Lightspeed
    No answers on this topic
    Oracle
    1. Estimate your data size. 2. Test, test, and test.
    Incentivized
    Read full review
    Alternatives Considered
    Lightspeed
    Lightspeed is faster, sleeker and more modern than our previous POS system. I can’t express enough how easy the online store portion of Lightspeed is - it just intuitive and sometimes, is TOO easy, I feel like I have to be forgetting something. Lightspeed is staying modern and current where our previous POS was not
    Incentivized
    Read full review
    Oracle
    MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.
    Incentivized
    Read full review
    Return on Investment
    Lightspeed
    • Certainly has saved money on cash-outs/ accounting due to QuickBooks integration.
    • Faster processing through tills means happier customers and more sales per hour.
    • Expensive product at $5K a year has taken away some profitability for this small business. It's way, way over priced.
    Read full review
    Oracle
    • As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
    • The acquisition by Oracle makes you need to contract support for the enterprise version
    • If you have knowledge about oracle databases, you can get more out of the enterprise version
    Incentivized
    Read full review
    ScreenShots