Gossamer Forum
Home : Products : Gossamer Links : Discussions :

Windows GUI Feedback

(Page 1 of 2)
> >
Quote Reply
Windows GUI Feedback
Hi,

We are looking at building a windows application to help manage your Links SQL database. This would be a program that would facilitate offline editing/management of a database.

I'd be interested to hear on what sort of features you'd like to see.

Also, I'd be interested to know how many of you have the ability to connect to your database remotely.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
Wow that sounds cool. What would it be written in? C++, VB ?

Would it be able to connect to the database to make changes?
Quote Reply
Re: [RedRum] Windows GUI Feedback In reply to
C++ and Yes!

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
It would be cool if it could export the data in different formats, eg, Excel, word, and vice versa.

Last edited by:

RedRum: Mar 5, 2002, 2:41 PM
Quote Reply
Re: [RedRum] Windows GUI Feedback In reply to
I use DBtools to manage my MySQL databases and SQL Enterprise manager for MS-SQL.

The former could be improved by having all the functionality of the latter.

I presume your app is mainly for MySQL databases rather than MS-SQL - how would you improve upon Enterprise manager which ships with MS-SQL?

*-*-*-*-*-*-*-*-*-*-*
Servicepals.com is an online community for serving and retired military men and women. Visit us at http://www.servicepals.com. Development by Rawnet Limited
*-*-*-*-*-*-*-*-*-*-*
Quote Reply
Re: [servicepals] Windows GUI Feedback In reply to
Hi,

This wouldn't be a "Enterprise Manager" tool, but rather would be a tool to manage your Links SQL database (i.e. with forms designed with Links SQL in mind).

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
Oooh - okay.

That'd be rather brilliant. Put me down for testing on Win2k and XP. Excellent idea guys.

*-*-*-*-*-*-*-*-*-*-*
Servicepals.com is an online community for serving and retired military men and women. Visit us at http://www.servicepals.com. Development by Rawnet Limited
*-*-*-*-*-*-*-*-*-*-*
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
Excellant idea... Would it use some sort of access permissions to login?
Quote Reply
Re: [SeanP] Windows GUI Feedback In reply to
Hi,

We are looking at a couple possibilities. One is to use remote connections to the database. This will mean setting up MySQL or MS SQL to accept connections from remote machines. Without this, we would need to build some sort of HTTP -> SQL connection. It may be the way we have to go as I don't think many ISP's would be happy with allowing remote connections (even with user/pass info).

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
Alex,

I hope that the application has less overhead than the MySQL GUI application.

The download is like 50 MGS (mind you that I have a dialup connection in my home office that runs at 26.6 kbps)...not my computer's fault since he has a 56K modem...my only "broadband" solution is two-way satellite, which is very expensive, like $79.99 (US) per month...

Anyway, hopefully your app will have less overhead.
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Heckler: Mar 6, 2002, 9:23 PM
Quote Reply
Re: [Heckler] Windows GUI Feedback In reply to
>>MySQL GUI application<<

What is the mysql gui app?
Quote Reply
Re: [RedRum] Windows GUI Feedback In reply to
Go to http://www.mysql.com/ and search for GUI, look for yourself..bye bye!
========================================
Buh Bye!

Cheers,
Me

Last edited by:

Heckler: Mar 7, 2002, 6:57 AM
Quote Reply
Re: [Heckler] Windows GUI Feedback In reply to
>>Go to http://www.mysql.com/ and search for GUI, look for yourself<<

Thanks will do

(if I'd have known it was from mysql.com in the first place then I wouldn't have asked what it was would I Smile)

Last edited by:

RedRum: Mar 7, 2002, 7:20 AM
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
Is C++ personal choice (or relating to your programmers specialist area) or does it have some kind of advantage over vb or any another language for that matter?

Last edited by:

RedRum: Mar 7, 2002, 8:19 AM
Quote Reply
Re: [RedRum] Windows GUI Feedback In reply to
For anyone interested the answer to the post above (or one of the reasons) was to do with bundled files.

