2

As for a developer, the use of SQL Developer is almost daily. However, given that my laptop have only 1 gb ram, it is hard to open SQL Developer and Eclipse together. Do you have any lighter recommendation? Most importantly it should be free.

I cannot upgrade my laptop because it is company property and I've asked the hardware guy that they don't have extra ram or laptop inside the company.

3
  • What functions of SQL Developer are important for you? Query Builder? Or you just want to be able to run your queries against DB and see the result? Dec 21, 2011 at 8:54
  • I just want to use the query against DB and pl/sql too. Dec 21, 2011 at 9:30
  • Aren't you talking about SQL Management Studio??
    – surfasb
    Dec 21, 2011 at 15:39

3 Answers 3

2

I gave up using any database clients in favor of LinqPAD:

  1. It supports SQL Compact, SQL Express, SQL 2008, SQL 2005, SQL 2000, SQLite, MySQL and Oracle.
  2. You can query OData (for example StackOverflow Data) and DataMarket online services.
  3. You can choose between Linq-to-SQL (for supported DB only: SQL Server, all editions including the compact one), Entities (all possible databases) and native SQL support.
  4. You can quickly prototype code in C#, VB and F#.
  5. It has a really powerful visualizer with different views (table, rich canvas etc.)
1
  • 1
    +1 for LinqPAD. Plus you can get your LINQ on. . .
    – surfasb
    Dec 21, 2011 at 15:38
1

Maybe you can give SQuirreL SQL a try. We used it in a company enviornment where we weren't allowed to install new software ourselves. It's not as fancy as SQL Developer, but it also works with many other databases like DB2 or MySQL.

As far as I can remember, memory consumption wasn't too bad, bad you have to try a current version and see if works for you.

It's based on Java, so you need a JRE though.

1

If you're already running Eclipse, then why not add in SQL Explorer? It's perfectly fine for browsing databases and submitting queries, and you won't have to start another IDE.

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .