Hello, I have 44 YoE as a SWE. Here's a post I made on LumpedIn, adapted for Reddit... I hope it fosters some thought and conversation.

The latest Microsoft SharePoint vulnerability shows the woefully inadequate state of modern computer science. Let me explain.

"We build applications in an environment designed for running programs. An application is not the same thing as a program - from the operating system's perspective"

When the operating system and it's sidekick the file system were invented they were designed to run one program at a time. That program owned it's data. There was no effective way to work with or look at the data unless you ran the program or wrote a compatible program that understood the data format and knew where to find the data. Applications, back then, were much simpler and somewhat self-contained.

Databases, as we know of them today, did not exist. Furthermore, we did not use the file system to store 'user' data (e.g. your cat photos, etc).

But, databases and the file system unlocked the ability to write complex applications by allowing data to be easily shared among (semi) related programs. The problem is, we're writing applications in an environment designed for programs that own their data. And, in that environment, we are storing user data and business logic that can be easily read and manipulated.

A new paradigm is needed where all user-data and business logic is lifted into a higher level controlled by a relational database. Specifically, a RDBMS that can execute logic (i.e. stored procedures etc.) and is capable of managing BLOBs/CLOBs. This architecture is inherently in-line with what the file-system/operating-system was designed for, running a program that owns it's data (i.e. the database).

The net result is the ability to remove user data and business logic from direct manipulation and access by operating system level tools and techniques. An example of this is removing the ability to use POSIX file system semantics to discover user assets (e.g. do a directory listing). This allows us to use architecture to achieve security goals that can not be realized given how we are writing applications today.

Which database is best for creating saas apps

I'd like your opinions my fellow database redditors.

Does anyone else worry about how AI will effect the future of your job? Ive worked with databases (DBA/SQL BI Dev), but i cant help worry about what it means for me moving forward.

Are you doing anything to AI proof yourself?

OK, I admit I'm a little [rhymes with "moaned"] but I just have to express myself. It's just... it fascinates and freaks me out...

