6 ms·

SQL Studio

95 points by handfuloflight 10mo ago

resonious 10mo ago
Interesting there now seems to be an insurgence of SQL workbench type apps. I also saw DB Pro recently. Despite all of these really polished query editing experiences in these new apps, I reach for Redash every single time. Even though Redash's editor is horrible. The ability to generate even extremely simple sharable visualizations, and alerts is insanely useful. So to any of the devs of these programs out there: ship visualizations and alerts and I will buy your product immediately.
- refset 10mo ago
  Could Metabase be a better fit?
neosat 10mo ago
Kudos on the beautifully and thoughtfully designed landing page - which is becoming a rarity these days. Most product landing page highlight adjectives and abstract value propositions with links to join waiting lists for 'priority' access - providing little insight into the value proposition of the product itself. Not to mention the gratuitous visual effects. So its a pleasure to see a thoughtfully done product landing page (which strongly signals that the same care will have gone into the product). The page is performant, no gratuitous visual effects. It clearly highlights the core product value propositions in the context of product visuals. Addresses key hesitations clearly and upfront (e.g. no cc required, pricing information), and a simple, obvious call to action. Hopefully more people follow this template than the slop generated by auto generators.
- observationist 10mo ago
  Clean, simple, information is where you expect it to be, links go to predictable places, exist in predictable places. Craft and care taken with little things are important, and this was well done.
- thisislife2 10mo ago
  > Kudos on the beautifully and thoughtfully designed landing page Can't say the same - The site shows me an empty white page in PaleMoon (with uBlock Origin Legacy enabled and web assembly and webGL disabled).
- wvbdmp 10mo ago
  I don’t like how the page disables pulldown-reload on mobile. I didn’t even think that was possible. Guess it makes sense when your page is a game of Tetris, but why here?! Sometimes I just like to overscroll a little…
