The Bear has been released into the wild wide web. Bear SQL is an free, open source, web interface to MySQL. It aims to make administration and use of MySQL simple.

It's open source, you can be involved in this project and help to make it better even if you aren't a coder.
Provide feedback, suggestions, code improvements, feature requests, language packs, documentation, testing or help promote it add a link to it from your site. All help is appreciated.

Here's a categorized list of current features:

Database

  • Create
  • Delete
  • Backup
  • Restore

Tables

  • Create
  • Delete
  • Rename
  • Backup
  • Restore
  • Optimize
  • Add Columns
  • Delete Columns
  • Modify Column properties
  • Add Keys
  • Delete Keys
  • Search

Records

  • Add
  • Delete
  • Edit
  • Search

Users

  • Create
  • Delete
  • Change Name
  • Change Password
  • Change Privileges

Queries

  • Write your own
  • Save queries
  • Delete queries
  • Save Results

hopefully i can get it

hopefully i can get it working on my MAMP and give it a shot!

I wish someone would do the

I wish someone would do the same for MSSQL. The MSSQL management studio really stinks. Especially in the backup/copy department.

Triumph wrote:The MSSQL

Triumph wrote:

The MSSQL management studio really stinks.

MSSQL management really stinks.

MSSQL really stinks.

Well Said!

Deuce wrote:Triumph

Deuce wrote:
Triumph wrote:

The MSSQL management studio really stinks.

MSSQL management really stinks.

MSSQL really stinks.

Well Said!

Hmm. LINQ to SQL is planned in MYSQL 6. MSSQL runs better than MYSQL on WinSrv though.

Does MYSQL run natively on Windows Server or is it interpreted?

Never had to use LINQ -

Never had to use LINQ - looking for something like http://www.linqpad.net/ ?

You edited your post as I was typing my reply... thanks for nothing!

http://www.apachefriends.org/en/xampp-windows.html

Runs natively I am pretty sure.

Deuce wrote:Never had to use

Deuce wrote:

Never had to use LINQ

MSSQL blows but seriously LINQ is fantastic.

I don't have to run MYSQL on the same server. While I've never done it can't I just run a local linux server and connect to it via TCP/IP from my web server? I'm seriously considering running a linux database server along side an IIS web server as long as I can figure it out. Wink

Then I could make BearSQL a part of the deal. Smile

Or you could take the open

Or you could take the open source BearSQL and revamp it to support MSSQL and you can call it BearsBeatsBattlestarGalacticaSQL

Support for other database

Support for other database servers such as MSSQL is something I have been considering. That's why I didn't call it Bear MySQL.

Tony wrote:Support for other

Tony wrote:

Support for other database servers such as MSSQL is something I have been considering. That's why I didn't call it Bear MySQL.

You'd be the king of my world.

How many files are in the entire project?

edit - I suppose I could download it and have a look for myself, huh?

Triumph wrote:Tony

Triumph wrote:

How many files are in the entire project?

edit - I suppose I could download it and have a look for myself, huh?

Yeah but don't stress yourself, take things a step at a time Tongue

I don't know much about

I don't know much about MSSQL so I don't know about the quirky differences to MySQL.
Getting the basic functionality working shouldn't be too bad.
The amount of testing would double, so I would need some help.

Triumph wrote:Deuce

Triumph wrote:
Deuce wrote:

Never had to use LINQ

MSSQL blows but seriously LINQ is fantastic.

I don't have to run MYSQL on the same server. While I've never done it can't I just run a local linux server and connect to it via TCP/IP from my web server? I'm seriously considering running a linux database server along side an IIS web server as long as I can figure it out. Wink

Then I could make BearSQL a part of the deal. Smile

You can do that. Ensure that mysql is listening on the external port (normally its pre-configured to only listen to localhost) and fixup user permissions so its not totally open. Also for efficiency MySQL connections aren't encrypted (excepting the login bit).

Tony wrote:I don't know much

Tony wrote:

I don't know much about MSSQL so I don't know about the quirky differences to MySQL.
Getting the basic functionality working shouldn't be too bad.
The amount of testing would double, so I would need some help.

Are you asking me for help? I would probably turn your double work into triple. Wink

I do have a copy of MSSQL DevEd but I don't have PHP installed as I couldn't get it to work on my 64-bit system. Tongue

I wonder how hard it would be to transform into ASP.NET. }:)

Chris..S wrote:You can do

Chris..S wrote:

You can do that. Ensure that mysql is listening on the external port (normally its pre-configured to only listen to localhost) and fixup user permissions so its not totally open. Also for efficiency MySQL connections aren't encrypted (excepting the login bit).

Yeah, it looks like an easy idea. I should have probably done it from the start since MSSQL is rather expensive.

Hey Tony, I was talking to

Hey Tony,

I was talking to a buddy of mine who does server design, maintenance, config, etc and was telling him about your software and he had a question I couldn't really answer and so I am going to ask it by proxy.

Quote:

What makes me want to use this instead of phpMyAdmin? phpMyAdmin has been around for a while and is reliable, why should I switch to BearSQL?

I can answer that it's cos

I can answer that it's cos phpMyAdmin is horrible, clunky, badly laid out, difficult to use etc etc, phpmyadmin isn't for the feint hearted and not really something the novice would enjoy using, Tony's app on the otherhand provides a simple clean interface that allows access to the functions that most need to be performed on a regular basis; you would still need to use phpMyAdmin for more specialised tasks though, I don't think Tony wrote bear as a replacement for phpMyAdmin.

Hugo has just been promoted

Hugo has just been promoted to marketing manager :thumbsup:
If you have phpMyAdmin installed on your server and your comfortable using it, then stick to it.
Many years I was building a site for a client who's host provided MySQL but no way to manage it. All I had was FTP access. So I looked at installing phpMyAdmin and gave it up as a bad joke and wrote the beginnings of Bear SQL.

Bear SQL was designed to be easy to install, actually no install, you just put it on your web server and you can start using it. You can also run it locally if PHP is installed and connect to MySQL on a server if the MySQL permissions on the server allow. It doesn't take up much room and gives you access to all of the functionality you would need. Let me know if a feature is missing and I will see about adding it.

thanks

Hi Tony,

I have been using Bear as my main MySQL interface on my local web server for the last couple of months. My DB skills began to increase from that moment on.

I concur totally with Hugo's sentiments vis a vis PHPMyAdmin's hideous interface. It was getting in the way of my development, and I didn't like using it at all.

BearSQL, on the other hand, is an absolute gem. Nice and clean and really easy to use.

A great tool. Thanks

Thanks Phreestyle, It's

Thanks Phreestyle,
It's always nice to hear someone is finding it useful.

Bear SQL is really a useful

Bear SQL is really a useful tool for the people like me who are not coder. Now I’m using bear as my main mySQL. Thanks a lot for sharing such an useful info.

Link removed