recentpopularlog in

databases

« earlier   
PLV8 Documentation
PLV8 is a trusted Javascript language extension for PostgreSQL. It can be used for stored procedures, triggers, etc.
javascript  databases  postgres 
2 hours ago by gmisra
SQLBolt - Learn SQL - Introduction to SQL
SQLBolt provides a set of interactive lessons and exercises to help you learn SQL
programming_practice  databases 
yesterday by robjwells
Concordances
We collect concordances and mappings in a public database run with jskos-server. The database can be queried via this web interface and via an API at https://coli-conc.gbv.de/api/.
terminology  mapping  concordances  databases 
4 days ago by freemoth
PostgreSQL anti-patterns: read-modify-write cycles
It’s reminded me of another SQL coding anti-pattern that I see quite a lot: the naïve read-modify-write cycle. Here I’ll explain what this common development mistake is, how to identify it, and options for how to fix it.
concurrency  postgresql  databases 
5 days ago by ianmclaury
Attn Jon: Questions/Suggestions from someone hoping to convert to Bookends - sonnysoftware.com
"1. Bookends uses Valentina, which runs rings around MySQL.

https://valentina-db.com/en/

Note that there are other bottlenecks, though, such as some UI elements. My general advice is that you can handle 20-30K references easily. Above that you may notice some sluggishness.Although I know of one user with about 70K references, I wouldn't go above 50-60K myself in a single database. Of course you can have multiple smaller databases.

PDFs are stored on the HD, not in the database, so they don't affect speed *unless* you have many, many thousands. Since Bookends doesn't store direct links, but names, search speed can be affects. Again, we have users with 10;s of thousands of PDF with no issues. But be aware."
Bookends  storage  Valentina  databases  efficiency 
8 days ago by jschneider
Apache Cassandra
The Apache Cassandra database is the right choice when you need scalability and high availability without compromising performance. Linear scalability and proven fault-tolerance on commodity hardware or cloud infrastructure make it the perfect platform for mission-critical data. Cassandra's support for replicating across multiple datacenters is best-in-class, providing lower latency for your users and the peace of mind of knowing that you can survive regional outages.
databases  opensores  bigtable  cassanra  distributed.data 
9 days ago by po

Copy this bookmark:





to read