atonse 10mo ago
I'm a huge fan of Postico. It does the one thing I need (DB data exploration and editing) and does it well. What I really miss in DB Tooling is something like SQL Compare and SQL Data Compare from Red Gate. It used to work with SQL server, and would compare two databases and produce "diff" SQL statements to get from one to the other. It was awesome for deployments. Most frameworks handle DDL via migrations, and that works well, but one-time data migrations that are tested in QA and should be pushed live... I've never found a better workflow apart from generating one-time scripts. Now with AI that's easier, but until recently, it wasn't. Not sure if that's the plan for this app eventually, but I sorely miss it, wasn't sure if others felt the same.
golemiprague 10mo ago
[dead]
arrowleaf 10mo ago
Taking a huge risk with the naming here, I would be expecting to hear from a Microsoft lawyer any minute (Due to MS's flagship 'SQL Server Management Studio'). e: Don't let this dishearten you, I only would consider a name change to be more of your own brand. When I saw 'SQL Studio', I assumed MS had created an online version of their product. This looks like a well-done passion project.
- almosthere 10mo ago
  Trademarks are complicated, but they probably won't let anyone claim SQL Studio
  - Etheryte 10mo ago
    That doesn't matter if you run out of money before the end of the case.
    - almosthere 10mo ago
      true
- mbreese 10mo ago
  Not to mention that when you Google "SQL Studio", all you see are MS SSMS results.
- deleted 10mo ago
  [deleted]
reactordev 10mo ago
Do we still need tools like this (with a subscription) when we have AI? Don’t get me wrong, it’s definitely built with love but I haven’t used a tool like this (I used to use SQLTools in vscode) in about 4 years. Everything we do is via agents or in code.
- nerdponx 10mo ago
  Who's "we"?
  - reactordev 10mo ago
    My company
    - gonzalohm 10mo ago
      Is your company a data company? Because I doubt you can get away with using agents to clean messy data from huge databases
- llmslave2 10mo ago
  Not everyone just mindlessly plays the AI slot machine to generate code these days.
- zdragnar 10mo ago
  And here I am, still writing sprocs for all of our business logic...
- theappsecguy 10mo ago
  People are outsourcing even basic sql to AI? Do you do any thinking for yourself still? I’m super curious what the AI brain rot will look like even 5 years from now when some senior dev can’t do a join without AI
  - reactordev 10mo ago
    Well, we used ORMs for a decade and treated our code as schema. Now we hooked all that up to agents. I can still do a join and often write sql queries by hand to execute in a shell.
rafram 10mo ago
JetBrains' excellent DataGrip IDE is free for non-commercial use, and IntelliJ Ultimate (which includes the DB functionality in addition to every single thing in all their other IDE products) costs a little under 3x what you're asking for for this app alone. A bit of a hard sell.
- Closi 10mo ago
  Looks like the pricing is free or $4 per month - sounds reasonable?
- usaphp 10mo ago
  I would rather support a solo developer than a faceless corporation. Also Datagrip is $133/year for most use cases
- adithyareddy 10mo ago
  What pricing are you looking at? IntelliJ Ultimate is $199 a year - $16.53 a month. This is $4 a month.
- deleted 10mo ago
  [deleted]
- 9dev 10mo ago
  Most JetBrains IDE's include the database tools actually, we use Phpstorm and PyCharm, and they come with fully-fledged database connection support; that includes in-editor completion of queries against your schema, by the way, in addition to the myriad of features DataGrip and the DB plugin provide. I wouldn't switch to any external tool anymore
almosthere 10mo ago
I really love it when a single dev makes something like this at a price point that's pretty cheap for us - potentially very lucrative for the developer. That's how we should be doing it - stop working for the man if you can!
deleted 10mo ago
[deleted]
dfabulich 10mo ago
This looks really cool, but I'm not going to use it today, because it only supports SQLite, with Postgres and SQL Server "coming soon." This seems like a very odd starting point, especially for a paid tool. I don't have any SQLite databases I'd want to explore, and certainly none with "massive tables." I'd want to use it for Postgres and MySQL/MariaDB first. Also, if autocomplete is what we care about, PRQL support seems like it will offer the best experience. https://prql-lang.org/ https://prql-lang.org/ PRQL queries transpile to SQL. Just having the `FROM` clause first does wonders for autocomplete.
- SkiFire13 10mo ago
  This reminds me of the pipe syntax for Google's BigQuery. Other helping with autocomplete it also significantly reduces the amount of WITH statements and subqueries needed
_s_a_m_ 10mo ago
why does a software like this needs a subscription?
- mbreese 10mo ago
  To make it sustainable. That's about the only reason, which given the recent TailwindCSS stories, isn't necessarily a bad reason.
  - reactordev 10mo ago
    >”To make it sustainable” That’s a flimsy argument. Product sales can do that. Doesn’t need to be a subscription unless you know your market is weak or your data mining. We can’t be ok with everything being a subscription. You won’t have any money left or, worse, only the rich can afford the tools. I’m much happier paying for $60 Steam games and forgetting about them after a month. Sell this for $20 forever and do it 50,000 times by building a good product. If you get to market mass where you need a dev team to keep up with all the bleeding edge changes to SQL that are coming out, then charge a subscription.
- oakesm9 10mo ago
  I prefer the pricing model of TablePlus[0]. $99 for the current version forever with 1 year of updates. Once that expires you can keep using the last version you had access to forever, or get another year of update for $59. Fair and flexible for everyone. [0]https://tableplus.com/pricing https://tableplus.com/pricing
  - thiht 10mo ago
    You can also renew at any time. I’ve paid for it in the past, at some point stopped using it for a few years, and when I started using it again I just renewed for a year to get a few years worth of updates at once. I like this pricing a lot too because you actually support and incentivize the development of new features.
metadata 10mo ago
I have recently asked my LinkedIn audience if my company should build a great PostgreSQL IDE. That's my wish for many years, and I know exactly where we can provide significant value over existing solutions. Yet basically everyone said not to do it. Too many free options, hard to get people to change habits, you can't charge enough because devs just don't want to pay if they can help it. I decided we will build something else. That said, good luck to this developer, I hope their product takes off.
cyberax 10mo ago
Thank you for not pushing yet another Claude wrapper and having a nice clean page! What is your timeline for Postgres support? I'll subscribe the moment it's available.
sroerick 10mo ago
This looks great, with postgres support I could see myself using this regularly. What is the landscape for simple tools for writing to databases? We used to have Access and simple CRUD tools. I saw a demo of Steve Jobs demoing NextStep which had this beautiful CRUD generator which obviously does not exist today. It seems like the landscape is basically Airtable, Retool, Google Forms or roll your own with a more sophisticated stack. I feel like it ought to be incredibly easy to build a form, either web based or native, which writes to a database. Yet it seems like we are farther away from this than we have ever been
- larkost 10mo ago
  The NeXT (then Apple) product you are talking about is/was WebObjects: https://en.wikipedia.org/wiki/WebObjects https://en.wikipedia.org/wiki/WebObjects It allowed for both HTML applications and Java apps (both JNLP and completely local). And before the transition to Java it was ObectiveC, and I think even had a scripting language (WebScript?). It was beautiful, fast, and for lots of things you could just wire up a small app to a database with almost no code (then later add the business code after the demo). One of my first jobs was writing a web app using it, and those were fun days. The EnterpriseObjects part (the part that managed data to/from the database) survived for a long time in parts of Apple's web back-end. And I have always thought that WebObjects was the model that Ruby-on-Rails was designed to mimic (in many ways, but not all). Edit: here is some documentation I just found: https://developer.apple.com/library/archive/documentation/LegacyTechnologies/WebObjects/WebObjects_5/WebObjectsOverview/WebObjectsOverview.pdf https://developer.apple.com/library/archive/documentation/Le...
  - sroerick 10mo ago
    Fascinating! Makes sense that it would have been the inspiration for Rails
- mamcx 10mo ago
  Poor. My dream is to build such tool, I slowly doing in the side (https://tablam.org https://tablam.org). Probably need to ask for funding too. In concrete, what I want is a real alternative to Fox/Access that work, unrestricted, locally (including inside a phone/iPad). I don't mind have support for cloud stuff (that is what pay the bills mostly) but that is secondary IMHO. Current computers, even mobile, have far much power than most need, and is a shame not much tools actually exploit it.
exabrial 10mo ago
> Billed Monthly I'm out. I'll gladly buy a license though, exactly once. Willing to pay you for your time, but I'm tired of "rental economy".
- zetalyrae 10mo ago
  Unfortunately, I doubt this would be a sustainable model for the developer.
  - PostOnce 10mo ago
    at $4 a month he is going to need one hell of a lot of customers and zero churn to even keep the lights on over his ramen bowl.
    - reactordev 10mo ago
      All it takes is some dev shop to say “give me 5,000 seats”
      - exabrial 10mo ago
        Your example proves otherwise: 5,000 seats x $200 price = $1,000,000 cash realized, right now, no debt financing needed for funding development, regardless if said dev shop leaves you. 5,000 seats x $4 = $20,000 month. That kinda pays the salary of a single FTE, and development ceases if customer runs away, only safe option would be to finance further development to insulate yourself from churn.
        reactordev 10mo ago
        Bro, $200!?! For a SQL browser? Nah… $20 x 5,000 seats = $100,000 realized right now. With that, he could invest it, finish the features, start work on 2.0 and charge and upgrade of $20 to all his customers when he has MSSQL, MySQL, pgsql, SQLite, Oracle. 2.0 could include cloud db’s. Not everything has to be a subscription and if people continue to find value, they’ll upgrade if they think it worthy. Subscriptions tend to be vampires on the wallet and are used to trap users into paying a developer indefinitely. I consider it hostile to users. The exception is if it’s a service that can’t run on my machine. Or a service that does back office for me.
rgovostes 10mo ago
A business analyst friend of mine and SQL novice was given a multi-tabbed editor like this (edit: apparently it was not this brand-new app). We found it difficult to track which query and results tabs are linked, whether they've been refreshed since the query was edited, whether queries in a script have been executed out of order, etc. Hopefully there are ways to address those usability issues.
- arrowleaf 10mo ago
  This SQL Studio which was seemingly released to the public yesterday? Or are you talking about MS's SQL Server Management Studio? The MS one is a beast.
  - WackyFighter 10mo ago
    Management Studio is a monster. I was using for years and every so often someone would show me a feature I was totally unaware of that blew my mind. Visual Studio also had "Database Project" which was amazing. Not seen anything like it. I think everyone moved over to using EF or Fluent Migrations but I loved the Database Projects.
    - wvbdmp 10mo ago
      Database projects are still there, I also love them.
  - rgovostes 10mo ago
    Ah, I guess not then. I revised my comment. Maybe it was DBeaver, after all.
tacker2000 10mo ago
I thought this was from MS, who also has a program called MSSQL Management Studio, short SQL Studio. They will come after this for sure.
- skeeter2020 10mo ago
  The fact that some people may call it SQL Studio (never heard that personally) doesn't mean they will come after this "for sure". If anything SQL Studio is too generic to be valuable. Besides most people call it "Sequel Management Studio" anyway.
  - kstrauser 10mo ago
    Or Microsoft Sequel Copilot any day now.
  - caminanteblanco 10mo ago
    Well to my understanding, half of the point of trademark in the US is to prevent 'consumer-confusion' regardless of company interest
- mfro 10mo ago
  Never heard that. People call it SSMS.
  - eXpl0it3r 10mo ago
    Or "Management Studio". Never heard "SQL Studio" either.
marktolson 10mo ago
Crashes on Mac trying to open up a fairly small workspace (max 97,000 rows).
internet2000 10mo ago
Looks nice. But not "Ready to experience the future?" nice.
remywang 10mo ago
“Made by a single developer” is only a selling point if it is someone with a strong track record to maintain the software, otherwise it’s just saying the bus factor is 1.
- marcosdumay 10mo ago
  This is you opinion. The author obviously prefers being transparent with it and using it to brag for anybody with an opinion that is different from yours. Not everybody thinks the same way.
ibejoeb 10mo ago
Is there a spec sheet or anything like that? I realize it's only for sqlite now, but supposing it's available for Postgres soon, I have a bunch of hard requirements. First is native support for SSH jump hosts. Next is query plan view.
cybice 10mo ago
I've known and used SQL for 25 years; over the last year I haven’t written a single query by hand - AI is very good at it. I use SQL editors only to quickly see what I have there and to check the AI-generated query.
- jmye 10mo ago
  Must be nice to only work with solid, well-documented data models. That sounds like snark, I guess, but I’m actually jealous. AI would choke on the last few “DWs” I’ve used.
remywang 10mo ago
Not to be confused with SQLite studio, which is open source and actively maintained for nearly 20 years https://sqlitestudio.pl/ https://sqlitestudio.pl/
xxdiamondxx 10mo ago
There’s also SQLPro Studio - the studio namespace is getting crowded! https://sqlprostudio.com https://sqlprostudio.com
- wvbdmp 10mo ago
  Since currently this only does Sqlite it’s probably fair to add https://sqlitestudio.pl https://sqlitestudio.pl, which I haven’t used heavily yet, but I believe is pretty excellent. And it’s open source.
potatoicecoffee 10mo ago
I'd love to see a new SQL program that focuses on the design view/access style with the tables joined with lines. For people who aren't used to code its the easiest way to get what is in each table
klustregrif 10mo ago
Really should consider supporting Oracle. So many companies are married to it, could even offer it under a corporate recurring license. It's easily worth the money to them.
caminanteblanco 10mo ago
It took me a second to realize this wasn't some cursor-style Microsoft replacement of SSMS, which would seem to lend some credibility to the potential for consumer confusion and trademark infringement, though of course IANAL
dylanzhangdev 10mo ago
There's already one available at https://sqlitestudio.pl/ https://sqlitestudio.pl/, which I've been using for many years, and it's very stable.
robowo 10mo ago
This looks cool and it hits a niche. There are suprisingly few good IDEs for DB work. I use DuckDB a lot for analytics tasks mostly in DataGrip but its not great. The alternatives like DBeaver are ok but not that great as well.
dbaman 10mo ago
Why should I use this instead of DataGrip?
mergisi 10mo ago
[dead]

95 points by handfuloflight 10mo ago

Interesting there now seems to be an insurgence of SQL workbench type apps. I also saw DB Pro recently. Despite all of these really polished query editing experiences in these new apps, I reach for Redash every single time. Even though Redash's editor is horrible. The ability to generate even extremely simple sharable visualizations, and alerts is insanely useful. So to any of the devs of these programs out there: ship visualizations and alerts and I will buy your product immediately.

refset 10mo ago
Could Metabase be a better fit?

neosat 10mo ago

Kudos on the beautifully and thoughtfully designed landing page - which is becoming a rarity these days. Most product landing page highlight adjectives and abstract value propositions with links to join waiting lists for 'priority' access - providing little insight into the value proposition of the product itself. Not to mention the gratuitous visual effects. So its a pleasure to see a thoughtfully done product landing page (which strongly signals that the same care will have gone into the product). The page is performant, no gratuitous visual effects. It clearly highlights the core product value propositions in the context of product visuals. Addresses key hesitations clearly and upfront (e.g. no cc required, pricing information), and a simple, obvious call to action. Hopefully more people follow this template than the slop generated by auto generators.

observationist 10mo ago
Clean, simple, information is where you expect it to be, links go to predictable places, exist in predictable places. Craft and care taken with little things are important, and this was well done.
thisislife2 10mo ago
> Kudos on the beautifully and thoughtfully designed landing page Can't say the same - The site shows me an empty white page in PaleMoon (with uBlock Origin Legacy enabled and web assembly and webGL disabled).
wvbdmp 10mo ago
I don’t like how the page disables pulldown-reload on mobile. I didn’t even think that was possible. Guess it makes sense when your page is a game of Tetris, but why here?! Sometimes I just like to overscroll a little…

atonse 10mo ago

I'm a huge fan of Postico. It does the one thing I need (DB data exploration and editing) and does it well. What I really miss in DB Tooling is something like SQL Compare and SQL Data Compare from Red Gate. It used to work with SQL server, and would compare two databases and produce "diff" SQL statements to get from one to the other. It was awesome for deployments. Most frameworks handle DDL via migrations, and that works well, but one-time data migrations that are tested in QA and should be pushed live... I've never found a better workflow apart from generating one-time scripts. Now with AI that's easier, but until recently, it wasn't. Not sure if that's the plan for this app eventually, but I sorely miss it, wasn't sure if others felt the same.

golemiprague 10mo ago

[dead]

arrowleaf 10mo ago

Taking a huge risk with the naming here, I would be expecting to hear from a Microsoft lawyer any minute (Due to MS's flagship 'SQL Server Management Studio'). e: Don't let this dishearten you, I only would consider a name change to be more of your own brand. When I saw 'SQL Studio', I assumed MS had created an online version of their product. This looks like a well-done passion project.

almosthere 10mo ago
Trademarks are complicated, but they probably won't let anyone claim SQL Studio
- Etheryte 10mo ago
  That doesn't matter if you run out of money before the end of the case.
  - almosthere 10mo ago
    true
mbreese 10mo ago
Not to mention that when you Google "SQL Studio", all you see are MS SSMS results.
deleted 10mo ago
[deleted]

reactordev 10mo ago

Do we still need tools like this (with a subscription) when we have AI? Don’t get me wrong, it’s definitely built with love but I haven’t used a tool like this (I used to use SQLTools in vscode) in about 4 years. Everything we do is via agents or in code.

nerdponx 10mo ago
Who's "we"?
- reactordev 10mo ago
  My company
  - gonzalohm 10mo ago
    Is your company a data company? Because I doubt you can get away with using agents to clean messy data from huge databases
llmslave2 10mo ago
Not everyone just mindlessly plays the AI slot machine to generate code these days.
zdragnar 10mo ago
And here I am, still writing sprocs for all of our business logic...
theappsecguy 10mo ago
People are outsourcing even basic sql to AI? Do you do any thinking for yourself still? I’m super curious what the AI brain rot will look like even 5 years from now when some senior dev can’t do a join without AI
- reactordev 10mo ago
  Well, we used ORMs for a decade and treated our code as schema. Now we hooked all that up to agents. I can still do a join and often write sql queries by hand to execute in a shell.

rafram 10mo ago

JetBrains' excellent DataGrip IDE is free for non-commercial use, and IntelliJ Ultimate (which includes the DB functionality in addition to every single thing in all their other IDE products) costs a little under 3x what you're asking for for this app alone. A bit of a hard sell.

Closi 10mo ago
Looks like the pricing is free or $4 per month - sounds reasonable?
usaphp 10mo ago
I would rather support a solo developer than a faceless corporation. Also Datagrip is $133/year for most use cases
adithyareddy 10mo ago
What pricing are you looking at? IntelliJ Ultimate is $199 a year - $16.53 a month. This is $4 a month.
deleted 10mo ago
[deleted]
9dev 10mo ago
Most JetBrains IDE's include the database tools actually, we use Phpstorm and PyCharm, and they come with fully-fledged database connection support; that includes in-editor completion of queries against your schema, by the way, in addition to the myriad of features DataGrip and the DB plugin provide. I wouldn't switch to any external tool anymore

almosthere 10mo ago

I really love it when a single dev makes something like this at a price point that's pretty cheap for us - potentially very lucrative for the developer. That's how we should be doing it - stop working for the man if you can!

deleted 10mo ago

[deleted]

dfabulich 10mo ago

This looks really cool, but I'm not going to use it today, because it only supports SQLite, with Postgres and SQL Server "coming soon." This seems like a very odd starting point, especially for a paid tool. I don't have any SQLite databases I'd want to explore, and certainly none with "massive tables." I'd want to use it for Postgres and MySQL/MariaDB first. Also, if autocomplete is what we care about, PRQL support seems like it will offer the best experience. https://prql-lang.org/ https://prql-lang.org/ PRQL queries transpile to SQL. Just having the `FROM` clause first does wonders for autocomplete.

SkiFire13 10mo ago
This reminds me of the pipe syntax for Google's BigQuery. Other helping with autocomplete it also significantly reduces the amount of WITH statements and subqueries needed

_s_a_m_ 10mo ago

why does a software like this needs a subscription?

mbreese 10mo ago
To make it sustainable. That's about the only reason, which given the recent TailwindCSS stories, isn't necessarily a bad reason.
- reactordev 10mo ago
  >”To make it sustainable” That’s a flimsy argument. Product sales can do that. Doesn’t need to be a subscription unless you know your market is weak or your data mining. We can’t be ok with everything being a subscription. You won’t have any money left or, worse, only the rich can afford the tools. I’m much happier paying for $60 Steam games and forgetting about them after a month. Sell this for $20 forever and do it 50,000 times by building a good product. If you get to market mass where you need a dev team to keep up with all the bleeding edge changes to SQL that are coming out, then charge a subscription.
oakesm9 10mo ago
I prefer the pricing model of TablePlus[0]. $99 for the current version forever with 1 year of updates. Once that expires you can keep using the last version you had access to forever, or get another year of update for $59. Fair and flexible for everyone. [0]https://tableplus.com/pricing https://tableplus.com/pricing
- thiht 10mo ago
  You can also renew at any time. I’ve paid for it in the past, at some point stopped using it for a few years, and when I started using it again I just renewed for a year to get a few years worth of updates at once. I like this pricing a lot too because you actually support and incentivize the development of new features.

metadata 10mo ago

I have recently asked my LinkedIn audience if my company should build a great PostgreSQL IDE. That's my wish for many years, and I know exactly where we can provide significant value over existing solutions. Yet basically everyone said not to do it. Too many free options, hard to get people to change habits, you can't charge enough because devs just don't want to pay if they can help it. I decided we will build something else. That said, good luck to this developer, I hope their product takes off.

cyberax 10mo ago

Thank you for not pushing yet another Claude wrapper and having a nice clean page! What is your timeline for Postgres support? I'll subscribe the moment it's available.

sroerick 10mo ago

This looks great, with postgres support I could see myself using this regularly. What is the landscape for simple tools for writing to databases? We used to have Access and simple CRUD tools. I saw a demo of Steve Jobs demoing NextStep which had this beautiful CRUD generator which obviously does not exist today. It seems like the landscape is basically Airtable, Retool, Google Forms or roll your own with a more sophisticated stack. I feel like it ought to be incredibly easy to build a form, either web based or native, which writes to a database. Yet it seems like we are farther away from this than we have ever been

larkost 10mo ago
The NeXT (then Apple) product you are talking about is/was WebObjects: https://en.wikipedia.org/wiki/WebObjects https://en.wikipedia.org/wiki/WebObjects It allowed for both HTML applications and Java apps (both JNLP and completely local). And before the transition to Java it was ObectiveC, and I think even had a scripting language (WebScript?). It was beautiful, fast, and for lots of things you could just wire up a small app to a database with almost no code (then later add the business code after the demo). One of my first jobs was writing a web app using it, and those were fun days. The EnterpriseObjects part (the part that managed data to/from the database) survived for a long time in parts of Apple's web back-end. And I have always thought that WebObjects was the model that Ruby-on-Rails was designed to mimic (in many ways, but not all). Edit: here is some documentation I just found: https://developer.apple.com/library/archive/documentation/LegacyTechnologies/WebObjects/WebObjects_5/WebObjectsOverview/WebObjectsOverview.pdf https://developer.apple.com/library/archive/documentation/Le...
- sroerick 10mo ago
  Fascinating! Makes sense that it would have been the inspiration for Rails
mamcx 10mo ago
Poor. My dream is to build such tool, I slowly doing in the side (https://tablam.org https://tablam.org). Probably need to ask for funding too. In concrete, what I want is a real alternative to Fox/Access that work, unrestricted, locally (including inside a phone/iPad). I don't mind have support for cloud stuff (that is what pay the bills mostly) but that is secondary IMHO. Current computers, even mobile, have far much power than most need, and is a shame not much tools actually exploit it.

exabrial 10mo ago

> Billed Monthly I'm out. I'll gladly buy a license though, exactly once. Willing to pay you for your time, but I'm tired of "rental economy".

zetalyrae 10mo ago
Unfortunately, I doubt this would be a sustainable model for the developer.
- PostOnce 10mo ago
  at $4 a month he is going to need one hell of a lot of customers and zero churn to even keep the lights on over his ramen bowl.
  - reactordev 10mo ago
    All it takes is some dev shop to say “give me 5,000 seats”
    - exabrial 10mo ago
      Your example proves otherwise: 5,000 seats x $200 price = $1,000,000 cash realized, right now, no debt financing needed for funding development, regardless if said dev shop leaves you. 5,000 seats x $4 = $20,000 month. That kinda pays the salary of a single FTE, and development ceases if customer runs away, only safe option would be to finance further development to insulate yourself from churn.
      - reactordev 10mo ago
        Bro, $200!?! For a SQL browser? Nah… $20 x 5,000 seats = $100,000 realized right now. With that, he could invest it, finish the features, start work on 2.0 and charge and upgrade of $20 to all his customers when he has MSSQL, MySQL, pgsql, SQLite, Oracle. 2.0 could include cloud db’s. Not everything has to be a subscription and if people continue to find value, they’ll upgrade if they think it worthy. Subscriptions tend to be vampires on the wallet and are used to trap users into paying a developer indefinitely. I consider it hostile to users. The exception is if it’s a service that can’t run on my machine. Or a service that does back office for me.

rgovostes 10mo ago

A business analyst friend of mine and SQL novice was given a multi-tabbed editor like this (edit: apparently it was not this brand-new app). We found it difficult to track which query and results tabs are linked, whether they've been refreshed since the query was edited, whether queries in a script have been executed out of order, etc. Hopefully there are ways to address those usability issues.

arrowleaf 10mo ago
This SQL Studio which was seemingly released to the public yesterday? Or are you talking about MS's SQL Server Management Studio? The MS one is a beast.
- WackyFighter 10mo ago
  Management Studio is a monster. I was using for years and every so often someone would show me a feature I was totally unaware of that blew my mind. Visual Studio also had "Database Project" which was amazing. Not seen anything like it. I think everyone moved over to using EF or Fluent Migrations but I loved the Database Projects.
  - wvbdmp 10mo ago
    Database projects are still there, I also love them.
- rgovostes 10mo ago
  Ah, I guess not then. I revised my comment. Maybe it was DBeaver, after all.

tacker2000 10mo ago

I thought this was from MS, who also has a program called MSSQL Management Studio, short SQL Studio. They will come after this for sure.

skeeter2020 10mo ago
The fact that some people may call it SQL Studio (never heard that personally) doesn't mean they will come after this "for sure". If anything SQL Studio is too generic to be valuable. Besides most people call it "Sequel Management Studio" anyway.
- kstrauser 10mo ago
  Or Microsoft Sequel Copilot any day now.
- caminanteblanco 10mo ago
  Well to my understanding, half of the point of trademark in the US is to prevent 'consumer-confusion' regardless of company interest
mfro 10mo ago
Never heard that. People call it SSMS.
- eXpl0it3r 10mo ago
  Or "Management Studio". Never heard "SQL Studio" either.

marktolson 10mo ago

Crashes on Mac trying to open up a fairly small workspace (max 97,000 rows).

internet2000 10mo ago

Looks nice. But not "Ready to experience the future?" nice.

remywang 10mo ago

“Made by a single developer” is only a selling point if it is someone with a strong track record to maintain the software, otherwise it’s just saying the bus factor is 1.

marcosdumay 10mo ago
This is you opinion. The author obviously prefers being transparent with it and using it to brag for anybody with an opinion that is different from yours. Not everybody thinks the same way.

ibejoeb 10mo ago

Is there a spec sheet or anything like that? I realize it's only for sqlite now, but supposing it's available for Postgres soon, I have a bunch of hard requirements. First is native support for SSH jump hosts. Next is query plan view.

cybice 10mo ago

I've known and used SQL for 25 years; over the last year I haven’t written a single query by hand - AI is very good at it. I use SQL editors only to quickly see what I have there and to check the AI-generated query.

jmye 10mo ago
Must be nice to only work with solid, well-documented data models. That sounds like snark, I guess, but I’m actually jealous. AI would choke on the last few “DWs” I’ve used.

remywang 10mo ago

Not to be confused with SQLite studio, which is open source and actively maintained for nearly 20 years https://sqlitestudio.pl/ https://sqlitestudio.pl/

xxdiamondxx 10mo ago

There’s also SQLPro Studio - the studio namespace is getting crowded! https://sqlprostudio.com https://sqlprostudio.com

wvbdmp 10mo ago
Since currently this only does Sqlite it’s probably fair to add https://sqlitestudio.pl https://sqlitestudio.pl, which I haven’t used heavily yet, but I believe is pretty excellent. And it’s open source.

potatoicecoffee 10mo ago

I'd love to see a new SQL program that focuses on the design view/access style with the tables joined with lines. For people who aren't used to code its the easiest way to get what is in each table

klustregrif 10mo ago

Really should consider supporting Oracle. So many companies are married to it, could even offer it under a corporate recurring license. It's easily worth the money to them.

caminanteblanco 10mo ago

It took me a second to realize this wasn't some cursor-style Microsoft replacement of SSMS, which would seem to lend some credibility to the potential for consumer confusion and trademark infringement, though of course IANAL

dylanzhangdev 10mo ago

There's already one available at https://sqlitestudio.pl/ https://sqlitestudio.pl/, which I've been using for many years, and it's very stable.

robowo 10mo ago

This looks cool and it hits a niche. There are suprisingly few good IDEs for DB work. I use DuckDB a lot for analytics tasks mostly in DataGrip but its not great. The alternatives like DBeaver are ok but not that great as well.

dbaman 10mo ago

Why should I use this instead of DataGrip?

mergisi 10mo ago

[dead]