[prev in list] [next in list] [prev in thread] [next in thread] 

List:       quanta
Subject:    Re: [Quanta] Is Quanta the right tool for me?
From:       Thibaut Cousin <cousin () kde ! org>
Date:       2006-07-19 12:23:20
Message-ID: 200607191423.27790.cousin () kde ! org
[Download RAW message or body]

[Attachment #2 (multipart/signed)]


Le mercredi 19 juillet 2006 13:40, Andras Mantia a écrit :
> On Wednesday 19 July 2006 13:55, Thibaut Cousin wrote:
> > In his new scenario, is Quanta still the good tool for me? The
> > problem is, all HTML/PHP code I type must not be saved to a file, but
> > to the database. Can Quanta help me with that?
>
> So you mean that your database acts like a file system? Strange thing,
> if you ask me. ;-) If there is any bridge to access the database from
> the web (like via ssh, http, webdav, etc.) you can use Quanta just as
> before by using the KDE kioslaves.

  Oh my, no I did not mean that. Strange idea indeed. ;-)
  The HTML code I type must not be saved to a file, only in the database. The 
only file that exists on my webserver is index.php. All the rest is dynamic.
  So I can still type the code in Quanta, but Quanta can't *save* the code 
where I want to. That makes Quanta much more awkward to use.
  At the moment, when I want add or update data to the database, I either use 
mysql shell (which means opening a SSH session on the server), of phpMyAdmin.

>  If there is no such possibility, you may try to write some scripts
> yourself and use the project event actions. Saving would be the most
> easier thing: you save a file, the "file saved" action is executed,
> which puts the content of the saved file into the database.
>  There isn't a "before document open" event right now, only "after
> document open", but you could still update the file you opened after it
> was opened and request a reload (also from the script).
>  You could do a complete update of your files form the database when you
> open the project and a complete save of the files when you close it.

  I thank you for your suggestions, they seem to be a good idea. But I'm not 
sure I'm competent enough to do that. I've never done any KDE or DCOP 
programming, and I'm still in the process of learning PHP and MySQL, not to 
mention designing my site.

>  Of course the above has two requirements:
> - a local copy of the files from the database
> - a way to map the database content to files
> - a script/executable that you write (can be C++/PHP code as well,
> doesn't matter) which can do the getting/putting the data from/to the
> database.

  That looks extremely complicated... Isn't it possible to make direct calls 
to MySQL, for example through small PHP scripts, or by establishing a direct 
connexion to the server through the network? In any case, having a local copy 
of the whole database is really inconvenient, because it means a lot of 
manual work (dumping the database on the server, downloading it, etc) every 
time you start working on the site.

> If you need help, ask here. If you succeed and want to share the tools
> with us, we are happy to put them somewhere to download.

  I don't know where to start... As I said, that's probably too big for me. 
But when my site is designed, I'll try to have a look at that anyway.
  Regards,

-- 
Thibaut Cousin

[Attachment #5 (application/pgp-signature)]

_______________________________________________
Quanta mailing list
Quanta@mail.kde.org
https://mail.kde.org/mailman/listinfo/quanta


[prev in list] [next in list] [prev in thread] [next in thread]