What are Reddit's favorite Relational Database Apps?
Airtable
PostgreSQL
SQLite
CockroachDB
MariaDB
Microsoft SQL Server
Apache Cassandra
H2 Database Engine
HSQLDB
CUBRID Database
MySQL Community Edition
Titan Database
Firebird
Oracle Database
QueryPie
Tibero
Top Reddit reviews mentioning Relational Database Apps:
>you cannot go crazy if you do not play a couple of games or three games
This.
McTominay played for 22 games this season. And he's a youngster.
Lingard played for 47 games although he wasn't really first choice at the start.
Herrera himself played for 38 games despite Pogba-Matic seemed to always play and never get subbed off.
Even Luke Shaw got himself 19 games.
So I don't think Martial and Rashford, who respectively played for 44 and 51 games this season, have any reasons to be concerned. Even with Sanchez's arrival, Jose showed that he wasn't afraid to sub off/drop Sanchez, so they will still have their opportunities.
UPDATE:
Here's a comparison of Sanchez, Rashford, Martial, and Lingard since Sanchez arrived (data from transfermarkt). TL;DR:
- Sanchez started in all his appearances and played more minutes than others. He has the best stats out of 4 though.
- Lingard played in the most matches.
- Rashford came in as sub 10 times.
- Martial had some injury problems for a couple of weeks, otherwise I'm sure he could've had more minutes.
- Martial had 0 goals and only 1 assist during that period.
- All four of them could've performed better.
Most store XML as text however, and that's not terribly useful if you need to do any queries within it. However, Postgres supports storing JSON using a decomposed binary format so that it can be searched and indexed like regular columns. So, if you're looking for a relational DB with JSON support it's hands down the best choice right now.
The Bernie campaign needs Iowans who can provide housing or know of low cost housing options for out of state volunteers! Please share this link with Iowans https://airtable.com/shr3PnUTrAIRciTFb and join /r/IowaForSanders
Some languages (locales) treat V and W as the same. This "feature/bug" is actually quite common.
Personally, I like the disclaimer at the beginning of the SQLite source code, which is in the public domain:
** The author disclaims copyright to this source code. In place of ** a legal notice, here is a blessing: ** ** May you do good and not evil. ** May you find forgiveness for yourself and forgive others. ** May you share freely, never taking more than you give.
Because of the hype, basically. The times when Node.js and MongoDB became buzzwords overlapped enough to make the combination an "obvious" choice. Especially with MongoDB using JSON for everything (even as a query language).
Basically what made MongoDB so successful is that it was one of the first widely-recognized NoSQL solutions in a time when everybody thought they had "Big Data" and needed a database that was built for scalability first (and integrity last).
Additionally "MEAN" provided a nice buzzword and now the idea that Node.js and MongoDB go together perfectly is stuck in everyone's head and the media (i.e. bloggers and tech websites) perpetuates it because they're too lazy to do the research to come up with someone more practical.
I would strongly recommend against MongoDB, especially as a "default" when you don't know your actual requirements. There are plenty of viable databases (non-relational and relational alike) and by all likelihood MongoDB is not the best fit for your project's requirements.
Personally, I prefer ArangoDB these days (disclosure: I've become a maintainer because I was already using it and interested in working on it). But I'd say for most projects PostgreSQL is a good default. Of course nothing beats actually doing your homework and seeing what database fits your project best before you pick it.
So, for a while now, I've been trying to use some of the data I've been gathering to make some cool infographics... except I'm rubbish at it. So I figured I'd free the data and let people who know what the hell they're doing have fun with it. (you can download a csv file from the ellipsis in the task bar at the top)
Howdy, author of The Program audio series here. A few days ago, The Program got featured on Apple Podcasts. And while it's not the first time the show got promoted by Apple, this is the first time it was showcased directly on the front page of the biggest store - the US one.
How did it happen? I was lucky Apple opened "Alternate Realities", a category that fits my podcast to a T (the show is set in a world in which Money, State, and God became fused into a single entity called the Program), and fortunate that one of the editors of the Canadian store endorsed my pitch for The Program to be included (pitches are open to everyone, but the US store is inundated so it helps if you have someone to vouch for you).
As you can see from the chart, the show has been getting between 150 and 250 downloads per day in the period before it got promoted (it's currently between seasons so the numbers have been low but stable). After the promotion, it shot up to over 700 downloads per day, and I have a feeling it might plateau there.
I have no idea how representative these numbers are, but thought some people might find a data point like this interesting.
The Program comes for us all. (Really - new episodes start running in August!)
You install a server. Go here and click "download now" on Developer edition.
https://www.microsoft.com/en-us/sql-server/sql-server-downloads
After installation you can connect to localhost, which is your local computer.
This is the link I got in the email!
Configuring postgresql's replication it's not that difficult after 9.0 Docs
This is master/slave though. So if you need sharding or a master/master setup you would have to look into other solutions.
10 + 3 more actually, and 10 of them will be discussed during their conference this Friday. Here’s a tool to keep up with all these cases:
https://airtable.com/shrcrC5FsedZqIi3T/tblMclNyymYiklOOg/viwM47ZZsFWQo69Vf?blocks=hide
The Bernie campaign needs Iowans who can provide housing or know of low cost housing options for out of state volunteers! Please share this link with Iowans https://airtable.com/shr3PnUTrAIRciTFb and join /r/IowaForSanders
Yep, looks like it. Found the listings here for anyone who wants to give acting a go. You get paid ok for some easy work but long hours. Sometimes just paid to do nothing.
That's great. Glad to help. Here's a link to my full spreadsheet which includes nutritional info for a lot of stuff. It's not very polished but gets the job done for me, and it's ever evolving. You're welcome to download it and use it to kick start your own if you want.
So here is the current spreadsheet for my trades this week. It's just a rough version for now because there are so few entries.
When I get more data I will probably break these up into sections to focus on each trade type. One for Breakouts, one for EP, one for Other (market timing plays like these ETFs basically). I want to break down these trades in detail and get data such as winrate, average loss size, average win size, and so on, but that will take time.
I believe this is a permanent link that will be updated as I update the spreadsheet. I'll try to update as often as possible but I can't promise it will be every day.
I believe this is the intended ideal for the team. They want to focus on the database, not the implementation. After a long time of not supporting replication they gave in with this statement:
The team recognized the need for basic replication services but also realized that by packing in too much they may hinder more specialized solutions from being developed. I can agree with this statement since most people will take the path of least resistance, ultimately ending with a bunch of poorly scaled apps or with the team having to focus on implementation scenarios and not the core DB.
Hooray! Our story is nominated for 2021 WEBTOON CANVAS.
This award will go to the one with the most votes. Please vote for us!
Link for voting: https://airtable.com/shrmlkGVg2pxEEY8K
(Our story is the first one under “Comedy” category.)
(Please attach the screenshot with your nickname on WEBTOON for identification.)
Thank you all for the support and encouragement for HOW TO BE A MIND REAVER. Your kudos mean everything to us.
FYI THE DEADLINE TO TRANSFER YOUR EDC 2021 TICKETS TO EDC 2022 IS APRIL 15TH (NEXT THURSDAY)
If you miss the deadline you either have to bite the cost, sell your ticket or go anyway.
You need the 64bit Firefox on Windows and you need to go to a page that supports the WebVR API. There are a lot of examples here: https://airtable.com/embed/shr2Lc7pmlJis02R4/tblZbV2S0W0T5DDth?viewControls=on
The specific case referenced above is:
New York State Rifle & Pistol Association, Inc., et al., Petitioners
v.
Kevin P. Bruen, in His Official Capacity as Superintendent of New York State Police, et al.\
ARGUMENT SET FOR Wednesday, November 3, 2021.
Key point:
> Petition GRANTED limited to the following question: Whether the State's denial of petitioners' applications for concealed-carry licenses for self-defense violated the Second Amendment.
I don't see any point to adding your name to a list for USCCA. SCOTUS doesn't make rulings by petition. And I am a member of USCCA.
Yes, you can use SQL Server 2017 Developer. It's free to use for learning. They say:
"SQL Server 2017 Developer is a full-featured free edition, licensed for use as a development and test database in a non-production environment."
Download here.
Hey Kago! I'm the author of Psion's Primer. Thanks so much for using my book in your games!
Unfortunately, I don't know of any apps to help with creating a character with the Primer. There is this helpful link to an airtable database that will at least let you search for powers in various useful ways.
https://airtable.com/shrn1ESJxmLknGiSh
Sorry I couldn't be of more help!
I recommend reading this article first: http://www.sqlite.org/cvstrac/wiki?p=ScrollingCursor
We are going to provide a built in solution that works with recycler view but that got pushed back due to other priorities. (In terms of API, it is very tricky) We are not providing a cursor wrapper because there is some fundemental problems with it (which we will document). If interested in learning why, i recommend reading its C source code.
For now, your best option is to implement what that article suggests and then watch out for the paging artifact that will arrive soon.
MVCC is not that difficult to reason about, the PostgreSQL documentation page linked in the article does a pretty good job of explaining the possible levels and concurrency gotchas: http://www.postgresql.org/docs/9.4/static/transaction-iso.html
But the most important distinction between relational databases with MVCC and various "eventually consistent" databases is that you only have to understand MVCC, not implement it. You read the docs, choose an isolation level that fits your concurrency and performance goals, wrap database calls in transactions, and you're done.
If you wanted to get similar concurrency guarantees from many other eventually consistent databases, you would still come across the same gotchas, but now you also need implement the solutions in your application code.
PostgreSQL has had pretty decent JSON support since 9.1, and it's been getting better since then: http://www.postgresql.org/docs/9.4/static/functions-json.html
Adding a JSON field into a relational table can be pretty good approach to a number of tricky scenarios, especially avoiding pivots for settings and the like. Array support in PostgreSQL is also very nice.
that's so lovely. is there a source you happen to have handy?
no pressure. i'm just toying with the idea of expanding this, which was originally made as a just a net to catch all the beginning-of-a-new-cycle. everything there can be filtered, sorted, downloaded, whatever
The only thing I could think of that might have more than 64,000 lines is the sqlite amalgamation source code. Sqlite recommends using the "amalgamation" that is all of their source code thrown into a single file.
$ wc -l sqlite3.c 128415 sqlite3.c
PostgreSQL used to have an option to work that way before postgres version 6.2.
>> Postgres supports the notion of time travel. This feature allows a user to run historical queries.
>>
>> ....
>>
>> For example, to find the current population of Mariposa city, one would query:
>>
>>SELECT * FROM cities WHERE name = 'Mariposa';
>>
>> ...
>>
Postgres will automatically find the version of Mariposa's record valid at the current time. One can also give a time range. For example to see the past and present populations of Mariposa, one would query:
>>
>>
SELECT name, population
FROM cities['epoch', 'now']
WHERE name = 'Mariposa';
>>
>>
where "epoch" indicates the beginning of the system clock.
>>
>> ...
>>
>> As of Postgres v6.2, time travel is no longer supported. There are several reasons for this: performance impact, storage size, and ..... Time travel is deprecated: The remaining text in this section is retained only until it can be rewritten in the context of new techniques to accomplish the same purpose.
Yes you can count the number of recipes with chicken as one of the ingredients:
# create table recipes (name text not null, ingredients text[] not null);
# insert into recipes(name, ingredients) values ('yum', '{chicken,butter}'), ('sandwich', '{chicken,bread}'), ('breakfast', '{cereal,milk}');
INSERT 0 3
# select name from recipes where 'chicken' = any(ingredients);
name
----------
yum
sandwich
(2 rows)
# select count(*) from recipes where 'chicken' = any(ingredients); count ------- 2 (1 row)
Using an array as part of a join clause:
# select a.name, b.name from recipes a join recipes b on (b.ingredients[1] = a.ingredients[1]);
name | name
-----------+-----------
yum | sandwich
yum | yum
sandwich | sandwich
sandwich | yum
breakfast | breakfast
(5 rows)
I don't know if you can make an array an index, but you can use a partial index on an array expression:
# create index on recipes(ingredients) where 'chicken' = any(ingredients); CREATE INDEX
That said, if you're doing a lot of array fiddling, then that is generally a sign that you should probably be using a separate table.
✨Luna’s persuasion spell worked
“Edd Lai’s Stories (How to be a MIND REAVER)” is nominated for Outstanding Comedy Series at #CANVASAwards2021!💖
If you have a moment to vote, please do.
https://airtable.com/shrmlkGVg2pxEEY8K
✨PERSUASION
Go to our #Kickstarter page 🐙
https://www.kickstarter.com/projects/antler-studio/how-to-be-a-mind-reaver-vol1
Hooray! Our story is nominated for 2021 WEBTOON CANVAS.
This award will go to the one with the most votes. Please vote for us!
Link for voting: https://airtable.com/shrmlkGVg2pxEEY8K
(Our story is the first one under “Comedy” category.)
(Please attach the screenshot with your nickname on WEBTOON for identification.)
Thank you all for the support and encouragement for HOW TO BE A MIND REAVER. Your kudos mean everything to us.
It all depends on the game.
Some games are locked to 30FPS regardless of whether you're playing in 1080 or 4K mode.
Some games have a toggle that allows you to choose between 60FPS (at a lower resolution) or 30FPS (at a higher resolution).
Finally, some games will run in 60FPS in 1080p mode by default.
​
In my database (this is *not* an official Stadia resource), I've noted which games run at 60FPS in 1080p mode if they're 30FPS in 4K mode :)
https://airtable.com/shrfGjd2PmisPQp9g/tblOtOJpdl0qGsk4u
Kurz, 20€ pro Stunde + 250€ einmalig pro sub, welches Moderatoren und ein paar Posts und/oder Kommentare hat, die nicht von dir sind. Insofern doch, Werbeerfolg bringt extra.
If anyone would like to see more of my pixel counts, here's a link to my database 🙂
https://airtable.com/shrHXaF85D1upSKSs/tblVXkiYyDsFwmiMa
I'm still in the process of filling in the gaps, but I try to get big releases done on their launch day 😁
Hi - Jeff from the Apache Cassandra PMC. Apache Cassandra is a NoSQL, Big-data database, which seems to hit a handful of your tech/interests.
We're always looking for people to work on new stuff. It can be very, very basic, or more involved. If you've never used cassandra, check out some of our low-hanging-fruit JIRA tickets.
Low hanging JIRAs are here: https://issues.apache.org/jira/secure/IssueNavigator.jspa?reset=true&jqlQuery=project+=+12310865+AND+labels+=+lhf+AND+status+!=+resolved
Instructions on how to contribute are here: http://cassandra.apache.org/doc/latest/development/patches.html
If you're wondering WHY you should work on cassandra, consider this: it's used by companies like Facebook, Apple, Netflix, Walmart, Uber, and Microsoft.
If you need help, #cassandra-dev on freenode is typically responsive during PST business hours. The dev mailing list is active, and you can email me directly (my reddit username @ gmail, or @ apache, or whatever you prefer). I'll help review+commit your contributions, just nudge me to get my attention.
Why would you use MongoDB? PostgreSQL does the same thing, but faster using jsonb and GIN indexes: http://www.postgresql.org/docs/9.5/static/datatype-json.html - Why limit yourself to a document store that is only slightly better than writing files to a tmpfs partition?
> If you know your data access pattern is going to be complex or you plan to use a lot of database-specific features (like PostgreSQL window functions), you may not want to use an ORM.
i hadn't ever heard of those before. damn, i could have solved a lot of problems with those. need to start paying more attention to databases.
also, thanks for telling people not to bitch about ORM by bitching about ORM. ;)
Popular, well designed standard library, fast compiling, lightweight, binary-to-deploy, Google-backed...
I always go to Go when writing small projects, at the same time sadly remembering the time I thought Ocaml was going to be this popular, 10 years ago.
A big product from Xooglers: https://www.cockroachlabs.com/blog/cockroachdb-1-0-release/
So in some way Go is so crippled, in another way so many cool projects are written using it and not Python/Java/C#/Haskell...
The varchar instead of text recommendation would appear to be wrong:
> Tip: There is no performance difference among these three types, apart from increased storage space when using the blank-padded type, and a few extra CPU cycles to check the length when storing into a length-constrained column. While character(n) has performance advantages in some other database systems, there is no such advantage in PostgreSQL; in fact character(n) is usually the slowest of the three because of its additional storage costs. In most situations text or character varying should be used instead.
http://www.postgresql.org/docs/9.1/static/datatype-character.html
Hard to say, but generally the more components a system has the more likely is that it's going in the "stupid" direction. Keep it as simple as possible.
Postgres is a very powerful database, maybe you can just implement your unstructured data in there. Check the hstore datatype, it's a key - value store but you will be able to access the data in it together with your structured data in a single SQL statement. Has index support, special query operators etc... pretty neat.
He has a dedicated form to submit scams. I've submitted a few myself.
https://airtable.com/shrLNrKjBPakr6J8u
Also I can't recommend his content enough. He never fails to make me laugh, his improv is great, and he's super wholesome.
I’m 34 and I have 149 items active or in “purgatory” (a place for clothes I am thinking of getting rid of). I track everything in my spreadsheet . My impression is like the Pareto rule in economics, 20% of the clothing gets 80% of the wears. Like leggings and shelf bra camisole are my top items by a long shot.
But they are very clear about that pretty much everywhere in the documentation.
The library itself is extremely well written and tested. Check out their bug tracker
There are like 2 active issues and this year there has been something like 20 issues opened. For a library so heavily used by everything, that is really impressive.
Hmm. After thinking about it. I don't agree. Don't store phone numbers as integers, even if it is only a supporting column for indexing. If you need to index on it for reverse lookup of customers you are far better off stripping the special characters and store it as a string and index the result. This way the like operator and other fuzzy logic in the DB still work and you can implement a much more flexible solution for revers lookup. Your data isn't so big that you need the performance boost of using integers for indecies.
If you aren't planning on doing mathematical operations on a field then don't make it numeric. ID's aren't special cases either; we increment those, thus they are arithmetic in nature.
I'm here to share, and also maybe check for errors.
I've been trying to find a good dmc database for a while, and none have been quite right. The last one I used had no way to transfer info onto a different brand phone, and I've never felt more defeated.
I found airbase on the fountain pen community, and after creating a pen data base I started building one for thread. It's on the cloud and you can access it on phone or computer, and you can share your thread list with friends. You can copy my data base, then add/change/remove records, columns, and tables as you please. I'm in love with this.
A note: There are a few hidden columns, "colour order" being one. This is so you can go back to a perfect rainbow-sorted-grid if you need to sort by a different field. So maybe don't delete that. Ctrl+F to find a dmc number. I also added a "sample projects" tab, as an example of linked records. I'm going to keep track of my projects that way too. The two patterns there are ones I made myself screwing around photoshop, feel free to use/share them.
So ya. I hope someone finds this useful.
✨Cthu needs your help!
“Edd Lai’s Stories (How to be a MIND REAVER)” is nominated for Outstanding Comedy Series at #CANVASAwards2021!💖
If you have a moment to vote, please do.
Fill out this form for the Colorado Mask Project:
https://airtable.com/shryiLLA9VR0EaNQ6
It sends a request to all the Colorado-based volunteer mask sewing organizations including the one I'm a part of, Cover Up Colorado. If you're comfortable sharing the name of your nonprofit, I'll look out for your request when we divvy up next week.
Very true.
That being said, the original maintainers of MySQL (who now regret selling their database) have forked the code base and are now working on a drop-in replacement called MariaDB. From their webpage:
> MariaDB is the compatible successor to MySQL, the world’s most popular Open Source database. MariaDB has greatly improved scalability and performance, engines for NoSQL and volume transaction processing, and clustering capability. The MariaDB client libraries are available under the liberal LGPL license, enabling a new generation of commercial applications.
Edit: Just realized my wording makes it look like MariaDB is a new project. It's been around for 2+ years and it's quite production ready. By 'working on', I mean actively developing and adding new features.
As an aside: for an example of a project doing it right -- hell, they've been accused of overdoing it, look at what SQLite does:
- 100% test coverage
- no bug is fixed without a new test
- 1200 times as much test code than actual code
I don't think SQLite would ship a release with a failing test, let alone 200.
PostgreSQL fulltext search is very capable, and since you are on Heroku, you are probably running postgres already.
Have a look at the excellent postgres doku: http://www.postgresql.org/docs/current/static/textsearch-intro.html
Hey I think this is a good idea!
I'm more of a poler than an aerialist, but I think there is some crossover to silks and lyra etc. And also loads of arguments about what everything is called!
I reckon some gifs or videos of getting into/out of moves would be great.
/u/matak89 built a searchable database of exercises that has simple gifs and filters which I really like:
https://airtable.com/shrKZ9lPpw7EvjZ3X/tblvscpkbagqlWKkH
Maybe your app could start off with similar information? Exercise, equipment, video, modifications etc
You could also include a section on ground-based prep work (like core) that doesn't require any aerial equipment.
I'm also a software engineer so can help out with development, and taking videos/photos :)
For those asking, I can confirm it's 1080p60.
If you don't know, I'm the guy who pixel counts all the games on Stadia (and tries to get developers to confirm the information)
These implementations don't quite work, as described in the issue. This will round 0.5 to 1 (and -0.5 to -1) which probably isn't what's intended.
This is probably why the proposal was accepted. There are lots of edge cases and it's easy to have mostly working versions which are still subtly broken.
Edit: See https://www.cockroachlabs.com/blog/rouding-implementations-in-go/ for more info. My explanation wasn't completely right. This implementation will also round things like 0.499999999999999999999994 to 5 as well.
The PostgreSQL "text" and "varchar" column types require their data to be valid in their configured character set; encrypted data is by design indistinguishable from a random sequence of bytes, and so is unlikely to be valid in any given character set.
Use a column with the bytea or blob types instead.
It's in progress, there's a long pgsql-hackers discussion going on where they're finalizing the details: http://www.postgresql.org/message-id/CAM3SWZQ7PdxFhg-B6EN80N3X0=raeyOFXxeweU2pF09hOQUb1Q@mail.gmail.com
He talks about how cheap PostgreSQL is. It's true that it's fine to use PostgreSQL and not give something back, but if you're a big Postgres user you should consider donating money. http://www.postgresql.org/about/donate/ Donate as much as you think it's worth if you can afford it. The project has to be financed somehow. :)
> well, then give the people the means to send the computation to the database in an extensible fashion, duh.
That's actually exactly what PostgreSQL does. And, guess what? Someone used that feature for geographic data. So if you're interested in raging at someone, maybe direct it at the people who are actually (not) doing what you're complaining about.
Also, maybe divert a little bit of your energy for swearing and claiming the world is stupid into forming your thoughts into text that more successfully conveys your original meaning.
> SQL Server. It is free on the low end and has some pretty cool features that kick in at 10 million or more rows.
Its restrictions are terrible.
> Maximum memory utilized (per instance of SQL Server Database Engine) > 1 GB
> Maximum relational Database size > 10 GB
This is a joke comparing to PostgreSQL
https://github.com/wtsxDev/Penetration-Testing/blob/master/README.md#books
The folks here archived all the youtube videos: https://airtable.com/shrfo1SnkHU7WHPbD/tbluePnB9jak7hB2l/viwEbHN7wDsFwvFVo?blocks=hide
This statement by former federal prosecutors has 961 signatories.
In their words:
>Each of us believes that the conduct of President Trump described in Special Counsel Robert Mueller’s report would, in the case of any other person not covered by the Office of Legal Counsel policy against indicting a sitting President, result in multiple felony charges for obstruction of justice.
Like I said, I agree.
- https://michellawyers.com/firearm-litigation-case-tracker/
- https://airtable.com/shrcrC5FsedZqIi3T/tbl5F8BBhahmC7MqH/viwtffYCYAnCyuUox?blocks=hide
But pick a random case. Click the docket. Click County or State Court of Appeals. And read some of the bullshit that spews forth from liberal judges mouths in their judgements. Then correlate who appointed them.
It's like they don't even think regular people with two grey brain cells to rub together reads these things. And then it becomes "precedent" because their peers and superiors in SCOTUS don't call them out on this nonense.
The Courts have become the legal version of Idiocracy in their fever-dream of "Orange Man Bad". Even if he was bad. Even if he is now gone. That's what I'm commenting on.
Mad props to FPC. But we're past the Soap, Ballot, and Jury boxes at this point. And Ammo box is being "common sensed" into oblivion with Rona pricing and Rhode vs. Becerra $19/30-day registration and background checks.
SQL is a query language for relational databases. It's also used as an umbrella term for the family of databases that support it - MySQL, Postgres, Vertica, Microsoft Access, etc - there are many. A SQL database would be an ideal solution to your problem. I would recommend using SQLite for this (the other databases listed are typically accessed from servers, while SQLite is built for being used from client applications).
Whatever database you end up using, you'll need to download a java driver for that database (SQLite actually has multiple java drivers to choose from. They're listed here: http://www.sqlite.org/cvstrac/wiki?p=SqliteWrappers).
Phew... that's even tougher.
If I understand your question you're asking how to go about writing/implementing/creating/programming from scratch a database engine, similar to postgress, Oracle, etc.
A database engine is a really big project with lots of high level components (network communication, interprocess communication, SQL parsing, query planing and execution, etc etc etc).
Probably the smallest database engine I know of is http://www.sqlite.org/. It's source code is likely (perhaps, maybe, you never know) the least complicated. If you spent enough time study it that should give you some ideas of how to proceed.
If I was going to design and build a database engine I'd start with design of the SQL language variant I'd want to support. This would require considerable knowledge of parsing and compiler construction. In and of itself I'd expect this to take up to several months just to specify the language. The building of a parser who's output could be used for a query planner/execution engine would take several (maybe many many) months after that. And this would still leave all the low level nitty gritty handling of disk storage/retrieval (and how to accomplish ACID transaction in the face of power failures etc). And this wouldn't be multi-user, no networking layer, and none of the really advanced features (replication, sharding, high availability, etc).
Think of the biggest model train (eg. http://www.telegraph.co.uk/news/picturegalleries/howaboutthat/5043783/The-worlds-biggest-model-train-set.html) and what you'd have to do to make literally everything from the ground up (eg. paint, glue, nails, rails, wire, glass, not just the beautiful models that are visible). It's that complicated.
So as a long term hobby, say 10, 15, or 20 years, it certainly would be possible to create a full fledged database engine comparable to postgress/oracle/sql server/etc.
Start with the name :)
While the manual isn't a tutorial, it's one of the most valuable resources to learn and understand Postgres
> The ivory tower types figured out a lot of the fundamental algorithms, then later Postgres implemented them.
Especially in PostgreSQL's case, with its pluggable types and indices support. For example, pgSphere uses GiST indices to make queries using spherical operators perform well.
Check out PostGres SQL and PostGIS: http://www.postgresql.org/download/ You can install PostGIS after installing Postgres. You should also get pgAdmin so you can check out and play with the database easily. http://www.bostongis.com/?content_name=postgis_tut01
I heard ya'll into starter themes so here's a tldr'ish list of all the best Wordpress starter themes. For those looking for a simple list, here's a table showing all the starter themes.
Let me know if I've missed something or there's incorrect information.
✨Cthu needs your help!
“Edd Lai’s Stories (How to be a MIND REAVER)” is nominated for Outstanding Comedy Series at #CANVASAwards2021!💖
If you have a moment to vote, please do.
I love it!
Make sure you submit the idea to the team!
https://airtable.com/shrTvUvPgxgDJiadq
Edit: the link can also be found in the sidebar if anyone else wants to suggest something in the future.
I really enjoyed Janua Vera a lot, and my expectations were very high for Gagner la Guerre. The author has a lot of potential, his writing is very good and his research really shines through it.
However, I could read about a third before giving it up, because it is the epitome of toxic masculinity. It is sexist, homophobic and racist as a general background, and (not a spoiler, but a CW following) >!the rape scene seen from the eyes of the rapist, concluded with a dash of humour is simply unforgivable to me!<. None of those issues are questioned in the book. Who does the author think he is writing for? Does he not see he is normalizing rape culture and validating it? It is a book that marginalizes such a big portion of humanity that I am still shocked by it.
I am also furious at fans who recommend it without giving appropriate content warnings. I suggest to everyone thinking about reading it to refer to this airtable where all the CW are listed.
I have not seen Jacqueline Carey mentioned yet! She wrote several series, but I can only vouch for Kushiel's Universe so far; it's 3 trilogies, so the criteria: long = check! It has romance, although it is far from being the main focus, but it contains a lot of very graphic sex scenes. The protagonist is also female. It comes with a lot of content warnings, that you can find in this airtable where we compiled all the novels from the top lists that have been run on the sub. You can also have fun selecting woman writer and high fantasy and see what results you have!
> Das sind die Nachrichten, die deutschsprachige Mods erhalten haben: > > • https://i.imgur.com/Zhl2W2g.png > > https://airtable.com/shrfGjd2PmisPQp9g/tblOtOJpdl0qGsk4u/viwoqJOKMQtthS8vl/reci17eETru4LBreX
Ganz ehrlich, wer wird denn freiwillig unbezahlter Mod für so einen Sub? Die Hauptarbeit beim etablieren tragen nunmal die Mods, und bezahlt wird dafür am Ende nur der Ambassador?
Not sure if this will help, but Dr. Gray on youtube does application renovation videos that might be helpful! He could also submit his here https://airtable.com/shr3doGRGedLQPykM
I made an air table (spreadsheet) of all of them...if anyone wants to help flesh out the columns with numbers, emails etc...I'd love that :)
Link:
I'm very skeptical that this data is accurate and/or up-to-date. This AirTable compiled by the COVID Tracking project shows that only six states have public-facing dashboards reporting vaccination data, and even those are more than 24 hours out of date.
States are clearly focused more on getting jabs into arms than reporting data to the public.
First answer: Since the story broke we've talked to a half-dozen authors with strikingly similar stories. With permission, we've given Disney the names of some of those authors, hoping that they would reach out, but their policy is that the initial contact must come from the author.
The good news is that we do have a point of contact at Disney now and are beginning the long conversation process.
In addition to helping Alan Dean Foster connect with the licensor to begin negotiations, we also suggested several steps Disney could take to avoid non-payment of royalties in the future. These steps included:
- adding an FAQ about missing royalties to their licensing website
- having an identifiable contact point
- proactively looking for authors who may be missing payments/statements due to an acquisition or other reasons.
The biggest problem with their policy that the contact must begin with the author is that the only way to know the right person to talk to is if you know me. That's... not an ideal process.
You can help us spread the word about #DisneyMustPay to other authors to contact our organization through this form so we can connect them to Disney.
Second answer: Ursula K. LeGuin, Guy Gavriel Kay, Nalo Hopinkson. Comfort reads? Persuasion by Jane Austen
Third answer: Really good dark chocolate.
SQLite has some pretty damning words about compiler warnings (in particular Visual C++).
> VC++ often will generate a number of warnings from SQLite source code, but the experience of SQLite developers is that VC++ warnings are of lower quality and can be safely ignored. Users are encouraged not to stress over VC++ warnings.
> Static analysis has not proven to be helpful in finding bugs in SQLite. We cannot call to mind a single problem in SQLite that was detected by static analysis that was not first seen by one of the other testing methods described above. On the other hand, we have on occasion introduced new bugs in our efforts to get SQLite to compile without warnings.
Of course, your code is not tested as well as SQLite is.
Sounds like GIN fast update.
Turning off autovacuum for the table makes it likely that the maintenance on the GIN index - writing the temporary updates to the index as a bulk update - will be triggered by a query that pushes the space used for it over the limit, rather than during background maintenance.
> I need the flexibility provided by mongoose documents.
Look into Postgres — it has JSON support with efficient storage, lookups and full-blown indexing. I believe it even outperforms mongo v2, both in storage and performance, not sure how mongo v3 compares though.
LOL at FUD "To do the same in PostgreSQL, Microsoft claims that you need to use a combination of then json_each, json_object_keys, json_populate_record, and json_populate_recordset functions"
Looks like they didn't read the http://www.postgresql.org/docs/9.4/static/functions-json.html especially json_to_recordset
Run postgresql over ssl and use ssl certificate authentication.
http://www.postgresql.org/docs/9.1/static/ssl-tcp.html
(though i would probably hit haproxy on the localhost and use haproxy to run the SSL certificate auth to the DB servers. )
The Bernie campaign needs Iowans who can provide housing or know of low cost housing options for out of state volunteers! Please share this link with Iowans https://airtable.com/shr3PnUTrAIRciTFb and join /r/IowaForSanders
The first link is down right now while we update the site! Here's our petition to support relationship diversity
https://airtable.com/shrdP9C8TTR7Vdm8e
We're also on Facebook and Twitter @Div44CNM if you guys want to see the latest stuff when it posts!
I'm on iOS and as far as dedicated wardrobe apps I've only used Stylebook, but if you're into seeing different statistics and ways of viewing and categorizing your wardrobe you might also consider using Airtable, which has a desktop app and a mobile app. It's free, though there are paid tiers. If you're only doing it for personal use imo the free tier is plenty.
I use it like this and I have the template available here. But if you're mostly interested in a feature that lets you build polyvore style outfit collages, this isn't going to do that.
Using /u/StetsDogg's table at https://airtable.com/shrraH105YVJQF2Yr/tblEszFJtM4p2YEvP/viw85pfNFchbpo9o9 and filter on eSIM=True and Networks=T-Mobile, the only ones are Mint, T-Mobile, and Google Fi. Sorry to confirm your suspicion, but cheapest is T-Mobile connect and Mint. As others said you can get T-Mobile connect 2.5GB plan to start then downgrade to 500MB.
Far Cry: New Dawn currently runs at 30 fps on Stadia, the framerate has nothing to do with the speed (or more importantly the quality) of your internet connection to Stadia servers unfortunately a lot of the old Ubisoft games run at 30
So this has to have been posted before, but I need to share Rob Burbea’s jhāna retreat.
It has been, to my experience, the single most helpful piece of work in practicing samādhi I have ever come across. Even if you’re not interested in practicing the jhānas, his way of conceiving practice in general is incredibly open and intuitive. As one of Rob’s final gifts to the world, it came out as something truly special.
There’s also a transcription of the whole retreat available to read. It’s a large document — a 473 page pdf — but if you read it, I strongly suggest not skipping over any parts. Even if you come up on one of the talks and you read the title and kind of think, “oh I’ve already got a grasp on this bit”, just read it, there will almost certainly be something there for you.
I don't buy 30fps games on Stadia, but there are a few exceptions such as The Crew 2. The Crew 2 felt fine to me but I did try out Ubisoft+ on Stadia recently and I tried out Far Cry 5 and there was no shot I was going to be able to play that on Stadia. Aiming felt so terrible and laggy that I failed the intro chase scene 3 times or something (and no I don't have bad aim on KB&M, and my internet was fine). Also, the game has a lot of graphical glitches pretty often so I'll just play it on PC if I ever want to play it again. Feel free to use this website to see which games are 60fps or have a 60fps mode: https://airtable.com/shrHXaF85D1upSKSs/tblVXkiYyDsFwmiMa
If you're low income, you should also check out Matriculate, a program that will provide one-on-one advising with a trained college student. They're accepting applications for the class of 2022 here: https://airtable.com/shrEbUfHQ95o2ugIX
>Auf diesem Slack sind die Klarnamen ersichtlich. Ebenfalls ist dort wahrscheinlich bekannt, wer r/de-Mod ist, weils nunmal zur Sprache kommen wird wenn Erfahrung mit reddit Teil des Jobs ist.
Da wir hier ja alle ein Interesse an größtmöglicher Transparenz haben, sollte man vielleicht konkretisieren, dass Moderatorentätigigkeiten nicht nur "wahrscheinlich" bekannt sind, weil sie "nunmal zur Sprache kommen", sondern dass Reddit die Teilnahme an dem Programm von vornherein ausschließlich auf deutschsprachige Moderatoren beschränkt hat. Steht ja ausdrücklich so im Stellenprofil:
"Who can apply and who are we looking for?: All moderators who are fluent German speakers are welcomed to apply!"
It's explained right in the article under the section The Motivation. It's a play off of the title of a similar article by CockroachDB called Why we built CockroachDB on top of RocksDB.
>The Motivation
>
>Recently, our friends at CockroachDB wrote about why they use RocksDB.
​
Cloud Spanner has a high entry point. A single Node will cost you $650 per month and Google recommends at least three. So your project has to be big enough to justify this price tag. If you don’t mind to self host there is an open source alternative to spanner: https://www.cockroachlabs.com My Team and i faced exactly this problem. We wanted an SQL database that is scalable and resilient. But the entry point and the fact that it would alter out local development flow, drove us away from Spanner and we went with cockroachedb (pretty happy till now)
http://www.sqlite.org/amalgamation.html says it's 90kloc if you remove comments and blanks.
Yeah, I also didn't realize it was so small. 140kloc is quite practical to read completely in a reasonable amount of time.
check out SQLite. It's not on github and it's not iOS or objective C, but for a project of it's complexity, SQLite is clean and nice.
the best way to step up your game is to refactor your existing code. If you have some iOS projects that you are working on, write some unit tests and start refactoring your code base. start with the part of the project that was the biggest pain in your ass. chances are that was the pain of a weak design. your refactoring efforts will be the most productive there.
you can start small. make changes that make the code more readable and "self documenting". next decouple classes and responsibilities. start incorporating design patterns. make lots of small changes, checked by unit tests every step of the way. Don't move on to a new refactoring until you are confident that your changes had a net zero effect.
~~Concurrent writes only, as I understand it~~ See edit and it could be a big deal for wiki. But I'm curious as to what real benchmarks say. This is what they claim.
> SQLite usually will work great as the database engine for low to medium traffic websites (which is to say, 99.9% of all websites). The amount of web traffic that SQLite can handle depends, of course, on how heavily the website uses its database. Generally speaking, any site that gets fewer than 100K hits/day should work fine with SQLite. The 100K hits/day figure is a conservative estimate, not a hard upper bound. SQLite has been demonstrated to work with 10 times that amount of traffic.
EDIT: on currency:
> SQLite uses reader/writer locks on the entire database file. That means if any process is reading from any part of the database, all other processes are prevented from writing any other part of the database. Similarly, if any one process is writing to the database, all other processes are prevented from reading any other part of the database. For many situations, this is not a problem. Each application does its database work quickly and moves on, and no lock lasts for more than a few dozen milliseconds. But there are some applications that require more concurrency, and those applications may need to seek a different solution.
I have heard such a data structure being called a sum tree. PostgreSQL uses a similar concept of max tree to find free space for new riws.
Do you have an idea how your data structure should cope with MVCC? More specifically the MVCC implementation of PostgreSQL means that concurrent versions of rows have separate index tuples and you have to check the row header to figure out which one is visible to your snapshot.
I guess for your use case of randomly picking a row a retry loop that discards invisible rows would work. Then you have to deal with the next issue - how do you deal with new entries being inserted while you are traversing the tree. You could get a SHARE lock on the table, blocking out concurrent modifications, but that will make concurrency suck.
The good news is that you can probably use the GIST index extensibility, or even better SP-GIST, to have a properly WAL logged implementation of your access method.