Re: BBEdit to web

[Jan Erik Moström]

On 27 Nov 2019, at 8:02, Andrew Brown wrote:

Is there any way of feeding files from BBEdit direct into a MySQL 
database?


This is a really wild idea which might or might not be useful.

If the data that you want to clean up is really regular/structured you 
could perhaps use text factories to clean up the data and generate SQL 
commands that you then feed to the MySQL database.


Other possible way is to write a Python script which then talk to the 
database to insert the data.


But it all depends on how the data is structured and looks like.

Also, it's probably easier to use some kind of direct MySQL library 
(depending on what tools you decide to use) as ODBC strength in the 
cross-platform (different databases) properties (at least this is how I 
understand it). If this is a one-time thing it's probably easier to 
simple use the built-in library in some language or directly use the 
mysql command line tool.


I haven't done anything major myself, but I have several time generated 
a file with SQL commands which I then have loaded into a database from 
the command line.


= jem

--
This is the BBEdit Talk public discussion group. If you have a 
feature request or need technical support, please email

"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
You received this message because you are subscribed to the Google Groups "BBEdit Talk" group.

To unsubscribe from this group and stop receiving emails from it, send an email 
to bbedit+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/D8256A48-B379-42EB-BE40-A59E862DC40C%40mostrom.pp.se.

BBEdit to web

[Andrew Brown]

Working on a collection of aged tagged files coming from InDesign I am cleaning 
up the coding with FileMaker Pro 16, running a series of lengthy substitute 
calculations while cursing FMP for being grepless. This works well for me in 
spite of the obvious limitations of FMP as a text editor — I frequently copy 
texts out to process them in BBEdit.

Is there any way that BBEdit could function in the same way, with immediate and 
automatic search-and-replace while retaining the original file unchanged? 
Perhaps something in php to run a file through str_replace and insert the 
result into a specific record in a MySQL database ?

I have been unable to persuade FMP to upload records to our remote MySQL 
database and have not yet found any relevant and comprehensible advice online. 
I have ODBC Manager which might or might not be what I need.

Is there any way of feeding files from BBEdit direct into a MySQL 
database?

Thanks.

AB

-- 
This is the BBEdit Talk public discussion group. If you have a 
feature request or need technical support, please email
"supp...@barebones.com" rather than posting to the group.
Follow @bbedit on Twitter: 
--- 
You received this message because you are subscribed to the Google Groups 
"BBEdit Talk" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to bbedit+unsubscr...@googlegroups.com.
To view this discussion on the web visit 
https://groups.google.com/d/msgid/bbedit/B60F4E0D-78F9-490B-B17D-DA9CF23F0CED%40c18.org.