|
Maybe some dumb questions here:
1) So there are licensing issues to be dealt with (money?) if I wanted to package the runtime components with the program, all to be installed by the program installer?
2) What about having the installer check for proper runtime software, and if it didn't find it (or a recent enough version), abort the install and tell the user that they need to go download and install the runtime? Maybe even have the installer launch a browser and point it to the install/download page? Is this a viable way of doing it to get around any licensing issues (if I understand what you meant above)?
Thanks again for your help.
modified on Wednesday, July 15, 2009 2:20 PM
|
|
|
|
|
There are possible issues with licenses. Depends on the particular software and whether you go commercial with the product. Some freely available stuff has restrictions on redistribution in commercial products. Another example, IIRC, MS Office Developer had some elements that could only be used for development.
It would probably be a good idea to check for any existing runtime that the app requires. I think the installer should tell the user if any elements are missing - these should be detailed in documentation as prerequisites.
Regards
David R
---------------------------------------------------------------
"Every program eventually becomes rococo, and then rubble." - Alan Perlis
|
|
|
|
|
Thanks for all the help, David.
|
|
|
|
|
Thanks for all the help David!
|
|
|
|
|
Hi,
I am developing a webapplication(currently), the web application is supposed to simply add data of employees , their will be different types of people(say 10 types of people) modifying the data in the tables of sql server-2005 their will be say around 15-20 different tables with an average of 10 fields per table.
By architecture I mean assistance in designing the application so that the application may support 50 simultaneous users interacting with the web application simultaneously, how should my sql be engineered because in future their will be massive entries getting in the database say 50,000 or so minimum
in two or three tables.
what kind of design should I use to handle such requirements
thank you
|
|
|
|
|
I'm afraid a forum is not where you are going to get a solution to this question. The question is so broad that it is impossible to answer. I can only suggest you hire a consultant to do your design for you or you could employ a senior developer who could do this fairly easily.
Alternative you need to get a book on database design. One rule you can start with, never store data more in more than in place (this does not include foriegn keys of course).
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
HI Mycroft,
Thanks for the suggestion.
|
|
|
|
|
Just to add - whatever design you choose, make sure that you include some form of timestamp on your columns so that you can perform concurrency checking when your users update records - that way, you can easily implement a strategy where you choose who manages to update the record, and what messages are displayed if they can't.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
thanks Pete for your valuable suggestion
|
|
|
|
|
3-Tier architecture can be of great help. If you are developing with .NET then this will become 4-Tire architecture: User Interface, Code Behind, Business Layer, Data Access Layer. Do not make the mistake and design your application architecture exactly the same as database. Remember this, which I read in some text somewhere:
Object oriented programming is not about normalizing data but normalizing behavior.
You know ahead of time you will be interacting with the database so perhaps create utility classes which take a query and execute it, return tables, data readers etc.
Store your connection strings in the .config file.
The only part of your code which should realize this is a web based application is the User Interface and Code Behind files. The rest of your code should be totally ignorant of whether this is a desktop, web or mobile application. This will help in debugging, maintenance etc.
Good Luck!
CodingYoshi
Artificial Intelligence is no match for Human Stupidity.
|
|
|
|
|
CodingYoshi wrote: Do not make the mistake and design your application architecture exactly the same as database.
Hi Yoshi,
can you please explain what you do you mean here?
Thanks
shank
|
|
|
|
|
I have seen people create classes based on database tables but it is not a good practice. For example lets say I have the table s below:
Customers
Orders
Since this is a many to many relationship, to normalize we will create another table called:
CustomersOrders
This is basically the bridging or link table. Now design classes based on these tables and your design is as below:
Customer Class
Orders Class
CutomerOrders Class
You see what I mean. Instead you should have the following classes:
Person
Customer : Person // If later you need employee you can Employee : Person
// Customer should also have an OrderCollection. Remember Aggregation
Address // Both the Customer's shipping and billing address can use this
CustomerCollection
Order
OrderCollection
You will have classes which have methods for performing CRUD operations on these objects and those classes might call other classes for help. You might have many other properties and methods in your Customer class, in addition to the fields in the database, for example, FullName (First Name + ", " + Last Name), GetPendingInvoices() etc.
Do you see now what I mean?
OrdersCollection
CodingYoshi
Artificial Intelligence is no match for Human Stupidity.
|
|
|
|
|
Thank You very much Yoshi for your useful information.
I highly appreciate it.
|
|
|
|
|
I'm searching for UML design tool that is also capable of generating and reverse engineering C#. Integration with Visual Studio would be great also. Any suggestions?
For those of you who are familiar with ModelMaker, can you please make a quick comparison with other tools known to you. I used ModelMaker for Delphi Win32 projects a while ago, and it was best choice.
|
|
|
|
|
Enterprise Architect[^] by Embarcadero seems to be gaining good reviews from users. You might want to look into that.
"WPF has many lovers. It's a veritable porn star!" - Josh Smith As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.
My blog | My articles | MoXAML PowerToys | Onyx
|
|
|
|
|
Enterprise Architect looks really impressive. I have tested it, and it's on my shopping list now
Thanks Pete!
|
|
|
|
|
Pete O'Hanlon wrote: Enterprise Architect
I agree, it is a good one. Do you know of any open source ones? Doesn't have to be as good, but something to fiddle with.
"The clue train passed his station without stopping." - John Simmons / outlaw programmer
"Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon
"Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
|
|
|
|
|
Hi!
I am not sure where should I post this topic. I just need an idea about my task below
a central server polls from a legacy server for media updates. the media file has incremental file name i.e 1.mpeg, 2.mpeg and so forth. central server needs to poll the legacy server and check for update via ftp. once it finds update it needs to copy the files and bring into central server from legacy server and distribute to its 600 clients. each client plays those mpegs constantly and central server needs to update the content in clients playlist automatically. for example clients current playlist could be
1.mpeg
2.mpeg and so forth. how do i keep adding the updated file to the play list and keep deleting if the files are more than 20 i.e.
play 1-20 and as soon as it hits 21 delete old files
please help i dont know how to acheive this and which what program.
thanks in forward.
please just give me an idea how to achieve this
|
|
|
|
|
|
You have issues to resolve;
1- How to get latest file from FTP?
2- How to add it in playlist and keep thecount up to 20?
Ans 1- You can use a windows service to keep on checking the FTP location for any new file avaialble. If you get any updates using some FTP client you can download it.
Ans 2-
a) Adding newly downloaded file in the playlist depends mostly on the player that you are using. There should external functions avaialble to call.
b) This has some trick. Its like a queue where you can not hold more than 20 items. Use simple arraylist for the files to hold and when the count goes up, remove the top 1.
You can start with this.
|
|
|
|
|
Hi All,
I am designing a ticket booking system with seat selection facility. I need to store the Seating Map (of an auditorium/theatre) in database so that the same can be fetched and shown in UI.
I am not sure how to do the same in an RDBMS. Please help me.
Thanks
Riyaz
|
|
|
|
|
hmrizin wrote: Please help me.
With what exactly? The design, the implementation in the RDBMS, fetching the things or showing the stuff in the UI?
A quickstart; them seats are probably numbered. You need a table to store who is sitting on what number on a specific event. A theater can have multiple events on a day, so you'd also need a table to list the events
I are troll
|
|
|
|
|
Eddy Vluggen wrote: With what exactly? The design, the implementation in the RDBMS, fetching the things or showing the stuff in the UI?
The implementation in RDBMS.
The Database Design should support the following:
1. Storing Seating Map of different Auditoriums/CinemaHalls
2. Should store not only the seat numbers but the exact seating arrangement with pathways, screen-location etc
Is is possible to do with an RDBMS? Please gimme some ideas.
Thanks
Riyaz
|
|
|
|
|
hmrizin wrote: Is is possible to do with an RDBMS?
Yes. Have you ever designed a database before?
I are troll
|
|
|
|
|