+- Sinisterly (https://sinister.li)
+-- Forum: Coding (https://sinister.li/Forum-Coding)
+--- Forum: Visual Basic & .NET Framework (https://sinister.li/Forum-Visual-Basic-NET-Framework)
+--- Thread: [LiveStream - ~3PM PDT] Garage Sale Manager (/Thread-LiveStream-3PM-PDT-Garage-Sale-Manager)
[LiveStream - ~3PM PDT] Garage Sale Manager - Xanii - 07-16-2013
Alright, so my parents are going to be holding a garage sale sometime in the near future. Since I know that there is interest here for people learning how to code and watching livestreams, I've decided to start coding it over a livestream, answering questions, taking feedback, and general stuff. If you would like to watch, I will be doing it through livestream so it gets recorded and saved for anyone that wants to watch it in the future.
I also have one more thing that I haven't decided. Should I use a local file database for the items, or should I choose to host it on a mysql database on my webserver, our should I have an option for the end user?
Also, if anyone has any themes that they think would work great for this (has to be light, clean, profession(ish)), let me know. Otherwise I plan on using the default windows form, or possibly VibeLanderV2.
Major Planned Features:
- Item Database
- ID
- Name
- PLU Barcode Number (Random [Choosable Length], ID)
- Listing Price
- Sold Price
- Sold To *MAYBE*
- Payment Method (Cash, Card)
- Time Sold
- ID
- Money Tracking
- Total In
- Total Listing Price
- Total Sold Price
- Total Markdown Value
- Amount Cash
- Amount Card
- Total In
- Graphing
- Total Listing vs Total Sold Price (Bar, 2col)
- Total Items Sold vs Total Items Available (Pie)
- Last 10 Items Sold (Spline)
- Total Listing vs Total Sold Price (Bar, 2col)
- Overview
- Total Items Listed
- Total Items Sold
- Total Money Made
- Avg. Selling Price
- Graphs On Same Page
- Total Items Listed
If you have any suggestions, please leave them below.
RE: [LiveStream - ~3PM PDT] Garage Sale Manager - Hexology - 07-16-2013
I'd use a local file database, reasons being that people may see your database information and mess with it knowing that your videos will be saved.
RE: [LiveStream - ~3PM PDT] Garage Sale Manager - Xanii - 07-16-2013
(07-16-2013, 06:41 PM)Hexology Wrote: I'd use a local file database, reasons being that people may see your database information and mess with it knowing that your videos will be saved.
Well, I've thought of that and I plan on using a local server of mine to dev with and eventually moving it to one of my production servers where I can sell account with plans of varying features and actually sell the software
Best part of it being a MySQL db is that they can have the software on all of their computers at the same time and have the same information. Best part of local is that you don't have to be online. I think I might let the user choose.
RE: [LiveStream - ~3PM PDT] Garage Sale Manager - Hexology - 07-16-2013
Lots of users will spam any database just cause they can, so I recommend you highly obfuscate your program or something, because it's easy to crack one open.
RE: [LiveStream - ~3PM PDT] Garage Sale Manager - Xanii - 07-16-2013
(07-16-2013, 06:46 PM)Hexology Wrote: Lots of users will spam any database just cause they can, so I recommend you highly obfuscate your program or something, because it's easy to crack one open.
I know how to protect the stuff lol. And this would be *marketed* towards people that host garage sales, not kids. And obfuscating the software wouldn't do a thing to protect a database. I wouldn't have it connect to the database with the program, I would have it call an API on my web server. And OFC, I wouldn't put my production server details on the livestream, and no one could access my local server.
I don't think I said enough "And"s in that post ha ha.
RE: [LiveStream - ~3PM PDT] Garage Sale Manager - Hexology - 07-16-2013
(07-16-2013, 06:48 PM)Xanii Wrote: I know how to protect the stuff lol. And this would be *marketed* towards people that host garage sales, not kids. And obfuscating the software wouldn't do a thing to protect a database. I wouldn't have it connect to the database with the program, I would have it call an API on my web server. And OFC, I wouldn't put my production server details on the livestream, and no one could access my local server.
I don't think I said enough "And"s in that post ha ha.
Ahh alright thanks for clarifying, thought you were calling the database directly from the program, hence why I recommended highly obfuscating your program, or some other sort of protection.
RE: [LiveStream - ~3PM PDT] Garage Sale Manager - Xanii - 07-16-2013
If anyone is going to watch, let me know and I'll start the stream up. Just about to get started.
Scratch that, got a delay.