PostgreSQL Begins Landing LLVM JIT Support For Faster Performance

[phoronix]

Phoronix: PostgreSQL Begins Landing LLVM JIT Support For Faster Performance

The widely-used PostgreSQL database software may soon become much faster thanks to a work-in-progress LLVM JIT back-end that has begun to land...

http://www.phoronix.com/scan.php?page=news_item&px=PostgreSQL-LLVM-JIT-Landing

[clockley1]

One has to wonder how much further the FOSS ecosystem would have progressed if GCC had a modular codebase and a different licence. While GCC may emit better code no one else can use the technology.

[Chewi]

This = awesome.

[misp]

Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
Anyone knows if this changed?

[Chewi]

Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
Anyone knows if this changed?

There is pgAdmin. It's okay, not great, but I'm not very interested in GUI tools anyway.

[ctwise]

Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
Anyone knows if this changed?

There are query tools that aren't postgresql specific or open-source. DataGrip from JetBrains is an example.

[fuzz]

There is pgAdmin. It's okay, not great, but I'm not very interested in GUI tools anyway.

The new pgAdmin 4 is far better than the older desktop version, pgAdmin 3.

[coder111]

There's plenty Java/JDBC based tools that can work with multiple databases that also work nicely with PostgreSQL specific functionality.

Squirrel SQL is quite nice: http://www.squirrelsql.org/

DBeaver is freemium: https://dbeaver.jkiss.org/

There's SQL workbench (never used it): http://www.sql-workbench.eu/

DBVisualizer (freemium): http://www.dbvis.com/

Heidi SQL: https://www.heidisql.com/

And there's always default tools: command line psql and pgadmin3.

Also, IDEs like Eclipse, Netbeans, Jetbrains IntelliJ have tools to connect to a database and query it.

Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
Anyone knows if this changed?

[andrei_me]

Last time i checked there were no decent query editors / gui tools for it (opensource + gtk or qt5 based).
Anyone knows if this changed?

Can't say for sure, but I get used to using psql.

I've added to my bash_rc PAGER="less -S" then they results of psql are easier to read.

Also the tab autocomplete isn't that awful once you get used to it

[uid313]

Is the data type nvarchar part of the SQL standard? Or is it a proprietary data type?

PostgreSQL does not support the nvarchar data type, however all columns are Unicode anyways. But it means SQL scripts does not work and cant be imported without modifying the script and changing nvarchar to varchar. 😢

The SQL:2016 standard added support for JSON. PostgreSQL have JSON support, but its non-standard. 😢

PostgreSQL scatters binaries all over my /usr/bin/ directory. 😢