SQLite is everywhere!!! It's on your phone. It's on your computer. It was installed in my rental car. (Somehow I stumbled onto the Linux command line; still don't remember how that happened.) It's orbiting the planet. It's in our refrigerators. It's probably in every toilet in Japan. It's not in teledildonics yet, but the future is bright.

How long until, as with spiders, you're never more than six feet from SQLite?

https://www.404media.co/anyone-can-push-updates-to-the-doge-gov-website-2/

I own https://scabidi.com, and I want to own servers instead of rent them from Hostinger, Is there a way to get servers to show someone else's address, this is just a database I would continue to host the website from Hostinger, but it would connect to my database to get things like users.

EDIT: sorry, the total number is actually 147.

Here's a list. Which ones appear entirely unfamiliar to you?

1. ABORT

2. ACTION

3. ADD

4. AFTER

5. ALL

6. ALTER

7. ANALYZE

8. AND

9. AS

10. ASC

11. ATTACH

12. AUTOINCREMENT

13. BEFORE

14. BEGIN

15. BETWEEN

16. BY

17. CASCADE

18. CASE

19. CAST

20. CHECK

21. COLLATE

22. COLUMN

23. COMMIT

24. CONFLICT

25. CONSTRAINT

26. CREATE

27. CROSS

28. CURRENT_DATE

29. CURRENT_TIME

30. CURRENT_TIMESTAMP

31. DATABASE

32. DEFAULT

33. DEFERRABLE

34. DEFERRED

35. DELETE

36. DESC

37. DETACH

38. DISTINCT

39. DO

40. DROP

41. EACH

42. ELSE

43. END

44. ESCAPE

45. EXCEPT

46. EXCLUDE

47. EXCLUSIVE

48. EXISTS

49. EXPLAIN

50. FAIL

51. FILTER

52. FIRST

53. FOLLOWING

54. FOR

55. FOREIGN

56. FROM

57. FULL

58. GENERATED

59. GLOB

60. GROUP

61. HAVING

62. IF

63. IGNORE

64. IMMEDIATE

65. IN

66. INDEX

67. INDEXED

68. INITIALLY

69. INNER

70. INSERT

71. INSTEAD

72. INTERSECT

73. INTO

74. IS

75. ISNULL

76. JOIN

77. KEY

78. LEFT

79. LIKE

80. LIMIT

81. MATCH

82. MATERIALIZED

83. NATURAL

84. NO

85. NOT

86. NOTHING

87. NOTNULL

88. NULL

89. NULLS

90. OF

91. OFFSET

92. ON

93. OR

94. ORDER

95. OTHERS

96. OUTER

97. OVER

98. PARTITION

99. PLAN

100. PRAGMA

101. PRIMARY

102. QUERY

103. RAISE

104. RECURSIVE

105. REFERENCES

106. REGEXP

107. REINDEX

108. RELEASE

109. RENAME

110. REPLACE

111. RESTRICT

112. RETURNING

113. RIGHT

114. ROLLBACK

115. ROW

116. ROWS

117. SAVEPOINT

118. SELECT

119. SET

120. TABLE

121. TEMP

122. TEMPORARY

123. THEN

124. TO

125. TRANSACTION

126. TRIGGER

127. UNION

128. UNIQUE

129. UPDATE

130. USING

131. VACUUM

132. VALUES

133. VIEW

134. VIRTUAL

135. WHEN

136. WHERE

137. WINDOW

138. WITH

139. WITHOUT

140. FIRST

141. FOLLOWING

142. PRECEDING

143. UNBOUNDED

144. TIES

145. DO

146. FILTER

147. EXCLUDE

Hey everyone, I have an application that performs around 500 write requests per second. I’ve tried both MongoDB and Elasticsearch, but I’m only getting about 200 write requests per minute in performance. Could anyone suggest an alternative database that can handle this kind of write load while still offering good read and viewing capabilities similar to Mongo? Each document is roughly 10 KB in size. I’m specifically looking for self-hosted solutions.

Hello guys I work at a store , and they use a database where i went into the folders of the database and saw that the database is made with excel but when you click a button it takes you to the selected excel for each category and i was wondering how is that possible, which Programme is used

Okay, first of all, i'm taking database for my first semester in university for computer science and i kind of understand this chapter and how to draw the erd but the question genuinely making me second guess myself whether i am right or now.

You might be asking, "why don't you ask your professor for confirmation? " i did... And it just make me more confuse afterwards.

I ask my friends... They haven't done it yet soo

Here the erd i made

And here are the questions

High Press, a universily center, manage the publication and sales of books authored by High staff. Each book has an ISBN, title, type, publication date, price and quantity.A book can have one or more author, and each author can write multiple books. Authors are identified by their ID, name, department or faculty, and status (main author or co-author) Authors may also place orders for books they have written, but they can only order one book title per order Each author order is identified by an order number and includes the order date, status, book ordered and the quantity of books Customers,on the other hand, may order one or more books, with the same or different title. Each customer order is identified by an order number, containing the date ordered, order status, a list of books ordered and the quantity of each book. For each customer, relevant detail such as ID, name, address, and telephone number are recorded. Payments are generated for each order, with additional charges for Postage for customer order , while authors receive a 30% discount on books they have authored, Each payment has attributes such as payment ID, payment date, payment type, total amount, and status, The ERD should capture these relationships and constraints to manage both book publication and sales processes efficiently

Thank you for any help, and sorry if i did something wrong with the image

If so, you've probably looked into DuckDB. There is now a source code mirror of DuckDB that I've called Pygmy Goose (its the smallest species of Duck!).

* Retains only the core duckdb code and unittests. No extensions, data sets etc.
* Runs CI in 5 minutes on Linux, Mac and Windows (ccached runs)
* Agents branch tested to work better with coding agents.

Please check it out and share feedback. Looking for collaborators. May be of interest if you want to reuse DuckDB code in your own database, but want to share the maintenance burden.

Hello Everyone. I wanted to design a database schema design for my personal projects and also i wanted for my future as well. Is there any guide. So that i can follow that. any best practice.

Thanks

I am having a very specific issue: I am building a desktop application, until now I have been using SQLite, but as of recently, I have so many relationships, that I think a graph database would be much better as a persistence layer. However, most graph databases are server-based. I have only found a handful that can be considered portable:

• Cozo: https://github.com/cozodb/cozo

• Kuzu: https://github.com/kuzudb/kuzu (is the name similarity a coincidence?)

• SimpleGraph (SQLite Extension): https://github.com/dpapathanasiou/simple-graph

Of course, XML counts somehow, too, as a graph database, but read-write operations are expensive, especially from file.

Any suggestions on how to proceed? Are the techs above good picks? Should I consider something else?