Live data from Hacker News

Poll: What database does your company use?

news.ycombinator.com

311–320 of 378 posts

Re: Poll: What database does your company use?

#314

SQLite all over the place – it's great having a super portable DB format for quick little hits. There's nothing quite like sending a DB as an email attachment.

In some scenarios I prefer Microsoft Excel over SQLite. Yes, Excel can be used as a database as well!

Do you mean as a database engine using the ODBC driver for Excel or as a database-like application?

Re: Poll: What database does your company use?

#315
post #83

Earlier quoted context omitted.

For me JSON has replaced SQLLite, with a large reduction in code and complexity. [ Admittedly I've written my own routines to access it more simply/directly on iOS ]

Yeah and like HTML5 has totally replaced our web server.

I left it unsaid that I assumed SQLLite was normally used in places other than the traditional back end server data store - I tend to use postgreSQL / mysql or perhaps a noSQL variant such as couchDB/Mongo for server-side data.

So I meant that instead of using SQLLite on mobile devices, pc based local fat clients or in the browser... I now use JSON now whereas I might have used SQLLite before [ I also use JSON where I might have used XML or windows config files etc ]

I did not intend to say JSON is replacing MySQL / PostgreSQL.

Re: Poll: What database does your company use?

#317
post #83

SQLite all over the place – it's great having a super portable DB format for quick little hits. There's nothing quite like sending a DB as an email attachment.

For me JSON has replaced SQLLite, with a large reduction in code and complexity. [ Admittedly I've written my own routines to access it more simply/directly on iOS ]

I also tend to use JSON as the main messaging format for Client/Server communications [ where I might have used sockets custom binary protocol previously ].

This means I can reuse the same REST style data 'provider' from within a Javascript web UI and within an iOS or Android client app.

So theres quite a few reasons why using JSON simplifies things for me - particularly I notice that there is a whole layer or ORM style boilerplate code that I dont need now [ whether its SQLLite Object or XML Object ].

I actually like the SQL Lite implementation!

Re: Poll: What database does your company use?

#318

Earlier quoted context omitted.

So does Chrome. Actually, this comes in handy: http://sqlite.org/famous.html

Ouch, Php got a mention, but they snubbed Rails, despite the fact that it comes bundled ... DHH won't like that one bit!

At this point, it would be faster for them to just list the companies who aren't using sqlite.

Re: Poll: What database does your company use?

#319
post #91

How about adding IBM's DB2, it seem there are very few companies actually using it.

A lot of companies use DB2, they just don't write blog posts about it.

When you have a problem with DB2, you don't write a blog post about it, you call IBM.

Re: Poll: What database does your company use?

#320
post #276
post #241

Earlier quoted context omitted.

Oracle costs at least twice as much as any other databases. Yet companies still buy it. Why do people buy things that cost twice as much? Hint: it's better. Forget price for a moment, any feelings you might have for Larry Ellison, the good/evil nature of the company, or whatever. Consider the software itself. Many people aren't all that familiar with the basic things a database is supposed to do. The list is large. I…

"Oracle remains viable, even as others continue to catch up, because Oracle builds on its solid foundation by adding additional capability and features relentlessly. I challenge you to read the new features guide for any new release of Oracle and to remember just the names of 20% of the new features. The Oracle documentation, as of 6 or 8 years ago (10g), was 40,000 pages. No telling what it is now. I can tell you th…

Or - as I picked up from some long forgotten blog post:

If you need Oracle, you'll know it. If you don't know that you need Oracle, you don't need Oracle.

I run MySQL, Oracle SQL Server, hundreds of databases, a couple in the 'many thousands of queries per second' range.

There are reasons for each database platform.

Post reply on HN