VB = lots

C++ = not lots Angelic

I guess that is a good enough reason. Sigh. If only C++ was easier to understand.

I have it installed and get as far as creating a new workspace then my palms get sweaty and I exit and open VB Laugh

Last edited by:

RedRum: Mar 7, 2002, 12:04 PM
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
In Reply To:
Also, I'd be interested to know how many of you have the ability to connect to your database remotely.

Do I qualify here? Our webhost allows you to setup hostnames to access your MySQL database. ie, I access my database through 'sql.fbagroup.co.uk' on the MySQL default port and login with my credentials - because the databases are on dedicated machines. Does this sound right?

I'd be very intersted in such an application, Alex! Anything that would make the administration of a MySQL database more user-friendly (or Windos-friendly, as it's what people seem accustomed to) I would welcome with open arms. At the moment, I get a few of my colleagues (who need to enter data) to enter the data into an Access database as that is what they're happy with before I export it to MySQL to work with my applications. I think this could well be the answer?!

Cheers

- wil
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
You were asking for feedback, so I'll be honest. The internet is fairly cheap now a days, and it is not much of a hassle to actually have to be online to work. A C++ application would be cool, but I think that just logging into the admin area and doing the work online is much easier.
Cheers,
Michael Bray
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
Hi Alex,



Briljant idea, maybe u can make a option where u can select which options are allowed for a certain users. So u can let other people validate links and admin the links and so on. Would be great !!!

Regards startpoint.
Quote Reply
Re: [RedRum] Windows GUI Feedback In reply to
In Reply To:
Is C++ personal choice (or relating to your programmers specialist area) or does it have some kind of advantage over vb or any another language for that matter?

Hm, isn't Perl based on C++ and very much relies on some C++ libraries?

- wil
Quote Reply
Re: [Wil] Windows GUI Feedback In reply to
Not that I know of. Perl was written in C. Is that what you mean?
Quote Reply
Re: [RedRum] Windows GUI Feedback In reply to
Not sure what I mean :-\. Just that there's some C somewhere in Perl - but I'm not sure if this is true for Perl 6?

- wil
Quote Reply
Re: [Wil] Windows GUI Feedback In reply to
Maybe you are thinking of the windows version which is C++ ?

Hmm napster was C++ too :)
Quote Reply
Re: [RedRum] Windows GUI Feedback In reply to
And everything else! :-)

- wil
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
VERY INTERESTED!!!

We would like to have it yesterday. Right now, we are building a specialized directory with relatively few links, but a lot of information for each one. We need to have a comprehensive resource completely in place before we launch it publicly -- but progress has been slow, taking a lot longer than expected.

The LinksSQL editing interface just isn't suitable for intensive work involving many editors ... to keep everyone onboard, we stopped using the conventional LinksSQL user/editor interface, and we are now creating the database using the DBMan flatfile script. When it is finished, we will convert to MySQL tables. It works -- but only just.

The main concept is separation of the database from all other aspects of LinksSQL, and we would like to be able to continue like this after the directory goes live.

Features we would like to see:

---- Using remote connection (which we can do)

* Multiple editors working offline, with admin controls on where they can edit. That implies an editor table containing permissions for each individual.

* Admin review of what individual editors have done. Rollback not necessary, but some kind of tracking would be very useful.


---- Without a remote connection

* Have one or more editors working totally offline, creating data files that can be merged into the main database by admin. Submission could be by file upload or by email to admin. Implies the ability to check for redundancy and inconsistency in the data before merging.


We are currently set up at pair Networks, who provide MySQL databases with three passwords -- readonly, writeonly, readwrite -- plus the option of remote connection (though we would be reluctant to allow remote connection after the inital stages of the project).
Quote Reply
Re: [Alex] Windows GUI Feedback In reply to
Has this idea been discarded?

Sean
> >