将已编译的应用程序迁移到基于 Web 的应用程序

发布于 2024-12-21 19:50:28 字数 852 浏览 0 评论 0原文

最近，我遇到了一位客户，他希望获得新功能以及与在 Windows 中运行的商业产品所生成的数据不同的数据表示形式。我对基于 Web 的 php/mysql 应用程序的初步评估可能低估了所需内容的复杂性。该应用程序用作音乐目录数据库，用于跟踪一个人的音乐收藏以及有关专辑、乐队中的音乐家等的详细信息。他拥有一段时间以来收集的 30,000 首歌曲收藏。
需要有一个组件可以显示和呈现数据库中的信息。我有使用 Dreamweaver 创建基于 php/mysql 的数据显示/演示的技能。因此，这可能会节省编码时间。然而，第二个组件要求有一个音乐播放器，并且需要呈现有关当前播放的歌曲、歌曲名称、专辑、乐队、乐队成员等的各种信息。
或许，事情并不太复杂。我将使用相同的 php 代码来显示各种专辑/歌曲，而只需从数据库中选择一首歌曲并将其作为参数提供给播放器，然后使用显示有关当前正在播放的歌曲的附加信息。我是否应该寻找现有的应用程序，看看是否可以自定义它们以使用他现有的数据库？我可能还需要将 MS Access DB 转换为 MySQL。我想我已经找到了一个可以做到这一点的应用程序。我考虑了 HTML5 和使用本地存储的能力。我认为只支持一个数据库，这不一定是问题。否则，我需要不介意存储 200GB（是的，千兆字节）基于 mp3 的数据（mp3 格式的歌曲）的网络托管。一些托管提供商提供无限托管，但他们可能预计大多数人不会使用那么多。
有人做过这样的事吗？如果有应用程序可以做到这一点，我不想重新发明轮子。唯一的问题是他们是否能够灵活地导入代表他多年来积累的信息的所有数据字段。我不能指望现有的应用程序具有与他一直在收集的字段或数据完全匹配的字段。这是决定是从头开始完全自定义还是使用另一个应用程序但以某种方式将其数据移植到新数据库中的挑战。任何反馈表示赞赏，谢谢，布鲁斯

原文

Recently I got a client that wanted to have new features and a different presentation of data from what was produced by a commercial product that runs in Windows. My initial assessment, for a web-based php/mysql application, may have underestimated the complexity of what was needed. The application serves as a Music catalog database for keeping track of one's music collection along with details about the album, the musicians in the band and etc. He has a 30,000 song collection that he has compiled over some time.
There will need to be one component that allows for display and presentation of information from a database. I have skills in using Dreamweaver to create a php/mysql based display/presentation of data. So, this might save time with regard to coding. However, the second component requires that there be a music player and that various information be presented about the song currently playing, the name of the song, album, band, band members, etc.
Perhaps, it is not too complicated. I would use the same php code that displays various albums/songs and instead just select one song from the database and give that as an argument to player and use then display additional information about the current song playing.
Should I look for existing applications and see if they can be customized to use his existing database?
I also may need to convert the MS Access DB to MySQL. I think I have found an application that will do that.
I considered HTML5 and the ability to use local storage. I think that only one database is supported for that, which isn't necessarily a problem. Otherwise I need web hosting that would not mind storing 200GB (yes gigabytes) of mp3 based data (songs in mp3 format). Some hosting providers offer unlimited hosting but they probably expect that most folks won't use all that much.
Has anyone done anything like this? I don't want to reinvent the wheel as it were if there are applications that do this. The only problem is with regard to how flexible they are in being able to import all the data fields that represent the information he has accumulated over the years. I cannot count on an existing application to have fields that exactly match the fields or data that he has been collecting. That's the challenge in deciding whether to completely customize this from scratch or use another application but somehow port his data into the new database.
Any feedback is appreciated,
Thanks,
Bruce