Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

SQLite Index Visualization

mrsuh.com

Post reply on HN
Print view View original

11–20 of 28 posts

Re: SQLite Index Visualization

#11

Post by gloflo »

salviati wrote: post #8

The term "indexes" serves both as the third-person singular present tense of the verb "to index" and as a plural noun form of "index." In contrast, "indices" is the traditional plural form of "index," particularly prevalent in mathematical and scientific contexts. While "indexes" is commonly used in general English, "indices" is often preferred in technical fields to maintain linguistic precision. Employing "indices"…

Says who with what authority?

All major RDBMS use the term "indexes".

Re: SQLite Index Visualization

#12

Post by CharlesW »

salviati wrote: post #8

The term "indexes" serves both as the third-person singular present tense of the verb "to index" and as a plural noun form of "index." In contrast, "indices" is the traditional plural form of "index," particularly prevalent in mathematical and scientific contexts. While "indexes" is commonly used in general English, "indices" is often preferred in technical fields to maintain linguistic precision. Employing "indices"…

FWIW, both are fine (https://www.nasdaq.com/articles/indexes-or-indices-whats-the...), and SQLite and PostgreSQL documentation (as two popular examples) use "indexes".

Re: SQLite Index Visualization

#13

Post by orthecreedence »

salviati wrote: post #8

The term "indexes" serves both as the third-person singular present tense of the verb "to index" and as a plural noun form of "index." In contrast, "indices" is the traditional plural form of "index," particularly prevalent in mathematical and scientific contexts. While "indexes" is commonly used in general English, "indices" is often preferred in technical fields to maintain linguistic precision. Employing "indices"…

It depends on your audience. If you're catering to academics, use "indices." If you're catering to the general person, "indices" comes off as pompous.

Re: SQLite Index Visualization

#14

Post by graemep »

IX-103 wrote: post #3

> I wanted to see how a database management system (DBMS) stores an index in both disk and memory, and how it searches through an Index...I chose SQLite for my experiments SQLite is a bit of an outlier in how it handles...everything, but even more so in query processing. SQLite tends to favor simplicity over performance, which causes it to implement things differently than every other DB I've worked with. You have to…

> SQLite isn't competing with other databases. It's competing with JSON and XML files for persistent storage

It competes with both. its clearly used for local persistent storage. SO are quite a lot of other things. It also competes with other RDBMSes where a separate server process is not a requirement.

That does mean it serves very different requirements, its just that its use case are a lot wider than just replacing JSON and XML files and similar.

Re: SQLite Index Visualization

#16

Post by euroderf »

salviati wrote: post #8

The term "indexes" serves both as the third-person singular present tense of the verb "to index" and as a plural noun form of "index." In contrast, "indices" is the traditional plural form of "index," particularly prevalent in mathematical and scientific contexts. While "indexes" is commonly used in general English, "indices" is often preferred in technical fields to maintain linguistic precision. Employing "indices"…

Try pluralizing "time series". You won't get far.

So what I've seen in Finland is people using "time series" for the plural and "time serie" for the singular.

Re: SQLite Index Visualization

#17

Post by threatofrain »

graemep wrote: post #14
IX-103 wrote: post #3

> I wanted to see how a database management system (DBMS) stores an index in both disk and memory, and how it searches through an Index...I chose SQLite for my experiments SQLite is a bit of an outlier in how it handles...everything, but even more so in query processing. SQLite tends to favor simplicity over performance, which causes it to implement things differently than every other DB I've worked with. You have to…

> SQLite isn't competing with other databases. It's competing with JSON and XML files for persistent storage It competes with both. its clearly used for local persistent storage. SO are quite a lot of other things. It also competes with other RDBMSes where a separate server process is not a requirement. That does mean it serves very different requirements, its just that its use case are a lot wider than just replacin…

> It also competes with other RDBMSes where a separate server process is not a requirement.

If you casually list off the top DB's either by usage or by recent hotness then almost all of them will have a server, but you'll also find they're basically all not embedded DB's with exception to RocksDB.

Re: SQLite Index Visualization

#19

Post by srcreigh »

orthecreedence wrote: post #13
salviati wrote: post #8

The term "indexes" serves both as the third-person singular present tense of the verb "to index" and as a plural noun form of "index." In contrast, "indices" is the traditional plural form of "index," particularly prevalent in mathematical and scientific contexts. While "indexes" is commonly used in general English, "indices" is often preferred in technical fields to maintain linguistic precision. Employing "indices"…

It depends on your audience. If you're catering to academics, use "indices." If you're catering to the general person, "indices" comes off as pompous.

Nope. Academics prefer “indexes” when discussing databases.

Re: SQLite Index Visualization

#20

Post by Terr_ »

euroderf wrote: post #16
salviati wrote: post #8

The term "indexes" serves both as the third-person singular present tense of the verb "to index" and as a plural noun form of "index." In contrast, "indices" is the traditional plural form of "index," particularly prevalent in mathematical and scientific contexts. While "indexes" is commonly used in general English, "indices" is often preferred in technical fields to maintain linguistic precision. Employing "indices"…

Try pluralizing "time series". You won't get far. So what I've seen in Finland is people using "time series" for the plural and "time serie" for the singular.

I wonder if one could make a grammar-argument that it's like "Attorneys General." :p
Post reply on HN