Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Activity for manassehkatzâ€
| Type | On... | Excerpt | Status | Date |
|---|---|---|---|---|
| Answer | — |
A: Would a MySQL database run more efficiently with smaller varchar lengths? YES or NO: It all depends on the storage engine Fairly universally, though IIRC from looking at PostgreSQL a while back, PostgreSQL may not even do that, there is a difference between CHAR/VARCHAR/BINARY/BLOB/TEXT etc. types based on declared size, where 1, 2 or 4 bytes are used to store the actua... (more) |
— | over 3 years ago |
| Edit | Post #278468 | Post edited | — | over 3 years ago |
| Suggested Edit | Post #278468 |
Suggested edit: typo - resusts -> results (more) |
helpful | over 3 years ago |
| Edit | Post #278109 | Initial revision | — | over 3 years ago |
| Answer | — |
A: Should a salt be stored in the same database as the hash? When I first learned about salting, I thought the same thing. But as I understand it, because each salt is unique (or substantially unique within a given database table), storing the salt & hash together does not open you up to a rainbow attack. On the other hand, if they are stored separately (separ... (more) |
— | over 3 years ago |
| Edit | Post #277531 | Initial revision | — | over 3 years ago |
| Answer | — |
A: How does the community feel about resource requests? I think these kinds of questions are fine, but I am just one person. open source product I have been using appears to be poorly-documented is an extremely common problem. I have actually seen the problem even on some paid products. So searching for help that should be in a project's documentation ... (more) |
— | over 3 years ago |
| Edit | Post #277473 | Initial revision | — | over 3 years ago |
| Answer | — |
A: Can renaming a MySQL column be sped up by dropping indexes or foreign keys? I would simply turn off foreign key checks: SET FOREIGNKEYCHECKS=0; and make all the changes, and then turn foreign key checks back on: SET FOREIGNKEYCHECKS=1; (more) |
— | over 3 years ago |
| Comment | Post #277367 |
IMHO, configuration files outside Git are the way to go. The only other thing is to make sure they are not in any web-accessible directory - i.e., so that a messed up web page won't get easy access. (more) |
— | over 3 years ago |
| Comment | Post #277148 |
Are the results different if you use **is_excluded = 0** instead of "!= 1"? (more) |
— | over 3 years ago |
| Comment | Post #277148 |
Use *EXPLAIN* to get some more details and (unless that results in a quick solution to the problem) post that information here. https://dev.mysql.com/doc/refman/8.0/en/using-explain.html (more) |
— | over 3 years ago |
| Edit | Post #277144 | Initial revision | — | over 3 years ago |
| Question | — |
Initial List of Tags As far as I can tell, there are no tags yet for the main Q&A. I suggest setting an initial group of tags which help organize questions. Two groups I think would be particularly helpful are languages and topics. For languages, there seem to be a variety of "top n lists", so we can pick one or just... (more) |
— | over 3 years ago |
- ← Previous
- 1
- 2
- Next →