MySQL database management


#1

I think you should add a MySQL database management into it so you can access you database in atom with out having to move to the SQL Workbench to access your database


Multiple coding languages syntax
#2

I split this into a new topic because … well … it is a new topic :grinning:


#3

Ok thats fine


#4

If a package doesn’t already exists, it sounds like a good idea for a new one. blink blink :wink:


#5

I agree. I wouldn’t want this to be built-in to Atom … I don’t care about managing MySQL databases through my code editor. But as a package, great!


#6

Well im not to sure how to build package for that but im willing to try any advice on how to start would be great


#7

The Atom flight manual has what you need to get started:

https://atom.io/docs/latest/


#8

I think that’s some major work.
You’d want not just admin tasks, but presumably also querying. That requires some fancy scalable tables inside views that are essentially made for lines of text; not impossible, but something which others have had trouble with in the past.

I’d be interested to see this, though. Not for MySQL necessarily, but the same principle for MSSQL.


#9

You can put arbitrary HTML into an Atom tab. See my html-tab package. It is just an educational package.

Edit: And, if there is a real website to do this (which I assume there is) you could just use a web browser package to do the whole thing,


#10

I was just thinking that a simple html table won’t do here, so I wonder whether someone could just drop some framework’s nicely packaged table view into an Atom text-editor pane and call it a day, or if there are some incompatibility issues or restrictions that would make it too difficult.


#11

Well if you all want to help build it im new to atom i just got it today i will link a GitHub repo if you want to help just let me konw


#12

I’ve started tinkering on a general database management app using electron. I haven’t gotten too far yet, but figured a separate app was a better solution as dub management seems rather disjoint from code editing.

My ultimate goal is to access SQLite, MySQL, Postgres, and SQL server (platform permitting). I’m debating support for NoSQL databases, but want to keep it simple to start.

What would be the best place to start? It should be pretty easy to connect and execute queries. Displaying results in a table should also be easy. Would that be the best place to start? Does this idea even make sense to the community?

Thanks.


#13

Definitely. Back in the days when I was unemployed and writing tons of packages I was going to write such a thing for NOSQL DBs like couch, my DB of choice.

If you want to put arbitrary html in an editor tab check out my html-tab package. It is an educational package for this purpose.


#14

I don’t see any platform dependence here, as SQL Server does provide standard ODBC drivers to connect to instances remotely from other OSs, as far as I know.


#15

I’ve been wanting to find a PHP/MySQL solution. A ton of people use these coding tools already for this purpose. It makes sense to keep these skill sets active since we already use HTML/CSS/JS with Atom already. There have been some attempts in the past to do this, but didn’t have the support that Electron and Atom have, so they eventually failed.

I also have a project that requires a database and I’d like to be able to store it locally, not via the internet. I’ve never created a local database in any HTML work I’ve done, although I know it’s now possible, but I’d prefer to continue to use my PHP/MySQL skills.