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: <https://twitter.com/bbedit>
---
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.